Home | Classes | Modules | Annotated | Hierarchy | Functions | Files

OCI8PreparedStatement Class Reference

Inherits PreparedStatementCommon, and PreparedStatement.

List of all members.

Public Member Functions

• close ()
• ResultSet executeQuery ( $p1, $fetchmode )
• int executeUpdate ( $params )
• void setBlob ( $paramIndex, $blob )
• void setClob ( $paramIndex, $clob )

Protected Member Functions

• string escape ( $str )

---

Member Function Documentation

OCI8PreparedStatement::close ( )

Because MySQL doesn't support prepared statements, this does nothing. See also PreparedStatement::close() Reimplemented from PreparedStatementCommon.

string OCI8PreparedStatement::escape ( $str ) [protected, virtual]

' -> '' Parameters string  $str Returns string Implements PreparedStatementCommon.

ResultSet OCI8PreparedStatement::executeQuery ( $p1 = null, $fetchmode = null )

Executes the SQL query in this PreparedStatement object and returns the resultset generated by the query. Parameters mixed  $p1 Either (array) Parameters that will be set using PreparedStatement::set() before query is executed or (int) fetchmode. int  $fetchmode The mode to use when fetching the results (e.g. ResultSet::FETCHMODE_NUM, ResultSet::FETCHMODE_ASSOC). Returns ResultSet Exceptions SQLException  if a database access error occurs. Reimplemented from PreparedStatementCommon.

int OCI8PreparedStatement::executeUpdate ( $params = null )

Executes the SQL INSERT, UPDATE, or DELETE statement in this PreparedStatement object. Parameters array  $params Parameters that will be set using PreparedStatement::set() before query is executed. Returns int Number of affected rows (or 0 for drivers that return nothing). Exceptions SQLException  if a database access error occurs. Reimplemented from PreparedStatementCommon.

void OCI8PreparedStatement::setBlob ( $paramIndex, $blob )

Parameters string  $paramIndex mixed  $blob Blob object or string containing data. Returns void Reimplemented from PreparedStatementCommon.

void OCI8PreparedStatement::setClob ( $paramIndex, $clob )

Parameters string  $paramIndex mixed  $clob Clob object or string containing data. Returns void Reimplemented from PreparedStatementCommon.

---

This file is part of the Creole[php5] library.