Home | Classes | Modules | Annotated | Functions | Files

PgSQLResultSet Class Reference

Inherits ResultSetCommon.

List of all members.

Public Member Functions

• seek ($rownum)
• next ()
• getRecordCount ()
• close ()
• strToArray ($str)
• & getArray ($column)
• & getBlob ($column)
• getBoolean ($column)

---

Member Function Documentation

PgSQLResultSet::seek ( $  rownum)

Postgres doesn't actually move the db pointer. The specific row is fetched by call to pg_fetch_array() rather than by a seek and then an unspecified pg_fetch_array() call. The only side-effect of this situation is that we don't really know if the seek will fail or succeed until we have called next(). This behavior is acceptible - and explicitly documented in ResultSet::seek() phpdoc. public See also ResultSet::seek() Returns bool Reimplemented from ResultSet.

PgSQLResultSet::next ()

public See also ResultSet::next() Returns mixed boolean TRUE on success, SQLException on failure. Reimplemented from ResultSet.

PgSQLResultSet::getRecordCount ()

public See also ResultSet::getRecordCount() Returns mixed number of rows on success, SQLException on failure. Reimplemented from ResultSet.

PgSQLResultSet::close ()

public See also ResultSet::close() Returns void Reimplemented from ResultSet.

PgSQLResultSet::strToArray ( $  str)

Convert Postgres string representation of array into native PHP array. Parameters: string  $str Postgres string array rep: {1223, 2343} or {{"welcome", "home"}, {"test2", ""}} private Returns array

& PgSQLResultSet::getArray ( $  column)

Reads a column as an array. The value of the column is unserialized & returned as an array. Parameters: mixed  $column Column name (string) or index (int) starting with 1. public Returns mixed array on success, SQLException - If the column specified is not a valid key in current field array. Reimplemented from ResultSetCommon.

& PgSQLResultSet::getBlob ( $  column)

Returns Blob with contents of column value. Parameters: mixed  $column Column name (string) or index (int) starting with 1 (if ResultSet::FETCHMODE_NUM was used). public Returns mixed New Blob with data from column on success, SQLException - If the column specified is not a valid key in current field array. Reimplemented from ResultSetCommon.

PgSQLResultSet::getBoolean ( $  column)

Parameters: mixed  $column Column name (string) or index (int) starting with 1. public Returns mixed boolean on success, SQLException - If the column specified is not a valid key in current field array. Reimplemented from ResultSetCommon.

---

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