Overview

Packages

  • Auth
  • Config
  • Controller
  • Date
  • Db
  • Feed
    • Abstract
    • Writers
  • File
    • Decorator
  • Form
    • Element
  • Image
  • Log
    • Writer
  • Net
    • Exception
    • REST
  • None
  • PHP
  • PHPMailer
  • Session
  • Util
  • Validate
    • Validator
  • Zend
    • Db
      • Adapter
      • Expr
      • Profiler
      • Select
      • Statement
      • Table
    • Loader
      • Autoloader
      • PluginLoader
    • Registry

Classes

  • Zend_Db_Statement
  • Zend_Db_Statement_Db2
  • Zend_Db_Statement_Mysqli
  • Zend_Db_Statement_Oracle
  • Zend_Db_Statement_Pdo
  • Zend_Db_Statement_Pdo_Ibm
  • Zend_Db_Statement_Pdo_Oci
  • Zend_Db_Statement_Sqlsrv

Interfaces

  • Zend_Db_Statement_Interface

Exceptions

  • Zend_Db_Statement_Db2_Exception
  • Zend_Db_Statement_Exception
  • Zend_Db_Statement_Mysqli_Exception
  • Zend_Db_Statement_Oracle_Exception
  • Zend_Db_Statement_Sqlsrv_Exception
  • Overview
  • Package
  • Class
  • Tree

Class Zend_Db_Statement_Sqlsrv

Extends for Microsoft SQL Server Driver for PHP

Zend_Db_Statement implements Zend_Db_Statement_Interface
Extended by Zend_Db_Statement_Sqlsrv
Package: Zend\Db\Statement
Category: Zend
Copyright: Copyright (c) 2005-2010 Zend Technologies USA Inc. (http://www.zend.com)
License: New BSD License
Located at Zend/Db/Statement/Sqlsrv.php
Methods summary
protected
# _prepare( string $sql )

Prepares statement handle

Prepares statement handle

Parameters

$sql
string

Throws

Zend_Db_Statement_Sqlsrv_Exception
protected boolean
# _bindParam( mixed $parameter, mixed & $variable, mixed $type = null, mixed $length = null, mixed $options = null )

Binds a parameter to the specified variable name.

Binds a parameter to the specified variable name.

Parameters

$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

boolean

Throws

Zend_Db_Statement_Exception
public boolean
# closeCursor( )

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

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

Returns

boolean

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::closeCursor
public integer
# columnCount( )

Returns the number of columns in the result set. Returns null if the statement has no result set metadata.

Returns the number of columns in the result set. Returns null if the statement has no result set metadata.

Returns

integer
The number of columns.

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::columnCount
public string
# errorCode( )

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

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

Returns

string
error code.

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::errorCode
public array
# errorInfo( )

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

Retrieves an array of error information, if any, associated with the last operation on the statement handle.

Returns

array

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::errorInfo
public boolean
# _execute( array $params = null )

Executes a prepared statement.

Executes a prepared statement.

Parameters

$params
array
OPTIONAL Values to bind to parameter placeholders.

Returns

boolean

Throws

Zend_Db_Statement_Exception
public mixed
# fetch( integer $style = null, integer $cursor = null, integer $offset = null )

Fetches a row from the result set.

Fetches a row from the result set.

Parameters

$style
integer
OPTIONAL Fetch mode for this fetch operation.
$cursor
integer
OPTIONAL Absolute, relative, or other.
$offset
integer
OPTIONAL Number for absolute or relative cursors.

Returns

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

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::fetch
public string
# fetchColumn( integer $col = 0 )

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

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

Parameters

$col
integer
OPTIONAL Position of the column to fetch.

Returns

string

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::fetchColumn
public mixed
# fetchObject( string $class = 'stdClass', array $config = array() )

Fetches the next row and returns it as an object.

Fetches the next row and returns it as an object.

Parameters

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

Returns

mixed
One object instance of the specified class.

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::fetchObject
public mixed
# getColumnMeta( integer $column )

Returns metadata for a column in a result set.

Returns metadata for a column in a result set.

Parameters

$column
integer

Returns

mixed

Throws

Zend_Db_Statement_Sqlsrv_Exception
public boolean
# nextRowset( )

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.

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

boolean

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::nextRowset
public integer
# rowCount( )

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.

Returns

integer
The number of rows affected.

Throws

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::rowCount
public array
# fetchAll( integer $style = null, integer $col = null )

Returns an array containing all of the result set rows.

Returns an array containing all of the result set rows.

Parameters

$style
integer
OPTIONAL Fetch mode.
$col
integer
OPTIONAL Column number, if fetch mode is by column.

Returns

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

Zend_Db_Statement_Exception

Implementation of

Zend_Db_Statement_Interface::fetchAll
Methods inherited from Zend_Db_Statement
__construct(), _fetchBound(), _parseParameters(), _stripQuoted(), bindColumn(), bindParam(), bindValue(), execute(), getAdapter(), getAttribute(), getDriverStatement(), setAttribute(), setFetchMode()
Properties summary
protected $_originalSQL
#

The connection_stmt object original string.

The connection_stmt object original string.
protected $_keys
#

Column names.

Column names.
protected boolean $_executed false
#

Query executed

Query executed
Properties inherited from Zend_Db_Statement
$_adapter, $_attribute, $_bindColumn, $_bindParam, $_fetchMode, $_queryId, $_sqlParam, $_sqlSplit, $_stmt
Pry Framework API documentation generated by ApiGen 2.6.1