JDatabase
From Joomla! Documentation
Revision as of 17:14, 22 March 2010 by Doxiki (talk | contribs) (New page: <span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki>
</span>
{{Description:JDatabase}}
===Defined in===
l...)
Revision as of 17:14, 22 March 2010 by Doxiki (talk | contribs) (New page: <span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki>
</span>
{{Description:JDatabase}}
===Defined in===
l...)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
The "API15" 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:JDatabase
Defined in[edit]
libraries/joomla/database/database.php
Methods[edit]
Method name | Description |
---|---|
__construct | Database object constructor |
getInstance | Returns a reference to the global Database object, only creating it if it doesn't already exist. |
__destruct | Database object destructor |
getConnectors | Get the database connectors |
connected | Determines if the connection to the server is active. |
hasUTF | Determines UTF support |
setUTF | Custom settings for UTF support |
addQuoted | Adds a field or array of field names to the list that are to be quoted |
splitSql | Splits a string of queries into an array of individual queries |
isQuoted | Checks if field name needs to be quoted |
debug | Sets the debug level on or off |
getUTFSupport | Get the database UTF-8 support |
getErrorNum | Get the error number |
getErrorMsg | Get the error message |
getEscaped | Get a database escaped string |
getLog | Get a database error log |
getTicker | Get the total number of queries made |
nameQuote | Quote an identifier name (field, table, etc) |
getPrefix | Get the database table prefix |
getNullDate | Get the database null date |
setQuery | Sets the SQL query string for later execution. |
replacePrefix | This function replaces a string identifier $prefix with the string held is the _table_prefix class variable. |
getQuery | Get the active query |
query | Execute the query |
getAffectedRows | Get the affected rows by the most recent query |
queryBatch | Execute a batch query |
explain | Diagnostic function |
getNumRows | Get the number of rows returned by the most recent query |
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 associactive 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 | Load the first row returned by the query |
loadRowList | Load a list of database rows (numeric column indexing) |
insertObject | Inserts a row into a table based on an objects properties |
updateObject | Update an object in the database |
stderr | Print out an error statement |
insertid | Get the ID generated from the previous INSERT operation |
getCollation | Get the database collation |
getVersion | Get the version of the database connector |
getTableList | List tables in a database |
getTableCreate | Shows the CREATE TABLE statement that creates the given tables |
getTableFields | Retrieves information about the given tables |
Quote | Get a quoted database escaped string |
GetCol | ADODB compatability function |
Execute | ADODB compatability function |
SelectLimit | ADODB compatability function |
PageExecute | ADODB compatability function |
GetRow | ADODB compatability function |
GetOne | ADODB compatability function |
BeginTrans | ADODB compatability function |
RollbackTrans | ADODB compatability function |
CommitTrans | ADODB compatability function |
ErrorMsg | ADODB compatability function |
ErrorNo | ADODB compatability function |
GenID | ADODB compatability function |
test | Test to see if the MySQLi connector is available |
Importing[edit]
jimport( 'joomla.database.database' );
[Edit See Also] Template:SeeAlso:JDatabase
Examples[edit]
<CodeExamplesForm />