Element index for package databases
[ a ]
[ b ]
[ c ]
[ d ]
[ e ]
[ f ]
[ g ]
[ i ]
[ j ]
[ l ]
[ m ]
[ n ]
[ o ]
[ p ]
[ q ]
[ r ]
[ s ]
[ t ]
[ u ]
[ v ]
[ _ ]
top
a
- $alias_left
- in file Join.class.php, variable Join::$alias_left
Carries an alias of the tablename of $this->dbt_left.
- $alias_right
- in file Join.class.php, variable Join::$alias_right
Carries an alias of the tablename of $this->dbt_right.
- $auto_increment_field
- in file ABSTDatabaseTable.class.php, variable ABSTDatabaseTable::$auto_increment_field
Holds the fieldname of the auto increment Column.
- ABSTDatabaseHost
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::ABSTDatabaseHost()
Fake-Constructor
- ABSTDatabaseHost
- in file ABSTDatabaseHost.class.php, class ABSTDatabaseHost
- ABSTDatabaseTable
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::ABSTDatabaseTable()
Fake-Constructor
- ABSTDatabaseTable
- in file ABSTDatabaseTable.class.php, class ABSTDatabaseTable
- ABSTView
- in file ABSTView.class.php, class ABSTView
- ABSTView
- in file ABSTView.class.php, method ABSTView::ABSTView()
Fake-Constructor
- addCustomField
- in file ABSTView.class.php, method ABSTView::addCustomField()
This can be use to add a field to the definition of the result list of the query.
- addDB
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::addDB()
Adds a database's reference to this object of a database host.
- addDBT
- in file Database.class.php, method Database::addDBT()
Adds a databasetable's reference to this object of a database.
- addField
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::addField()
Adds a field's reference to this object of a database table.
- addFieldname
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::addFieldname()
Adds a field's reference to this object of a database table.
- addFields
- in file Join.class.php, method Join::addFields()
Adds Fields to this join.
- addJoin
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::addJoin()
Adds a join's reference to this object of a database table.
- addJoin
- in file ABSTView.class.php, method ABSTView::addJoin()
Adds a join's reference to this view's object.
- addView
- in file Database.class.php, method Database::addView()
Adds a view's reference to this object of a database.
- ABSTDatabaseHost.class.php
- procedural page ABSTDatabaseHost.class.php
- ABSTDatabaseTable.class.php
- procedural page ABSTDatabaseTable.class.php
- ABSTView.class.php
- procedural page ABSTView.class.php
- addDB
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::addDB()
Adds a databasetable's reference to this object of a database.
- addFTPData
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::addFTPData()
Adds ftp data to this object. This can be useful for writing dumps if the sever has SAFE MODE restrictions.
top
top
top
d
- $db
- in file ABSTDatabaseHost.class.php, variable ABSTDatabaseHost::$db
Carries the references to objects of databases.
- $dbt
- in file Database.class.php, variable Database::$dbt
Carries the databasetable's objects of this database.
- $dbt_left
- in file Join.class.php, variable Join::$dbt_left
The left databasetable's object of this join.
- $dbt_right
- in file Join.class.php, variable Join::$dbt_right
The right databasetable's object of this join.
- Database
- in file Database.class.php, method Database::Database()
Constructor
- Database
- in file Database.class.php, class Database
- Database.class.php
- procedural page Database.class.php
- delete
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::delete()
Deletes the specified dataset.
- disconnect
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::disconnect()
Closes the current connection to the database server.
- doCSVImport
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::doCSVImport()
Iports data from a csv file. You have to create a CSVFiles-Object first.
- dump
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::dump()
Dumps this Databasehost. If this object has stored ftp data the dump method
- dump
- in file MySQLDatabase.class.php, method MySQLDatabase::dump()
Dumps this Database.
top
top
top
g
- getDatabase
- in file Database.class.php, method Database::getDatabase()
Returns the databasename.
- getDatabaseTables
- in file Database.class.php, method Database::getDatabaseTables()
Returns the array of references to the databasetables.
- getDatasetsWithFields
- in file ABSTView.class.php, method ABSTView::getDatasetsWithFields()
Returns the datasets as an two dimensional array if the query could be execute. The first dimension carries the datasets. The second dimension carries the fields's values of the result list.
- getFieldnames
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getFieldnames()
Returns the table's fieldnames.
- getHost
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::getHost()
Returns the hostname.
- getInsertID
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getInsertID()
Returns the last insert id that was made to the underlying database table.
- getLastQuery
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getLastQuery()
Returns the last stored database query.
- getLastQuery
- in file ABSTView.class.php, method ABSTView::getLastQuery()
Returns the last stored database query.
- getLastQuery
- in file Database.class.php, method Database::getLastQuery()
Returns the last stored database query.
- getName
- in file ABSTView.class.php, method ABSTView::getName()
Returns the name of this view.
- getName
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getName()
Returns the name of the database table.
- getName
- in file Database.class.php, method Database::getName()
Returns the databasename. This method is an alias for the method getDatabase()
- getName
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::getName()
Returns the hostname. This method is an alias of the method getHost().
- getParent
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getParent()
Returns the parent object of this object.
- getPassword
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::getPassword()
Returns the given password which should be usedto connect to the host.
- getPort
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::getPort()
Returns the specified port to use to connect to the host.
- getPrimaryKey
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getPrimaryKey()
This method has to be implement in a subclass!
- getResourceID
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::getResourceID()
Returns the id of the connection resource to the database host.
- getResourceID
- in file ABSTView.class.php, method ABSTView::getResourceID()
Returns the id of the connection resource to the database host.
- getResourceID
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::getResourceID()
Returns the id of the connection resource to the database host.
- getResourceID
- in file Database.class.php, method Database::getResourceID()
Returns the id of the connection resource to the database host.
- getUser
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::getUser()
Returns the specified user who should connect with to the host.
- getViews
- in file Database.class.php, method Database::getViews()
Returns the array of references to the views.
- getArrayOfDataField
- in file MySQLView.class.php, method MySQLView::getArrayOfDataField()
Returns a array of values of a data field.
- getArrayOfDataField
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getArrayOfDataField()
Returns a array of values of a data field.
- getAutoIncrementField
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getAutoIncrementField()
Returns the fieldname of the auto increment field if there is one.
- getCorrectWhere
- in file MySQLView.class.php, method MySQLView::getCorrectWhere()
Returns the correct where clause from given where concate the fixed where.
- getCount
- in file MySQLView.class.php, method MySQLView::getCount()
Returns the count of datasets.
- getCount
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getCount()
Returns the count of the fields in the where clause.
- getCreateOrder
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getCreateOrder()
Returns an SQL-string to create this table. You can give a new name for creating the table.
- getDataOrder
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getDataOrder()
Returns an SQL-string to fill this table. You can give a new name for the table to insert in.
- getDatasets
- in file MySQLView.class.php, method MySQLView::getDatasets()
Returns the datasets as an array if the query could be execute.
- getDatasets
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getDatasets()
This method is an alias for the method "getDatasetsWithFields".
- getDatasetsWithFields
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getDatasetsWithFields()
Returns the datasets as an two dimensional array if the query could be execute. The first dimension carries the datasets. The second dimension carries the fields's values of the result list.
- getDatasetsWithFields
- in file MySQLView.class.php, method MySQLView::getDatasetsWithFields()
Returns the datasets as an two dimensional array if the query could be execute. The first dimension carries the datasets. The second dimension carries the fields's values of the result list.
- getDatasetsWithPrimaryToMultiple
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getDatasetsWithPrimaryToMultiple()
Returns the datasets as array with the values of the primary key as index.
- getDatasetsWithPrimaryToMultiple
- in file MySQLView.class.php, method MySQLView::getDatasetsWithPrimaryToMultiple()
Returns the datasets as array with the values of the primary key as index.
- getDatasetsWithPrimaryToValue
- in file MySQLView.class.php, method MySQLView::getDatasetsWithPrimaryToValue()
Returns the datasets as array with the values of the primary key as index.
- getDatasetsWithPrimaryToValue
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getDatasetsWithPrimaryToValue()
Returns the datasets as array with the values of the primary key as index.
- getDump
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getDump()
Returns an SQL-DUMP.
- getFieldnames
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getFieldnames()
Returns the table's fieldnames. If you want you can get the fieldnames enclosed in backticks.
- getJoinOrder
- in file MySQLView.class.php, method MySQLView::getJoinOrder()
Returns the order to join the database tables in the query.
- getMaxOf
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getMaxOf()
Returns the maximum value from a field.
- getMinOf
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getMinOf()
Returns the minimum value from a field.
- getPrimaryKey
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getPrimaryKey()
Returns all field members of the primary key of this database table.
- getRealFieldnames
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getRealFieldnames()
Returns the table's fieldnames independence of overruled fieldnames. If you want you can get the fieldnames enclosed in backticks.
- getSingleDataFieldValue
- in file MySQLView.class.php, method MySQLView::getSingleDataFieldValue()
Returns a single value of a data field.
- getSingleDataFieldValue
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getSingleDataFieldValue()
Returns a single value of a data field.
- getSingleDataset
- in file MySQLView.class.php, method MySQLView::getSingleDataset()
Returns a single dataset as an array if the query could be execute.
- getSingleDataset
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getSingleDataset()
Returns a single dataset as an array if the query could be execute.
- getSumOf
- in file MySQLView.class.php, method MySQLView::getSumOf()
Returns the sum value of a field.
- getSumOf
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::getSumOf()
Returns the sum value of a field.
top
i
- $insert_id
- in file ABSTDatabaseTable.class.php, variable ABSTDatabaseTable::$insert_id
Stores the last insert id of the underlying database table.
- $is_connected
- in file ABSTDatabaseHost.class.php, variable ABSTDatabaseHost::$is_connected
The connection's state of the databasehost.
- import
- in file MySQLDatabase.class.php, method MySQLDatabase::import()
Imports a given SQL-string into this Database.
- importDump
- in file MySQLDatabase.class.php, method MySQLDatabase::importDump()
Imports Dumps from given source to this database.
- importDump
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::importDump()
Researches a whole folder to import dumped data from it.
- importSingleDump
- in file MySQLDatabase.class.php, method MySQLDatabase::importSingleDump()
Researches a whole folder to import dumped data from it.
- insert
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::insert()
Inserts the specified dataset. Note that this function will create a global variable $GLOBALS["insert_id"] which contains the result of mysql_insert_id();
top
j
- $join
- in file ABSTView.class.php, variable ABSTView::$join
Array for carrying the joins included in this view.
- Join.class.php
- procedural page Join.class.php
- Join
- in file Join.class.php, method Join::Join()
Constructor
- Join
- in file Join.class.php, class Join
top
l
- $last_query
- in file ABSTDatabaseTable.class.php, variable ABSTDatabaseTable::$last_query
Stores the last query made to the underlying database table.
- $last_query
- in file Database.class.php, variable Database::$last_query
The last stored databasequery.
- $last_query
- in file ABSTView.class.php, variable ABSTView::$last_query
The last stored databasequery.
- $left_field
- in file Join.class.php, variable Join::$left_field
Carries the left fieldnames of this join.
- $logical_operator
- in file Join.class.php, variable Join::$logical_operator
Carries the logical operators between the relational statements in the "ON"-Clause of the join.
top
m
- MySQLDatabase.class.php
- procedural page MySQLDatabase.class.php
- MySQLDatabaseHost.class.php
- procedural page MySQLDatabaseHost.class.php
- MySQLDatabaseTable.class.php
- procedural page MySQLDatabaseTable.class.php
- MySQLView.class.php
- procedural page MySQLView.class.php
- MySQL_constants.inc.php
- procedural page MySQL_constants.inc.php
- MySQLDatabase
- in file MySQLDatabase.class.php, class MySQLDatabase
- MySQLDatabase
- in file MySQLDatabase.class.php, method MySQLDatabase::MySQLDatabase()
Constructor
- MySQLDatabaseHost
- in file MySQLDatabaseHost.class.php, class MySQLDatabaseHost
- MySQLDatabaseHost
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::MySQLDatabaseHost()
Constructor
- MySQLDatabaseTable
- in file MySQLDatabaseTable.class.php, class MySQLDatabaseTable
- MySQLDatabaseTable
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::MySQLDatabaseTable()
Constructor
- MySQLView
- in file MySQLView.class.php, class MySQLView
- MySQLView
- in file MySQLView.class.php, method MySQLView::MySQLView()
Constructor
- MYSQL_OUTPUT_ASSOC
- in file MySQL_constants.inc.php, constant MYSQL_OUTPUT_ASSOC
Used as flag in serveral Methods of this class to get a result array in a special kind. This effects that the result array will output as an associative array.
- MYSQL_OUTPUT_DEFAULT
- in file MySQL_constants.inc.php, constant MYSQL_OUTPUT_DEFAULT
Used as flag in serveral Methods of this class to get a result array in a special kind. This is the default value. It effects that the result array will output as a mixture of an associative and a index based array.
- MYSQL_OUTPUT_NUM
- in file MySQL_constants.inc.php, constant MYSQL_OUTPUT_NUM
Used as flag in serveral Methods of this class to get a result array in a special kind. This effects that the result array will output as an index based array.
top
top
o
- $overruled_fieldnames
- in file ABSTDatabaseTable.class.php, variable ABSTDatabaseTable::$overruled_fieldnames
Shows whether the fieldnames are overruled.
- overruleFieldnames
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::overruleFieldnames()
Overrules the table's fieldnames. The given array should contain the comma separated list of the query between the keywords SELECT and FROM.
top
p
- $parent
- in file Database.class.php, variable Database::$parent
Refers to the databasehost in which this database lies.
- $parent
- in file ABSTDatabaseTable.class.php, variable ABSTDatabaseTable::$parent
Refers to the database in which this relation lies.
- $password
- in file ABSTDatabaseHost.class.php, variable ABSTDatabaseHost::$password
The password to log on the database server.
- $port
- in file ABSTDatabaseHost.class.php, variable ABSTDatabaseHost::$port
The connection's port.
- $primary_key
- in file ABSTDatabaseTable.class.php, variable ABSTDatabaseTable::$primary_key
Holds the field members of the primary key of this table object.
- probeConnection
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::probeConnection()
Probes whether there is a connection to the databasehost, if not it will attempt to connect to the host.
- probeConnection
- in file MySQLDatabase.class.php, method MySQLDatabase::probeConnection()
Probes whether there is a connection to the databasehost, if not it will attempt to connect to the host.
- putSingleDatasetIntoGetVars
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::putSingleDatasetIntoGetVars()
Puts a single dataset into "get"-variables. The names of the "get"-vars accord to the fieldnames of the Databasetable.
- putSingleDatasetIntoPostVars
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::putSingleDatasetIntoPostVars()
Puts a single dataset into "post"-variables. The names of the "Post"-vars accord to the fieldnames of the Databasetable.
- putSingleDatasetIntoRequestVars
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::putSingleDatasetIntoRequestVars()
Puts a single dataset into request-variables. The names of the request-vars
top
top
top
s
- setConnectionErrorCallback
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::setConnectionErrorCallback()
Sets the name of the function that should be invoked on a connection error.
- setCustomFields
- in file ABSTView.class.php, method ABSTView::setCustomFields()
Sets additionally fields to the definition of the result list of the query.
- setErrorCallback
- in file ABSTView.class.php, method ABSTView::setErrorCallback()
Sets the name of the function that should be invoked on a connection error.
- setErrorCallback
- in file Database.class.php, method Database::setErrorCallback()
Sets the name of the function that should be invoked on a connection error.
- setHost
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::setHost()
Sets the hostname.
- setName
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::setName()
Sets the name of the databasetable.
- setName
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::setName()
Sets the hostname. This method is an alias of the method setHost( $string ).
- setParent
- in file Database.class.php, method Database::setParent()
Sets the parent of this object.
- setParent
- in file ABSTDatabaseTable.class.php, method ABSTDatabaseTable::setParent()
Sets the parent of this object.
- setPassword
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::setPassword()
Sets the password that should be used to connect to the host.
- setPort
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::setPort()
Specifies the port that should be used to connect to the host.
- setType
- in file Join.class.php, method Join::setType()
Sets the type of join. Has to be INNER, CROSS, LEFT [OUTER], RIGHT [OUTER] or NATURAL [LEFT | RIGTH [OUTER]]
- setUser
- in file ABSTDatabaseHost.class.php, method ABSTDatabaseHost::setUser()
Specifies the user who should connect with to the host.
- swapLeftRight
- in file Join.class.php, method Join::swapLeftRight()
Swaps the left-right definition. The reference from the left table moves to the reference of the right database table and the other way around.
- setFixedWhere
- in file MySQLView.class.php, method MySQLView::setFixedWhere()
Sets the condition of first priority.
- setPersistantConnection
- in file MySQLDatabaseHost.class.php, method MySQLDatabaseHost::setPersistantConnection()
Sets whether a persistant connection should be use.
- storeFieldFlags
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::storeFieldFlags()
Stores the Flags: (!)not_null <=> $this->field_can_be_null[FIELDINDEX], primary_key <=> $this->field_is_primary_member[FIELDINDEX], auto_increment <=> $this->field_has_auto_increment[FIELDINDEX]. This is necessary to get dump of the table data.
- storeFieldnames
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::storeFieldnames()
Stores the names of fields in this object.
- swapFieldValuesOf
- in file MySQLDatabaseTable.class.php, method MySQLDatabaseTable::swapFieldValuesOf()
Swaps values of a specified field in two tupel.
top
t
- $type
- in file Join.class.php, variable Join::$type
Carries the type of join. Can be INNER, CROSS, LEFT [OUTER], RIGHT [OUTER] or NATURAL [LEFT | RIGTH [OUTER]]. The Standard is LEFT, because it was the only used join in the past.
top
top
v
- $view
- in file Database.class.php, variable Database::$view
Carryies the view's objects of this database.
top
|
|
