Class: MDB2_Extended
Source Location: /MDB2-2.0.0beta4/MDB2/Extended.php
MDB2_Extended: class which adds several high level methods to MDB2
Author(s):
|
|
|
Inherited Variables
|
Inherited Methods
|
Class Details
Class Variables
Method Detail
MDB2_Extended (Constructor) [line 80]
MDB2_Extended MDB2_Extended(
$db_index)
|
|
Parameters:
__construct (Constructor) [line 75]
MDB2_Extended __construct(
$db_index)
|
|
Constructor
Parameters:
autoExecute [line 132]
mixed &autoExecute(
string
$table, array
$fields_values, [int
$mode = MDB2_AUTOQUERY_INSERT], [string
$where = false], [mixed
$types = null], [mixed
$result_types = null], [mixed
$result_class = true])
|
|
Make automaticaly an insert or update query and call prepare() and execute() with it
Parameters:
autoPrepare [line 102]
resource autoPrepare(
string
$table, array
$table_fields, [int
$mode = MDB2_AUTOQUERY_INSERT], [string
$where = false], [mixed
$types = null], [mixed
$result_types = null])
|
|
Make automaticaly an insert or update query and call prepare() with it
Parameters:
buildManipSQL [line 166]
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 !
Parameters:
executeMultiple [line 520]
mixed executeMultiple(
&$stmt, [array
$params = null], resource
$stmt)
|
|
This function does several execute() calls on the same statement handle. $params must be an array indexed numerically from 0, one execute call is done for every 'row' in the array. If an error occurs during execute(), executeMultiple() does not execute the unfinished rows, but rather returns that error.
Parameters:
getAll [line 376]
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.
Parameters:
getAssoc [line 476]
array getAssoc(
string
$query, [array
$types = null], [array
$params = array()], [array
$param_types = null], [
$fetchmode = MDB2_FETCHMODE_DEFAULT], [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.
Parameters:
getCol [line 323]
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.
Parameters:
getOne [line 234]
mixed getOne(
string
$query, [string
$type = null], [array
$params = array()], [array
$param_types = null], [mixed
$colnum = 0])
|
|
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.
Parameters:
getRow [line 279]
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.
Parameters:
limitQuery [line 205]
mixed &limitQuery(
string
$query, mixed
$types, integer
$count, [integer
$from = 0], [mixed
$result_class = true])
|
|
Generates a limited query
Parameters:
Documentation generated on Mon, 11 Mar 2019 14:20:16 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.
|
|