Db/Statement/Mysqli.php
LICENSE
This source file is subject to the new BSD license that is bundled with this package in the file LICENSE.txt. It is also available through the world-wide-web at this URL: http://framework.zend.com/license/new-bsd If you did not receive a copy of the license and are unable to obtain it through the world-wide-web, please send an email to license@zend.com so we can send you a copy immediately.
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
- Package
- Zend_Db
- Subpackage
- Statement
- Version
- $Id: Mysqli.php 24593 2012-01-05 20:35:02Z matthew $
\Zend_Db_Statement_Mysqli
- Parent(s)
- \Zend_Db_Statement
- Category
- Zend
- Copyright
- Copyright (c) 2005-2012 Zend Technologies USA Inc. (http://www.zend.com)
- License
- New BSD License
Properties


\Zend_Db_Adapter_Abstract $_adapter = null
null
Details- Type
- \Zend_Db_Adapter_Abstract
- Inherited_from
- \Zend_Db_Statement::$$_adapter


array $_attribute = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_attribute


array $_bindColumn = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_bindColumn


array $_bindParam = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_bindParam


integer $_fetchMode = \Zend_Db::FETCH_ASSOC
\Zend_Db::FETCH_ASSOC
Details- Type
- integer
- Inherited_from
- \Zend_Db_Statement::$$_fetchMode


\Zend_Db_Profiler_Query $_queryId = null
null
Details- Type
- \Zend_Db_Profiler_Query
- Inherited_from
- \Zend_Db_Statement::$$_queryId


array $_sqlParam = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_sqlParam


array $_sqlSplit = array()
array()
Details- Type
- array
- Inherited_from
- \Zend_Db_Statement::$$_sqlSplit


resource|object $_stmt = null
null
Details- Type
- resource | object
- Inherited_from
- \Zend_Db_Statement::$$_stmt
Methods


__construct(\Zend_Db_Adapter_Abstract $adapter, mixed $sql) : void
Name | Type | Description |
---|---|---|
$adapter | \Zend_Db_Adapter_Abstract | |
$sql | mixed | Either a string or Zend_Db_Select. |


_bindParam(mixed $parameter, mixed $variable, mixed $type = null, mixed $length = null, mixed $options = null) : bool
Binds a parameter to the specified variable name.
Name | Type | Description |
---|---|---|
$parameter | mixed | Name the parameter, either integer or string. |
$variable | mixed | Reference to PHP variable containing the value. |
$type | mixed | OPTIONAL Datatype of SQL parameter. |
$length | mixed | OPTIONAL Length of SQL parameter. |
$options | mixed | OPTIONAL Other options. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Mysqli_Exception |


_execute(array $params = null) : bool
Executes a prepared statement.
Name | Type | Description |
---|---|---|
$params | array | OPTIONAL Values to bind to parameter placeholders. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Mysqli_Exception |


_fetchBound(array $row) : bool
Helper function to map retrieved row to bound column variables
Inherited from: \Zend_Db_Statement::_fetchBound()Name | Type | Description |
---|---|---|
$row | array |
Type | Description |
---|---|
bool | True |


_parseParameters(string $sql) : void
Name | Type | Description |
---|---|---|
$sql | string |


_prepare(string $sql) : void
Internal method called by abstract statment constructor to setup the driver level statement
Name | Type | Description |
---|---|---|
$sql | string |
Exception | Description |
---|---|
\Zend_Db_Statement_Mysqli_Exception |


_stripQuoted(string $sql) : string
Remove parts of a SQL string that contain quoted strings of values or identifiers.
Inherited from: \Zend_Db_Statement::_stripQuoted()Name | Type | Description |
---|---|---|
$sql | string |
Type | Description |
---|---|
string |


bindColumn(string $column, mixed $param, mixed $type = null) : bool
Bind a column of the statement result set to a PHP variable.
Inherited from: \Zend_Db_Statement::bindColumn()Name | Type | Description |
---|---|---|
$column | string | Name the column in the result set, either by position or by name. |
$param | mixed | Reference to the PHP variable containing the value. |
$type | mixed | OPTIONAL |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


bindParam(mixed $parameter, mixed $variable, mixed $type = null, mixed $length = null, mixed $options = null) : bool
Binds a parameter to the specified variable name.
Inherited from: \Zend_Db_Statement::bindParam()Name | Type | Description |
---|---|---|
$parameter | mixed | Name the parameter, either integer or string. |
$variable | mixed | Reference to PHP variable containing the value. |
$type | mixed | OPTIONAL Datatype of SQL parameter. |
$length | mixed | OPTIONAL Length of SQL parameter. |
$options | mixed | OPTIONAL Other options. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


bindValue(mixed $parameter, mixed $value, mixed $type = null) : bool
Name | Type | Description |
---|---|---|
$parameter | mixed | Name the parameter, either integer or string. |
$value | mixed | Scalar value to bind to the parameter. |
$type | mixed | OPTIONAL Datatype of the parameter. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


closeCursor() : bool
Closes the cursor, allowing the statement to be executed again.
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


columnCount() : int
Returns the number of columns in the result set.
Returns null if the statement has no result set metadata.
Type | Description |
---|---|
int | The number of columns. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


errorCode() : string
Retrieves the error code, if any, associated with the last operation on the statement handle.
Type | Description |
---|---|
string | error code. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


errorInfo() : array
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Type | Description |
---|---|
array |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


execute(array $params = null) : bool
Name | Type | Description |
---|---|---|
$params | array | OPTIONAL Values to bind to parameter placeholders. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetch(int $style = null, int $cursor = null, int $offset = null) : mixed
Fetches a row from the result set.
Name | Type | Description |
---|---|---|
$style | int | OPTIONAL Fetch mode for this fetch operation. |
$cursor | int | OPTIONAL Absolute, relative, or other. |
$offset | int | OPTIONAL Number for absolute or relative cursors. |
Type | Description |
---|---|
mixed | Array, object, or scalar depending on fetch mode. |
Exception | Description |
---|---|
\Zend_Db_Statement_Mysqli_Exception |


fetchAll(int $style = null, int $col = null) : array
Returns an array containing all of the result set rows.
Inherited from: \Zend_Db_Statement::fetchAll()Name | Type | Description |
---|---|---|
$style | int | OPTIONAL Fetch mode. |
$col | int | OPTIONAL Column number, if fetch mode is by column. |
Type | Description |
---|---|
array | Collection of rows, each in a format by the fetch mode. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetchColumn(int $col = 0) : string
Returns a single column from the next row of a result set.
Inherited from: \Zend_Db_Statement::fetchColumn()Name | Type | Description |
---|---|---|
$col | int | OPTIONAL Position of the column to fetch. |
Type | Description |
---|---|
string | One value from the next row of result set, or false. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


fetchObject(string $class = 'stdClass', array $config = array()) : mixed
Fetches the next row and returns it as an object.
Inherited from: \Zend_Db_Statement::fetchObject()Name | Type | Description |
---|---|---|
$class | string | OPTIONAL Name of the class to create. |
$config | array | OPTIONAL Constructor arguments for the class. |
Type | Description |
---|---|
mixed | One object instance of the specified class, or false. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


getAdapter() : \Zend_Db_Adapter_Abstract
Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Statement object.
Inherited from: \Zend_Db_Statement::getAdapter()Type | Description |
---|---|
\Zend_Db_Adapter_Abstract |


getAttribute(string $key) : mixed
Name | Type | Description |
---|---|---|
$key | string | Attribute name. |
Type | Description |
---|---|
mixed | Attribute value. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


getDriverStatement() : \unknown_type
Gets the resource or object setup by the _parse
Inherited from: \Zend_Db_Statement::getDriverStatement()Type | Description |
---|---|
\unknown_type |


nextRowset() : bool
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets.
An example is a stored procedure that returns the results of multiple queries.
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Mysqli_Exception |


rowCount() : int
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Type | Description |
---|---|
int | The number of rows affected. |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


setAttribute(string $key, mixed $val) : bool
Name | Type | Description |
---|---|---|
$key | string | Attribute name. |
$val | mixed | Attribute value. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |


setFetchMode(int $mode) : bool
Set the default fetch mode for this statement.
Inherited from: \Zend_Db_Statement::setFetchMode()Name | Type | Description |
---|---|---|
$mode | int | The fetch mode. |
Type | Description |
---|---|
bool |
Exception | Description |
---|---|
\Zend_Db_Statement_Exception |