Difference between revisions of "JDatabaseMySQL"
From Joomla! Documentation
m (Reverted edits by MaxineBlankenship (talk) to last revision by Doxiki) |
|||
Line 63: | Line 63: | ||
|- | |- | ||
|[[API16:JDatabaseMySQL/loadAssocList|loadAssocList]] | |[[API16:JDatabaseMySQL/loadAssocList|loadAssocList]] | ||
− | |Load a assoc list of database rows | + | |Load a assoc list of database rows. |
|- | |- | ||
|[[API16:JDatabaseMySQL/loadObject|loadObject]] | |[[API16:JDatabaseMySQL/loadObject|loadObject]] |
Revision as of 11:55, 17 January 2012
The "API16" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.
[Edit Descripton] Template:Description:JDatabaseMySQL
Defined in[edit]
libraries/joomla/database/database/mysql.php
Methods[edit]
Method name | Description |
---|---|
__construct | Database object constructor |
__destruct | Database object destructor |
test | Test to see if the MySQL connector is available |
connected | Determines if the connection to the server is active. |
select | Select a database for use |
hasUTF | Determines UTF support |
setUTF | Custom settings for UTF support |
getEscaped | Get a database escaped string |
query | Execute the query |
getAffectedRows | int The number of affected rows in the previous operation
1.0.5 |
queryBatch | Execute a batch query |
explain | Diagnostic function |
getNumRows | Description |
loadResult | This method loads the first field of the first row returned by the query. |
loadResultArray | Load an array of single field results into an array |
loadAssoc | Fetch a result row as an associative array |
loadAssocList | Load a assoc list of database rows. |
loadObject | This global function loads the first row of a query into an object. |
loadObjectList | Load a list of database objects |
loadRow | Description |
loadRowList | Load a list of database rows (numeric column indexing) |
loadNextRow | Load the next row returned by the query. |
loadNextObject | Load the next row returned by the query. |
insertObject | Inserts a row into a table based on an objects properties |
updateObject | Description |
insertid | Description |
getVersion | Description |
getCollation | Assumes database collation in use by sampling one text field in one table |
getTableList | Description |
getTableCreate | Shows the CREATE TABLE statement that creates the given tables |
getTableFields | Retrieves information about the given tables |
Importing[edit]
jimport( 'joomla.database.database.mysql' );
[Edit See Also] Template:SeeAlso:JDatabaseMySQL
Examples[edit]
<CodeExamplesForm />