Db/Statement/Sqlsrv.php
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 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: Sqlsrv.php 24593 2012-01-05 20:35:02Z matthew $
\Zend_Db_Statement_Sqlsrv
Package: Zend\Db\StatementExtends for Microsoft SQL Server Driver for PHP
- 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
Methods



_bindParam(mixed $parameter, mixed $variable, mixed $type = null, mixed $length = null, mixed $options = null) : bool
Binds a parameter to the specified variable name.
ParametersName | 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. |
---|
ReturnsThrows 


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


_prepare(string $sql) : void
Prepares statement handle
ParametersName | Type | Description |
---|
$sql | string | |
---|
Throws 


bindColumn(string $column, mixed $param, mixed $type = null) : bool
ParametersName | 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 |
---|
ReturnsThrows 


bindParam(mixed $parameter, mixed $variable, mixed $type = null, mixed $length = null, mixed $options = null) : bool
ParametersName | 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. |
---|
ReturnsThrows 


bindValue(mixed $parameter, mixed $value, mixed $type = null) : bool
ParametersName | 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. |
---|
ReturnsThrows 


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


errorCode() : string
Retrieves the error code, if any, associated with the last operation on
the statement handle.
ReturnsType | Description |
---|
string | error code. |
Throws 


execute(array $params = null) : bool
ParametersName | Type | Description |
---|
$params | array | OPTIONAL Values to bind to parameter placeholders. |
---|
ReturnsThrows 


fetch(int $style = null, int $cursor = null, int $offset = null) : mixed
Fetches a row from the result set.
ParametersName | 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. |
---|
ReturnsType | Description |
---|
mixed | Array, object, or scalar depending on fetch mode. |
Throws 


fetchAll(int $style = null, int $col = null) : array
Returns an array containing all of the result set rows.
ParametersName | Type | Description |
---|
$style | int | OPTIONAL Fetch mode. |
---|
$col | int | OPTIONAL Column number, if fetch mode is by column. |
---|
ReturnsType | Description |
---|
array | Collection of rows, each in a format by the fetch mode.
Behaves like parent, but if limit()
is used, the final result removes the extra column
'zend_db_rownum' |
Throws 


fetchColumn(int $col = 0) : string
Returns a single column from the next row of a result set.
ParametersName | Type | Description |
---|
$col | int | OPTIONAL Position of the column to fetch. |
---|
ReturnsThrows 


fetchObject(string $class = 'stdClass', array $config = array()) : mixed
Fetches the next row and returns it as an object.
ParametersName | Type | Description |
---|
$class | string | OPTIONAL Name of the class to create. |
---|
$config | array | OPTIONAL Constructor arguments for the class. |
---|
ReturnsType | Description |
---|
mixed | One object instance of the specified class. |
Throws 


getAttribute(string $key) : mixed
ParametersName | Type | Description |
---|
$key | string | Attribute name. |
---|
ReturnsType | Description |
---|
mixed | Attribute value. |
Throws 


getColumnMeta(int $column) : mixed
Returns metadata for a column in a result set.
ParametersName | Type | Description |
---|
$column | int | |
---|
ReturnsThrows 


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.
ReturnsThrows


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


setAttribute(string $key, mixed $val) : bool
ParametersName | Type | Description |
---|
$key | string | Attribute name. |
---|
$val | mixed | Attribute value. |
---|
ReturnsThrows 


setFetchMode(int $mode) : bool
ParametersName | Type | Description |
---|
$mode | int | The fetch mode. |
---|
ReturnsThrows