JDatabaseMySQL
MySQL database driver
Located in /joomla/database/database/mysql.php (line 25)
JObject (Subpackage Base) JDatabase JDatabaseMySQL (Subpackage Database)
Inherited Variables
Inherited from JDatabase
JDatabase::$_cursor
JDatabase::$_debug
JDatabase::$_errorMsg
JDatabase::$_errorNum
JDatabase::$_hasQuoted
JDatabase::$_limit
JDatabase::$_log
JDatabase::$_offset
JDatabase::$_quoted
JDatabase::$_resource
JDatabase::$_sql
JDatabase::$_table_prefix
JDatabase::$_ticker
JDatabase::$_utf
Database object constructor
- string $host: Database host
- string $user: Database user name
- string $pass: Database user password
- string $db: Database name
- string $table_prefix: Common prefix for all tables
- JDatabase::__construct()
- Database object constructor
Diagnostic function
- JDatabase::explain()
- Diagnostic function
- JDatabase::getAffectedRows()
- Get the affected rows by the most recent query
Assumes database collation in use by sampling one text field in one table
- JDatabase::getCollation()
- Get the database collation
Get a database escaped string
- $text
- JDatabase::getEscaped()
- Get a database escaped string
- $cur
- JDatabase::getNumRows()
- Get the number of rows returned by the most recent query
- array $tables: A list of table names
- array $tables: A list of table names
- JDatabase::getTableFields()
- List database table fields
- JDatabase::getTableList()
- List tables in a database
- JDatabase::getVersion()
- Get the version of the database connector
Determines UTF support
- JDatabase::hasUTF()
- Determines UTF support
- JDatabase::insertid()
- Get the ID generated from the previous INSERT operation
Inserts a row into a table based on an objects properties
- string $table: The name of the table
- object An &$object: object whose properties match table fields
- string $keyName: The name of the primary key. If provided the object property is updated.
- JDatabase::insertObject()
- Inserts a row into a table based on an objects properties
Fetch a result row as an associative array
return array
- JDatabase::loadAssoc()
- Fetch a result row as an associative array
Load a assoc list of database rows
- string $key: The field name of a primary key
- JDatabase::loadAssocList()
- Load a associactive list of database rows
This global function loads the first row of a query into an object
return object
- JDatabase::loadObject()
- This global function loads the first row of a query into an object
Load a list of database objects
- string $key: The field name of a primary key
- JDatabase::loadObjectList()
- Load a list of database objects
This method loads the first field of the first row returned by the query.
- JDatabase::loadResult()
- This method loads the first field of the first row returned by the query.
Load an array of single field results into an array
- $numinarray
- JDatabase::loadResultArray()
- Load an array of single field results into an array
- JDatabase::loadRow()
- Load the first row returned by the query
Load a list of database rows (numeric column indexing)
- string $key: The field name of a primary key
- JDatabase::loadRowList()
- Load a list of database rows (numeric column indexing)
Execute the query
- JDatabase::query()
- Execute the query
Execute a batch query
- $abort_on_error
- $p_transaction_safe
- JDatabase::queryBatch()
- Execute a batch query
Custom settings for UTF support
- JDatabase::setUTF()
- Custom settings for UTF support
Document::db_updateObject()
- [type] $updateNulls
- $table
- &$object
- $keyName
- JDatabase::updateObject()
- Update ab object in the database
Inherited Methods
Inherited From JDatabase
JDatabase::__construct()
JDatabase::addQuoted()
JDatabase::BeginTrans()
JDatabase::CommitTrans()
JDatabase::debug()
JDatabase::ErrorMsg()
JDatabase::ErrorNo()
JDatabase::Execute()
JDatabase::explain()
JDatabase::GenID()
JDatabase::getAffectedRows()
JDatabase::GetCol()
JDatabase::getCollation()
JDatabase::getErrorMsg()
JDatabase::getErrorNum()
JDatabase::getEscaped()
JDatabase::getInstance()
JDatabase::getNullDate()
JDatabase::getNumRows()
JDatabase::GetOne()
JDatabase::getPrefix()
JDatabase::getQuery()
JDatabase::GetRow()
JDatabase::getTableCreate()
JDatabase::getTableFields()
JDatabase::getTableList()
JDatabase::getUTFSupport()
JDatabase::getVersion()
JDatabase::hasUTF()
JDatabase::insertid()
JDatabase::insertObject()
JDatabase::isQuoted()
JDatabase::loadAssoc()
JDatabase::loadAssocList()
JDatabase::loadObject()
JDatabase::loadObjectList()
JDatabase::loadResult()
JDatabase::loadResultArray()
JDatabase::loadRow()
JDatabase::loadRowList()
JDatabase::nameQuote()
JDatabase::PageExecute()
JDatabase::query()
JDatabase::queryBatch()
JDatabase::Quote()
JDatabase::replacePrefix()
JDatabase::RollbackTrans()
JDatabase::SelectLimit()
JDatabase::setQuery()
JDatabase::setUTF()
JDatabase::stderr()
JDatabase::updateObject()
Inherited From JObject
JObject::JObject()
JObject::__construct()
JObject::get()
JObject::getPublicProperties()
JObject::set()
JObject::toString()
Documentation generated on Mon, 05 Mar 2007 21:11:35 +0000 by phpDocumentor 1.3.1