Joomla Database functions
Query fuctions
//echo $query->__toString() ;
Database fuctions
/* @return int The number of rows returned from the most recent query. */
function getNumRows( $cur=null )
/* This method loads the first field of the first row returned by the query. * @return The value returned in the query or null if the query failed. */
function loadResult()
/* Load an array of single field results into an array */
function loadResultArray($numinarray = 0)
/*Fetch a result row as an associative array */
function loadAssoc()
/* Load a assoc list of database rows * @return array If <var>key</var> is empty as sequential list of returned records. */
function loadAssocList( $key='' )
/*This global function loads the first row of a query into an object */
function loadObject( )
/*Load a list of database objects * * If <var>key</var> is not empty then the returned array is indexed by the value * the database key. Returns <var>null</var> if the query fails.
- @return array If <var>key</var> is empty as sequential list of returned records.
- /
function loadObjectList( $key='' )
/* * @return The first row of the query. */
function loadRow()
/** * Load a list of database rows (numeric column indexing) */
function loadRowList( $key=null )
/** * Inserts a row into a table based on an objects properties * * @access public * @param string The name of the table * @param object An object whose properties match table fields * @param string The name of the primary key. If provided the object property is updated. */
function insertObject( $table, &$object, $keyName = NULL )
/** * Description * * @access public * @param [type] $updateNulls */
function updateObject( $table, &$object, $keyName, $updateNulls=true )
/** Description */
function insertid()
{
return mysql_insert_id( $this->_resource );
}/** Description */
function getVersion()
{
return mysql_get_server_info( $this->_resource );
}/** * @return array A list of all the tables in the database */
function getTableList()
/** * Shows the CREATE TABLE statement that creates the given tables */
function getTableCreate( $tables )
/** * Retrieves information about the given tables * @param array|string A table name or a list of table names * @param boolean Only return field types, default true * @return array An array of fields by table */