Class: PgSQLPreparedStatement

Source Location: /creole/drivers/pgsql/PgSQLPreparedStatement.php

Class Overview

PreparedStatementCommon
   |
   --PgSQLPreparedStatement

PgSQL subclass for prepared statements.

Author(s):

Hans Lellelid <hans@xmpl.org>

Version:

$Revision: 1.12 $

Methods

Inherited Variables

Class: PreparedStatementCommon

PreparedStatementCommon::$boundInVars
PreparedStatementCommon::$conn
PreparedStatementCommon::$limit
PreparedStatementCommon::$offset
PreparedStatementCommon::$positions
PreparedStatementCommon::$positionsCount
PreparedStatementCommon::$resultSet
PreparedStatementCommon::$sql
PreparedStatementCommon::$updateCount

Inherited Methods

Class: PreparedStatementCommon

PreparedStatementCommon::__construct()

Create new prepared statement instance.

PreparedStatementCommon::close()

Nothing to close for emulated prepared statements.

PreparedStatementCommon::escape()

Escapes special characters (usu. quotes) using native driver function.

PreparedStatementCommon::executeQuery()

Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query.

PreparedStatementCommon::executeUpdate()

Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object.

PreparedStatementCommon::getConnection()

PreparedStatementCommon::getLimit()

PreparedStatementCommon::getMoreResults()

PreparedStatementCommon::getOffset()

PreparedStatementCommon::getResource()

Statement resources do not exist for emulated prepared statements, so this just returns

null

PreparedStatementCommon::getResultSet()

PreparedStatementCommon::getUpdateCount()

PreparedStatementCommon::replaceParams()

Replaces placeholders with the specified parameter values in the SQL.

PreparedStatementCommon::set()

A generic set method.

PreparedStatementCommon::setArray()

Sets an array.

PreparedStatementCommon::setBlob()

PreparedStatementCommon::setBoolean()

Sets a boolean value.

PreparedStatementCommon::setClob()

PreparedStatementCommon::setDate()

PreparedStatementCommon::setDecimal()

PreparedStatementCommon::setDouble()

PreparedStatementCommon::setFloat()

PreparedStatementCommon::setInt()

PreparedStatementCommon::setInteger()

Alias for setInt()

PreparedStatementCommon::setLimit()

PreparedStatementCommon::setNull()

PreparedStatementCommon::setOffset()

PreparedStatementCommon::setString()

PreparedStatementCommon::setTime()

PreparedStatementCommon::setTimestamp()

Class Details

[line 32]
PgSQL subclass for prepared statements.

Tags:

version:	$Revision: 1.12 $
author:	Hans Lellelid <hans@xmpl.org>

[ Top ]

Class Methods

method escape [line 39]

string escape(
string
$str)

Quotes string using native pgsql function (pg_escape_string).

Tags:

access:

protected

Overrides PreparedStatementCommon::escape() (Escapes special characters (usu. quotes) using native driver function.)

Parameters:

string

$str

[ Top ]

method setArray [line 75]

void setArray(
int
$paramIndex, array
$value)

Sets an array.

Unless a driver-specific method is used, this means simply serializing the passed parameter and storing it as a string.

Tags:

see:

PreparedStatement::setArray()

Overrides PreparedStatementCommon::setArray() (Sets an array.)

Parameters:

int	$paramIndex
array	$value

[ Top ]

method setBlob [line 109]

void setBlob(
int
$paramIndex, mixed
$blob)

Applies sqlite_udf_encode_binary() to ensure that binary contents will be handled correctly by sqlite.

Overrides PreparedStatementCommon::setBlob() (parent method not documented)

Parameters:

int	$paramIndex
mixed	$blob	Blob object or string containing data.

[ Top ]

method setBoolean [line 92]

void setBoolean(
int
$paramIndex, boolean
$value)

For setting value of Postgres BOOLEAN column.

Overrides PreparedStatementCommon::setBoolean() (Sets a boolean value.)

Parameters:

int	$paramIndex
boolean	$value

[ Top ]

Documentation generated on Mon, 23 Aug 2004 21:52:36 -0400 by phpDocumentor 1.3.0RC3