201601.25
Désactivé
0

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
 */

function getTableFields( $tables, $typeonly = true )