Public Member Functions | Protected Member Functions | Protected Attributes

Zend_Db_Statement_Sqlsrv Class Reference

Inheritance diagram for Zend_Db_Statement_Sqlsrv:
Zend_Db_Statement Zend_Db_Statement_Interface

Public Member Functions

 closeCursor ()
 columnCount ()
 errorCode ()
 errorInfo ()
 _execute (array $params=null)
 fetch ($style=null, $cursor=null, $offset=null)
 fetchColumn ($col=0)
 fetchObject ($class= 'stdClass', array $config=array())
 getColumnMeta ($column)
 nextRowset ()
 rowCount ()

Protected Member Functions

 _prepare ($sql)
 _bindParam ($parameter, &$variable, $type=null, $length=null, $options=null)

Protected Attributes

 $_originalSQL
 $_keys
 $_executed = false

Detailed Description

Definition at line 36 of file Sqlsrv.php.


Member Function Documentation

_bindParam ( parameter,
&$  variable,
type = null,
length = null,
options = null 
) [protected]

Binds a parameter to the specified variable name.

Parameters:
mixed$parameterName the parameter, either integer or string.
mixed$variableReference to PHP variable containing the value.
mixed$typeOPTIONAL Datatype of SQL parameter.
mixed$lengthOPTIONAL Length of SQL parameter.
mixed$optionsOPTIONAL Other options.
Returns:
bool
Exceptions:
Zend_Db_Statement_Exception

Definition at line 86 of file Sqlsrv.php.

_execute ( array $  params = null )

Executes a prepared statement.

Parameters:
array$paramsOPTIONAL Values to bind to parameter placeholders.
Returns:
bool
Exceptions:
Zend_Db_Statement_Exception

Definition at line 176 of file Sqlsrv.php.

_prepare ( sql ) [protected]

Prepares statement handle

Parameters:
string$sql
Returns:
void
Exceptions:
Zend_Db_Statement_Sqlsrv_Exception

Reimplemented from Zend_Db_Statement.

Definition at line 61 of file Sqlsrv.php.

closeCursor (  )

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

Returns:
bool

Implements Zend_Db_Statement_Interface.

Definition at line 97 of file Sqlsrv.php.

columnCount (  )

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

Returns:
int The number of columns.

Implements Zend_Db_Statement_Interface.

Definition at line 114 of file Sqlsrv.php.

errorCode (  )

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

Returns:
string error code.

Implements Zend_Db_Statement_Interface.

Definition at line 130 of file Sqlsrv.php.

errorInfo (  )

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

Returns:
array

Implements Zend_Db_Statement_Interface.

Definition at line 151 of file Sqlsrv.php.

fetch ( style = null,
cursor = null,
offset = null 
)

Fetches a row from the result set.

Parameters:
int$styleOPTIONAL Fetch mode for this fetch operation.
int$cursorOPTIONAL Absolute, relative, or other.
int$offsetOPTIONAL Number for absolute or relative cursors.
Returns:
mixed Array, object, or scalar depending on fetch mode.
Exceptions:
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

Definition at line 222 of file Sqlsrv.php.

fetchColumn ( col = 0 )

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

Parameters:
int$colOPTIONAL Position of the column to fetch.
Returns:
string
Exceptions:
Zend_Db_Statement_Exception

Reimplemented from Zend_Db_Statement.

Definition at line 287 of file Sqlsrv.php.

fetchObject ( class = 'stdClass',
array $  config = array() 
)

Fetches the next row and returns it as an object.

Parameters:
string$classOPTIONAL Name of the class to create.
array$configOPTIONAL Constructor arguments for the class.
Returns:
mixed One object instance of the specified class.
Exceptions:
Zend_Db_Statement_Exception

Reimplemented from Zend_Db_Statement.

Definition at line 320 of file Sqlsrv.php.

getColumnMeta ( column )

Returns metadata for a column in a result set.

Parameters:
int$column
Returns:
mixed
Exceptions:
Zend_Db_Statement_Sqlsrv_Exception

Definition at line 349 of file Sqlsrv.php.

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.

Returns:
bool
Exceptions:
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

Definition at line 372 of file Sqlsrv.php.

rowCount (  )

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

Returns:
int The number of rows affected.
Exceptions:
Zend_Db_Statement_Exception

Implements Zend_Db_Statement_Interface.

Definition at line 390 of file Sqlsrv.php.


Field Documentation

$_executed = false [protected]

Query executed

Definition at line 52 of file Sqlsrv.php.

$_keys [protected]

Column names.

Definition at line 47 of file Sqlsrv.php.

$_originalSQL [protected]

The connection_stmt object original string.

Definition at line 42 of file Sqlsrv.php.


The documentation for this class was generated from the following file: