Constructor for a statement.
Bind a column of the statement result set to a PHP variable.
bool
bindColumn
(string $column, &$param, [mixed $type = null], mixed $param)
-
string
$column: Name the column in the result set, either by position or by name.
-
mixed
$param: Reference to the PHP variable containing the value.
-
mixed
$type: OPTIONAL
-
&$param
Implementation of:
- Zend_Db_Statement_Interface::bindColumn()
- Bind a column of the statement result set to a PHP variable.
Binds a parameter to the specified variable name.
bool
bindParam
(mixed $parameter, &$variable, [mixed $type = null], [mixed $length = null], [mixed $options = null], mixed $variable)
-
mixed
$parameter: Name the parameter, either integer or string.
-
mixed
$variable: Reference to PHP variable containing the value.
-
mixed
$type: OPTIONAL Datatype of SQL parameter.
-
mixed
$length: OPTIONAL Length of SQL parameter.
-
mixed
$options: OPTIONAL Other options.
-
&$variable
Implementation of:
- Zend_Db_Statement_Interface::bindParam()
- Binds a parameter to the specified variable name.
Redefined in descendants as:
Binds a value to a parameter.
bool
bindValue
(mixed $parameter, mixed $value, [mixed $type = null])
-
mixed
$parameter: Name the parameter, either integer or string.
-
mixed
$value: Scalar value to bind to the parameter.
-
mixed
$type: OPTIONAL Datatype of the parameter.
Implementation of:
- Zend_Db_Statement_Interface::bindValue()
- Binds a value to a parameter.
Returns an array containing all of the result set rows.
array
fetchAll
([int $style = null], [int $col = null])
-
int
$style: OPTIONAL Fetch mode.
-
int
$col: OPTIONAL Column number, if fetch mode is by column.
Implementation of:
- Zend_Db_Statement_Interface::fetchAll()
- Returns an array containing all of the result set rows.
Redefined in descendants as:
Returns a single column from the next row of a result set.
string
fetchColumn
([int $col = 0])
-
int
$col: OPTIONAL Position of the column to fetch.
Implementation of:
- Zend_Db_Statement_Interface::fetchColumn()
- Returns a single column from the next row of a result set.
Redefined in descendants as:
Fetches the next row and returns it as an object.
mixed
fetchObject
([string $class = 'stdClass'], [ $config = array()])
-
string
$class: OPTIONAL Name of the class to create.
-
array
$config: OPTIONAL Constructor arguments for the class.
Implementation of:
- Zend_Db_Statement_Interface::fetchObject()
- Fetches the next row and returns it as an object.
Redefined in descendants as:
Set a statement attribute.
bool
setAttribute
(string $key, mixed $val)
-
string
$key: Attribute name.
-
mixed
$val: Attribute value.
Implementation of:
- Zend_Db_Statement_Interface::setAttribute()
- Set a statement attribute.
Joins SQL text and bound params into a string.
This emulates SQL parameters by quoting the values directly into the SQL string.
string
_joinSql
()
Check sanity of bind parameters. Throw exceptions if params are not valid.
integer
_normalizeBindParam
(mixed $parameter, &$variable, [ $supportsNumeric = true], [ $supportsNamed = true], mixed $variable)
-
mixed
$parameter: Name the parameter, either integer or string.
-
mixed
$variable: Reference to PHP variable containing the value.
-
&$variable
-
$supportsNumeric
-
$supportsNamed
Splits SQL into text and params, sets up $this->_bindParam for replacements.
void
_prepSql
(string $sql)
Redefined in descendants as: