Docs For Class MDB2

MDB2_Extended MDB2_Extended(

$db_index)

Constructor

Parameters:

$db_index —

[ Top ]

mixed &autoExecute(
string
$table, array
$fields_values, [array
$types = null], [array
$param_types = null], [int
$mode = MDB2_AUTOQUERY_INSERT], [string
$where = false], [mixed
$result_class = false])

Make automaticaly an insert or update query and call prepare() and executeParams() with it

Return: a new MDB2_Result or a MDB2 Error Object when fail
See: MDB2_Extended::buildManipSQL()
See: MDB2_Extended::autoPrepare()
Access: public

Parameters:

string	`$table`	—	name of the table
array	`$fields_values`	—	assoc ($key=>$value) where $key is a field name and $value its value
array	`$types`	—	array that contains the types of the columns in the result set
int	`$mode`	—	type of query to make (MDB2_AUTOQUERY_INSERT or MDB2_AUTOQUERY_UPDATE)
array	`$param_types`	—	array that contains the types of the values defined in $params
string	`$where`	—	in case of update queries, this string will be put after the sql WHERE statement
mixed	`$result_class`	—	string which specifies which result class to use

[ Top ]

resource autoPrepare(
string
$table, array
$table_fields, [array
$types = null], [int
$mode = MDB2_AUTOQUERY_INSERT], [string
$where = false])

Make automaticaly an insert or update query and call prepare() with it

Return: handle for the query
See: MDB2_Extended::buildManipSQL()
Access: public

Parameters:

string	`$table`	—	name of the table
array	`$table_fields`	—	ordered array containing the fields names
array	`$types`	—	array that contains the types of the columns in the result set
int	`$mode`	—	type of query to make (MDB2_AUTOQUERY_INSERT or MDB2_AUTOQUERY_UPDATE)
string	`$where`	—	in case of update queries, this string will be put after the sql WHERE statement

[ Top ]

string buildManipSQL(
string
$table, array
$table_fields, int
$mode, [string
$where = false])

Make automaticaly an sql query for prepare()

Example : buildManipSQL('table_sql', array('field1', 'field2', 'field3'), MDB2_AUTOQUERY_INSERT) will return the string : INSERT INTO table_sql (field1,field2,field3) VALUES (?,?,?) NB : - This belongs more to a SQL Builder class, but this is a simple facility

Be carefull ! If you don't give a $where param with an UPDATE query, all the records of the table will be updated !

Return: sql query for prepare()
Access: public

Parameters:

string	`$table`	—	name of the table
array	`$table_fields`	—	ordered array containing the fields names
int	`$mode`	—	type of query to make (MDB2_AUTOQUERY_INSERT or MDB2_AUTOQUERY_UPDATE)
string	`$where`	—	in case of update queries, this string will be put after the sql WHERE statement

[ Top ]

mixed getAll(
string
$query, [array
$types = null], [array
$params = array()], [array
$param_types = null], [integer
$fetchmode = MDB2_FETCHMODE_DEFAULT], [boolean
$rekey = false], [boolean
$force_array = false], [boolean
$group = false])

Fetch all the rows returned from a query.

Return: MDB2_OK or data array on success, a MDB2 error on failure
Access: public

Parameters:

string	`$query`	—	the SQL query
array	`$types`	—	array that contains the types of the columns in the result set
array	`$params`	—	array if supplied, prepare/execute will be used with this array as execute parameters
array	`$param_types`	—	array that contains the types of the values defined in $params
integer	`$fetchmode`	—	the fetch mode to use
boolean	`$rekey`	—	if set to true, the $all will have the first column as its first dimension
boolean	`$force_array`	—	used only when the query returns exactly two columns. If true, the values of the returned array will be one-element arrays instead of scalars.
boolean	`$group`	—	if true, the values of the returned array is wrapped in another array. If the same key value (in the first column) repeats itself, the values will be appended to this array instead of overwriting the existing values.

[ Top ]

array getAssoc(
string
$query, [array
$types = null], [array
$params = array()], [array
$param_types = null], [
$fetchmode = MDB2_FETCHMODE_ORDERED], [boolean
$force_array = false], [boolean
$group = false])

Fetch the entire result set of a query and return it as an associative array using the first column as the key.

If the result set contains more than two columns, the value will be an array of the values from column 2-n. If the result set contains only two columns, the returned value will be a scalar with the value of the second column (unless forced to an array with the $force_array parameter). A MDB error code is returned on errors. If the result set contains fewer than two columns, a MDB2_ERROR_TRUNCATED error is returned.

For example, if the table 'mytable' contains:

ID TEXT DATE --------------------------------

'one' 944679408
'two' 944679408
'three' 944679408

Then the call getAssoc('SELECT id,text FROM mytable') returns: array( '1' => 'one', '2' => 'two', '3' => 'three', )

...while the call getAssoc('SELECT id,text,date FROM mytable') returns: array( '1' => array('one', '944679408'), '2' => array('two', '944679408'), '3' => array('three', '944679408') )

If the more than one row occurs with the same value in the first column, the last row overwrites all previous ones by default. Use the $group parameter if you don't want to overwrite like this. Example:

getAssoc('SELECT category,id,name FROM mytable', null, null MDB2_FETCHMODE_ASSOC, false, true) returns: array( '1' => array(array('id' => '4', 'name' => 'number four'), array('id' => '6', 'name' => 'number six') ), '9' => array(array('id' => '4', 'name' => 'number four'), array('id' => '6', 'name' => 'number six') ) )

Keep in mind that database functions in PHP usually return string values for results regardless of the database's internal type.

Return: associative array with results from the query.
Access: public

Parameters:

string	`$query`	—	the SQL query
array	`$types`	—	array that contains the types of the columns in the result set
array	`$params`	—	array if supplied, prepare/execute will be used with this array as execute parameters
array	`$param_types`	—	array that contains the types of the values defined in $params
boolean	`$force_array`	—	used only when the query returns exactly two columns. If TRUE, the values of the returned array will be one-element arrays instead of scalars.
boolean	`$group`	—	if TRUE, the values of the returned array is wrapped in another array. If the same key value (in the first column) repeats itself, the values will be appended to this array instead of overwriting the existing values.
	`$fetchmode`	—

[ Top ]

mixed getCol(
string
$query, [string
$type = null], [array
$params = array()], [array
$param_types = null], [mixed
$colnum = 0])

Fetch a single column from a result set and return it as an indexed array.

Return: MDB2_OK or data array on success, a MDB2 error on failure
Access: public

Parameters:

string	`$query`	—	the SQL query
string	`$type`	—	string that contains the type of the column in the result set
array	`$params`	—	array if supplied, prepare/execute will be used with this array as execute parameters
array	`$param_types`	—	array that contains the types of the values defined in $params
mixed	`$colnum`	—	which column to return

[ Top ]

mixed getOne(
string
$query, [string
$type = null], [array
$params = array()], [array
$param_types = null])

Fetch the first column of the first row of data returned from a query. Takes care of doing the query and freeing the results when finished.

Return: MDB2_OK or value on success, a MDB2 error on failure
Access: public

Parameters:

string	`$query`	—	the SQL query
string	`$type`	—	string that contains the type of the column in the result set
array	`$params`	—	if supplied, prepare/execute will be used with this array as execute parameters
array	`$param_types`	—	array that contains the types of the values defined in $params

[ Top ]

mixed getRow(
string
$query, [array
$types = null], [array
$params = array()], [array
$param_types = null], [integer
$fetchmode = MDB2_FETCHMODE_DEFAULT])

Fetch the first row of data returned from a query. Takes care of doing the query and freeing the results when finished.

Return: MDB2_OK or data array on success, a MDB2 error on failure
Access: public

Parameters:

string	`$query`	—	the SQL query
array	`$types`	—	array that contains the types of the columns in the result set
array	`$params`	—	array if supplied, prepare/execute will be used with this array as execute parameters
array	`$param_types`	—	array that contains the types of the values defined in $params
integer	`$fetchmode`	—	the fetch mode to use

[ Top ]

mixed &limitQuery(
string
$query, mixed
$types, integer
$count, [integer
$from = 0], [mixed
$result_class = false])

Generates a limited query

Return: a valid ressource pointer or a MDB2 Error Object
Access: public

Parameters:

string	`$query`	—	query
mixed	`$types`	—	array that contains the types of the columns in the result set
integer	`$from`	—	the row to start to fetching
integer	`$count`	—	the numbers of rows to fetch
mixed	`$result_class`	—	string which specifies which result class to use

[ Top ]

Class: MDB2_Extended

Class Overview

Author(s):

Variables

Methods

Inherited Variables

Inherited Methods

Class Details

Class Variables

$db_index =

Method Detail

MDB2_Extended (Constructor) [line 76]

Parameters:

autoExecute [line 125]

Parameters:

autoPrepare [line 97]

Parameters:

buildManipSQL [line 154]

Parameters:

getAll [line 379]

Parameters:

getAssoc [line 478]

Parameters:

getCol [line 328]

Parameters:

getOne [line 243]

Parameters:

getRow [line 285]

Parameters:

limitQuery [line 213]

Parameters: