Packageindex Classtrees Modulegroups Elementlist Report XML Files

File: /home/cch/www/pear/DB/pgsql.php
PEAR Repository -

DB_pgsql

DB_common
   |
  +-- DB_pgsql

DB_common is a base class for DB implementations, and should be
inherited by all such.

 

private class DB_pgsql extends DB_common

DB_common is a base class for DB implementations, and should be
inherited by all such.

 

Methods inherited from DB_common

quotestring, provides, errorcode, errormessage, &raiseerror, seterrorhandling, setfetchmode, execute_emulate_query, executemultiple, &getone, &getrow, &getcol, &getassoc, &getall, tostring, db_common

Public Method Summary

void

DB_pgsql()

Private Method Summary

int

connect( &$dsn, boolean $persistent)

Connect to a database and log in as the specified user.
bool

disconnect()

Log out and disconnect from the database.
object [unknown]

&query( $query)

Send a query to PostgreSQL and return the results as a DB_result object.
int

simpleQuery( $query)

Send a query to PostgreSQL and return the results as a PostgreSQL resource
int

&fetchRow(array $result, string $fetchmode)

Fetch a row and return as array.
int

fetchInto(array $result, array &$arr, string $fetchmode)

Fetch a row and insert the data into an existing array.
bool

freeResult( $result)

Free the internal resources associated with $result.
int

numCols( $result)

Get the number of columns in a result set.
int

numRows( $result)

Get the number of rows in a result set.
int

errorNative()

Get the native error code of the last error (if any) that
void

prepare( $query)

Prepares a query for multiple execution with execute(). With
PostgreSQL, this is emulated.
int

execute( $stmt, boolean $data)

void

autoCommit(boolean $onoff)

Enable/disable automatic commits [not supported by PostgreSQL]
void

commit()

Commit transactions on the current connection
void

rollback()

Roll back all uncommitted transactions on the current connection.

Fields inherited from DB_common

$features, $errorcode_map, $type, $prepare_maxstmt, $error_mode, $error_level, $error_callback, $last_query, $fetchmode

Private Field Summary

unknown

$connection

unknown

$phptype

array

$prepare_tokens

array

$prepare_types

unknown

$numrows

unknown

$row

Public Method Details

DB_pgsql

public void DB_pgsql( )

 

Returns void


Private Method Details

connect

private int connect( &$dsn, boolean $persistent )

  Connect to a database and log in as the specified user.

Parameter
&$dsn
boolean $persistent
Returns int

DB_OK on success, a DB error code on failure


disconnect

private bool disconnect( )

  Log out and disconnect from the database.

Returns bool

TRUE on success, FALSE if not connected.


&query

private object [unknown] &query( $query )

  Send a query to PostgreSQL and return the results as a DB_result object.

Parameter
$query
Returns object [unknown]

a DB_result object on success, a DB error code
on failure


simpleQuery

private int simpleQuery( $query )

  Send a query to PostgreSQL and return the results as a PostgreSQL resource
identifier.

Parameter
$query
Returns int

returns a valid PostgreSQL result for successful SELECT
queries, DB_OK for other successful queries. A DB error code
is returned on failure.


&fetchRow

private int &fetchRow( array $result, string $fetchmode )

  Fetch a row and return as array.

Parameter
array $result
should be indexed
string $fetchmode
Returns int

an array on success, a DB error code on failure, NULL
if there is no more data


fetchInto

private int fetchInto( array $result, array &$arr, string $fetchmode )

  Fetch a row and insert the data into an existing array.

Parameter
array $result
where data from the row is stored
array &$arr
data should be indexed
string $fetchmode
Returns int

DB_OK on success, a DB error code on failure


freeResult

private bool freeResult( $result )

  Free the internal resources associated with $result.

Parameter
$result
Returns bool

TRUE on success, FALSE if $result is invalid


numCols

private int numCols( $result )

  Get the number of columns in a result set.

Parameter
$result
Returns int

the number of columns per row in $result


numRows

private int numRows( $result )

  Get the number of rows in a result set.

Parameter
$result
Returns int

the number of rows in $result


errorNative

private int errorNative( )

  Get the native error code of the last error (if any) that
occured on the current connection.

Returns int

native PostgreSQL error code


prepare

private void prepare( $query )

  Prepares a query for multiple execution with execute(). With
PostgreSQL, this is emulated.

Parameter
$query
Returns void


execute

private int execute( $stmt, boolean $data )

 

Parameter
$stmt
boolean $data
Returns int

returns a PostgreSQL result resource for successful
SELECT queries, DB_OK for other successful queries. A DB error
code is returned on failure.


autoCommit

private void autoCommit( boolean $onoff )

  Enable/disable automatic commits [not supported by PostgreSQL]

Parameter
boolean $onoff
Returns void


commit

private void commit( )

  Commit transactions on the current connection

Returns void


rollback

private void rollback( )

  Roll back all uncommitted transactions on the current connection.

Returns void


Private Field Details

$connection

private unknown $connection

>>unknown<<


$phptype

private unknown $phptype

>>unknown<<


$prepare_tokens

private array $prepare_tokens

>>array()<<


$prepare_types

private array $prepare_types

>>array()<<


$numrows

private unknown $numrows

>>unknown<<


$row

private unknown $row

>>unknown<<



Packageindex Classtrees Modulegroups Elementlist Report XML Files
PHPDoc 1.0beta