Db/Statement/Interface.php

Show:

inherited

Table of Contents

Zend Framework

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 [email protected] so we can send you a copy immediately.

Category: Zend
Copyright: Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License
Package: Zend_Db
Subpackage: Statement
Version: $Id$

\Zend_Db_Statement_Interface
jump to top

Package: Zend_Db\Statement

Emulates a PDOStatement for native database adapters.

Category: Zend
Copyright: Copyright (c) 2005-2014 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License

Methods

bindColumn(string $column, mixed $param, mixed $type = null) : bool

Bind a column of the statement result set to a PHP variable.

Parameters

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

Returns

Type	Description
bool

Throws

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.

Parameters

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.

Returns

Type	Description
bool

Throws

Exception	Description
\Zend_Db_Statement_Exception

bindValue(mixed $parameter, mixed $value, mixed $type = null) : bool

Binds a value to a parameter.

Parameters

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.

Returns

Type	Description
bool

Throws

Exception	Description
\Zend_Db_Statement_Exception

closeCursor() : bool

Closes the cursor, allowing the statement to be executed again.

Returns

Type	Description
bool

Throws

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.

Returns

Type	Description
int	The number of columns.

Throws

Exception	Description
\Zend_Db_Statement_Exception

errorCode() : string

Retrieves the error code, if any, associated with the last operation on the statement handle.

Returns

Type	Description
string	error code.

Throws

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.

Returns

Type	Description
array

Throws

Exception	Description
\Zend_Db_Statement_Exception

execute(array $params = array()) : bool

Executes a prepared statement.

Parameters

Name	Type	Description
$params	array	OPTIONAL Values to bind to parameter placeholders.

Returns

Type	Description
bool

Throws

Exception	Description
\Zend_Db_Statement_Exception

fetch(int $style = null, int $cursor = null, int $offset = null) : mixed

Fetches a row from the result set.

Parameters

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.

Returns

Type	Description
mixed	Array, object, or scalar depending on fetch mode.

Throws

Exception	Description
\Zend_Db_Statement_Exception

fetchAll(int $style = null, int $col = null) : array

Returns an array containing all of the result set rows.

Parameters

Name	Type	Description
$style	int	OPTIONAL Fetch mode.
$col	int	OPTIONAL Column number, if fetch mode is by column.

Returns

Type	Description
array	Collection of rows, each in a format by the fetch mode.

Throws

Exception	Description
\Zend_Db_Statement_Exception

fetchColumn(int $col = 0) : string

Returns a single column from the next row of a result set.

Parameters

Name	Type	Description
$col	int	OPTIONAL Position of the column to fetch.

Returns

Type	Description
string

Throws

Exception	Description
\Zend_Db_Statement_Exception

fetchObject(string $class = 'stdClass', array $config = array()) : mixed

Fetches the next row and returns it as an object.

Parameters

Name	Type	Description
$class	string	OPTIONAL Name of the class to create.
$config	array	OPTIONAL Constructor arguments for the class.

Returns

Type	Description
mixed	One object instance of the specified class.

Throws

Exception	Description
\Zend_Db_Statement_Exception

getAttribute(string $key) : mixed

Retrieve a statement attribute.

Parameters

Name	Type	Description
$key	string	Attribute name.

Returns

Type	Description
mixed	Attribute value.

Throws

Exception	Description
\Zend_Db_Statement_Exception

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.

Returns

Type	Description
bool

Throws

Exception	Description
\Zend_Db_Statement_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.

Returns

Type	Description
int	The number of rows affected.

Throws

Exception	Description
\Zend_Db_Statement_Exception

setAttribute(string $key, mixed $val) : bool

Set a statement attribute.

Parameters

Name	Type	Description
$key	string	Attribute name.
$val	mixed	Attribute value.

Returns

Type	Description
bool

Throws

Exception	Description
\Zend_Db_Statement_Exception

setFetchMode(int $mode) : bool

Set the default fetch mode for this statement.

Parameters

Name	Type	Description
$mode	int	The fetch mode.

Returns

Type	Description
bool

Throws

Exception	Description
\Zend_Db_Statement_Exception

Db/Statement/Interface.php

\Zend_Db_Statement_Interfacejump to top

Methods

\Zend_Db_Statement_Interface
jump to top