DB
[ class tree: DB ] [ index: DB ] [ all elements ]
Packages:
DB


Classes:
DB
DB_common
DB_dbase
DB_Error
DB_fbsql
DB_ibase
DB_ifx
DB_msql
DB_mssql
DB_mysql
DB_mysqli
DB_oci8
DB_odbc
DB_pgsql
DB_result
DB_row
DB_sqlite
DB_storage
DB_sybase
Files:
common.php
DB.php
dbase.php
fbsql.php
ibase.php
ifx.php
msql.php
mssql.php
mysql.php
mysqli.php
oci8.php
odbc.php
pgsql.php
sqlite.php
storage.php
sybase.php

Class: DB_pgsql

Source Location: /DB-1.9.2/DB/pgsql.php

Class Overview

PEAR
   |
   --DB_common
      |
      --DB_pgsql

The methods PEAR DB uses to interact with PHP's pgsql extension for interacting with PostgreSQL databases


Author(s):

Version:

  • Release: 1.9.2

Copyright:

  • 1997-2007 The PHP Group

Variables

Methods

Inherited Variables

Class: DB_common

DB_common::$fetchmode
DB_common::$fetchmode_object_class
DB_common::$last_parameters
DB_common::$last_query
DB_common::$options
DB_common::$prepared_queries
DB_common::$prepare_tokens
DB_common::$prepare_types
DB_common::$was_connected
DB_common::$_last_query_manip
DB_common::$_next_query_manip

Inherited Methods

Class: DB_common

DB_common::__construct()
This constructor calls $this->PEAR('DB_Error')
DB_common::affectedRows()
Determines the number of rows affected by a data maniuplation query
DB_common::autoCommit()
Enables or disables automatic commits
DB_common::autoExecute()
Automaticaly generates an insert or update query and call prepare() and execute() with it
DB_common::autoPrepare()
Automaticaly generates an insert or update query and pass it to prepare()
DB_common::buildManipSQL()
Produces an SQL query string for autoPrepare()
DB_common::commit()
Commits the current transaction
DB_common::createSequence()
Creates a new sequence
DB_common::dropSequence()
Deletes a sequence
DB_common::errorCode()
Maps native error codes to DB's portable ones
DB_common::errorMessage()
Maps a DB error code to a textual message
DB_common::errorNative()
Gets the DBMS' native error code produced by the last query
DB_common::escapeSimple()
Escapes a string according to the current DBMS's standards
DB_common::execute()
Executes a DB statement prepared with prepare()
DB_common::executeEmulateQuery()
Emulates executing prepared statements if the DBMS not support them
DB_common::executeMultiple()
Performs several execute() calls on the same statement handle
DB_common::freePrepared()
Frees the internal resources associated with a prepared query
DB_common::getAll()
Fetches all of the rows from a query result
DB_common::getAssoc()
Fetches an entire query result and returns it as an associative array using the first column as the key
DB_common::getCol()
Fetches a single column from a query result and returns it as an indexed array
DB_common::getListOf()
Lists internal database information
DB_common::getOne()
Fetches the first column of the first row from a query result
DB_common::getOption()
Returns the value of an option
DB_common::getRow()
Fetches the first row of data returned from a query result
DB_common::getSequenceName()
Generates the name used inside the database for a sequence
DB_common::getSpecialQuery()
Obtains the query string needed for listing a given type of objects
DB_common::getTables()
Lists the tables in the current database
DB_common::limitQuery()
Generates and executes a LIMIT query
DB_common::modifyLimitQuery()
Adds LIMIT clauses to a query string according to current DBMS standards
DB_common::modifyQuery()
Changes a query string for various DBMS specific reasons
DB_common::nextId()
Returns the next free id in a sequence
DB_common::nextQueryIsManip()
Sets (or unsets) a flag indicating that the next query will be a manipulation query, regardless of the usual DB::isManip() heuristics.
DB_common::numRows()
Determines the number of rows in a query result
DB_common::prepare()
Prepares a query for multiple execution with execute()
DB_common::provides()
Tells whether the present driver supports a given feature
DB_common::query()
Sends a query to the database server
DB_common::quote()
DEPRECATED: Quotes a string so it can be safely used in a query
DB_common::quoteBoolean()
Formats a boolean value for use within a query in a locale-independent manner.
DB_common::quoteFloat()
Formats a float value for use within a query in a locale-independent manner.
DB_common::quoteIdentifier()
Quotes a string so it can be safely used as a table or column name
DB_common::quoteSmart()
Formats input so it can be safely used in a query
DB_common::quoteString()
DEPRECATED: Quotes a string so it can be safely used within string delimiters in a query
DB_common::raiseError()
Communicates an error and invoke error callbacks, etc
DB_common::rollback()
Reverts the current transaction
DB_common::setFetchMode()
Sets the fetch mode that should be used by default for query results
DB_common::setOption()
Sets run-time configuration options for PEAR DB
DB_common::tableInfo()
Returns information about a table or a result set
DB_common::toString()
DEPRECATED: String conversion method
DB_common::_checkManip()
Checks if the given query is a manipulation query. This also takes into account the _next_query_manip flag and sets the _last_query_manip flag (and resets _next_query_manip) according to the result.
DB_common::_convertNullArrayValuesToEmpty()
Converts all null values in an array to empty strings
DB_common::_rtrimArrayValues()
Right-trims all strings in an array
DB_common::__sleep()
Automatically indicates which properties should be saved when PHP's serialize() function is called
DB_common::__toString()
Automatic string conversion for PHP 5
DB_common::__wakeup()
Automatically reconnects to the database when PHP's unserialize() function is called

Class Details

[line 49]
The methods PEAR DB uses to interact with PHP's pgsql extension for interacting with PostgreSQL databases

These methods overload the ones declared in DB_common.



[ Top ]

Class Variables

$affected =  0

[line 130]

The number of rows affected by a data manipulation query

Type:   integer


[ Top ]

$connection =

[line 99]

The raw database connection created by PHP

Type:   resource


[ Top ]

$dbsyntax =  'pgsql'

[line 63]

The database syntax variant to be used (db2, access, etc.), if any

Type:   string


[ Top ]

$dsn = array()

[line 105]

The DSN information for connecting to a database

Type:   array


[ Top ]

$errorcode_map = array(
    )

[line 92]

A mapping of native error codes to DB error codes

Type:   array


[ Top ]

$features = array(
        'limit'         => 'alter',
        'new_link'      => '4.3.0',
        'numrows'       => true,
        'pconnect'      => true,
        'prepare'       => false,
        'ssl'           => true,
        'transactions'  => true,
    )

[line 78]

The capabilities of this DB implementation

The 'new_link' element contains the PHP version that first provided new_link support for this DBMS. Contains false if it's unsupported.

Meaning of the 'limit' element:

  • 'emulate' = emulate with fetch row by number
  • 'alter' = alter the query
  • false = skip rows


Type:   array


[ Top ]

$phptype =  'pgsql'

[line 57]

The DB driver type (mysql, oci8, odbc, etc.)

Type:   string


[ Top ]


Method Detail

__construct (Constructor)   [line 155]

void __construct( )

This constructor calls parent::__construct()

Overrides DB_common::__construct() (This constructor calls $this->PEAR('DB_Error'))
[ Top ]

affectedRows   [line 640]

int affectedRows( )

Determines the number of rows affected by a data maniuplation query

  1. is returned for queries that don't manipulate data.

  • Return: the number of rows. A DB_Error object on failure.

Overrides DB_common::affectedRows() (Determines the number of rows affected by a data maniuplation query)
[ Top ]

autoCommit   [line 580]

int autoCommit( [bool $onoff = false])

Enables or disables automatic commits
  • Return: DB_OK on success. A DB_Error object if the driver doesn't support auto-committing transactions.

Overrides DB_common::autoCommit() (Enables or disables automatic commits)

Parameters:

bool   $onoff   —  true turns it on, false turns it off

[ Top ]

commit   [line 596]

int commit( )

Commits the current transaction
  • Return: DB_OK on success. A DB_Error object on failure.

Overrides DB_common::commit() (Commits the current transaction)
[ Top ]

connect   [line 209]

int connect( array $dsn, [bool $persistent = false])

Connect to the database server, log in and open the database

Don't call this method directly. Use DB::connect() instead.

PEAR DB's pgsql driver supports the following extra DSN options:

  • connect_timeout How many seconds to wait for a connection to be established. Available since PEAR DB 1.7.0.
  • new_link If set to true, causes subsequent calls to connect() to return a new connection link instead of the existing one. WARNING: this is not portable to other DBMS's. Available only if PHP is >= 4.3.0 and PEAR DB is >= 1.7.0.
  • options Command line options to be sent to the server. Available since PEAR DB 1.6.4.
  • service Specifies a service name in pg_service.conf that holds additional connection parameters. Available since PEAR DB 1.7.0.
  • sslmode How should SSL be used when connecting? Values: disable, allow, prefer or require. Available since PEAR DB 1.7.0.
  • tty This was used to specify where to send server debug output. Available since PEAR DB 1.6.4.
Example of connecting to a new link via a socket: 
  1.  require_once 'DB.php';
    2. 

  2.  
    3. 

  3.  $dsn = 'pgsql://user:pass@unix(/tmp)/dbname?new_link=true';
    4. 

  4.  $options = array(
    5. 

  5.      'portability' => DB_PORTABILITY_ALL,
    6. 

  6.  );
    7. 

  7.  
    8. 

  8.  $db = DB::connect($dsn, $options);
    9. 

  9.  if (PEAR::isError($db)) {
    10. 

  10.      die($db->getMessage());
    11. 

  11.  }
    12.


Parameters:

array   $dsn   —  the data source name
bool   $persistent   —  should the connection be persistent?

[ Top ]

createSequence   [line 703]

int createSequence( string $seq_name)

Creates a new sequence

Overrides DB_common::createSequence() (Creates a new sequence)

Parameters:

string   $seq_name   —  name of the new sequence

[ Top ]

disconnect   [line 302]

bool disconnect( )

Disconnects from the database server
  • Return: TRUE on success, FALSE on failure

[ Top ]

dropSequence   [line 723]

int dropSequence( string $seq_name)

Deletes a sequence

Overrides DB_common::dropSequence() (Deletes a sequence)

Parameters:

string   $seq_name   —  name of the sequence to be deleted

[ Top ]

errorCode   [line 806]

integer errorCode( string $errormsg)

Determines PEAR::DB error code from the database's text error message.
  • Return: an error number from a DB error constant

Overrides DB_common::errorCode() (Maps native error codes to DB's portable ones)

Parameters:

string   $errormsg   —  error message returned from the database

[ Top ]

errorNative   [line 792]

string errorNative( )

Gets the DBMS' native error message produced by the last query

  • Return: the DBMS' error message

Overrides DB_common::errorNative() (Gets the DBMS' native error code produced by the last query)
[ Top ]

escapeSimple   [line 500]

string escapeSimple( string $str)

Escapes a string according to the current DBMS's standards


Overrides DB_common::escapeSimple() (Escapes a string according to the current DBMS's standards)

Parameters:

string   $str   —  the string to be escaped

[ Top ]

fetchInto   [line 413]

mixed fetchInto( resource $result, &$arr, int $fetchmode, [int $rownum = null], array $arr)

Places a row from the result set into the given array

Formating of the array and the data therein are configurable. See DB_result::fetchInto() for more information.

This method is not meant to be called directly. Use DB_result::fetchInto() instead. It can't be declared "protected" because DB_result is a separate object.

  • Return: DB_OK on success, NULL when the end of a result set is reached or on failure
  • See: DB_result::fetchInto()

Parameters:

resource   $result   —  the query result resource
array   $arr   —  the referenced array to put the data in
int   $fetchmode   —  how the resulting array should be indexed
int   $rownum   —  the row number to fetch (0 = first row)
   &$arr   — 

[ Top ]

freeResult   [line 457]

bool freeResult( resource $result)

Deletes the result set and frees the memory occupied by the result set

This method is not meant to be called directly. Use DB_result::free() instead. It can't be declared "protected" because DB_result is a separate object.


Parameters:

resource   $result   —  PHP's query result resource

[ Top ]

getSpecialQuery   [line 1044]

string getSpecialQuery( string $type)

Obtains the query string needed for listing a given type of objects
  • Return: the SQL query string or null if the driver doesn't support the object type requested
  • See: DB_common::getListOf()
  • Access: protected

Overrides DB_common::getSpecialQuery() (Obtains the query string needed for listing a given type of objects)

Parameters:

string   $type   —  the kind of objects you want to retrieve

[ Top ]

modifyLimitQuery   [line 748]

string modifyLimitQuery( string $query, int $from, int $count, [mixed $params = array()])

Adds LIMIT clauses to a query string according to current DBMS standards
  • Return: the query string with LIMIT clauses added
  • Access: protected

Overrides DB_common::modifyLimitQuery() (Adds LIMIT clauses to a query string according to current DBMS standards)

Parameters:

string   $query   —  the query to modify
int   $from   —  the row to start to fetching (0 = the first row)
int   $count   —  the numbers of rows to fetch
mixed   $params   —  array, string or numeric data to be used in execution of the statement. Quantity of items passed must match quantity of placeholders in query: meaning 1 placeholder for non-array parameters or 1 placeholder per array element.

[ Top ]

nextId   [line 661]

int nextId( string $seq_name, [boolean $ondemand = true])

Returns the next free id in a sequence

Overrides DB_common::nextId() (Returns the next free id in a sequence)

Parameters:

string   $seq_name   —  name of the sequence
boolean   $ondemand   —  when true, the seqence is automatically created if it does not exist

[ Top ]

nextResult   [line 385]

true nextResult( a $result)

Move the internal pgsql result pointer to the next available result
  • Return: if a result is available otherwise return false
  • Access: public

Parameters:

a   $result   —  valid fbsql result resource

[ Top ]

numCols   [line 535]

int numCols( resource $result)

Gets the number of columns in a result set

This method is not meant to be called directly. Use DB_result::numCols() instead. It can't be declared "protected" because DB_result is a separate object.


Parameters:

resource   $result   —  PHP's query result resource

[ Top ]

numRows   [line 560]

int numRows( resource $result)

Gets the number of rows in a result set

This method is not meant to be called directly. Use DB_result::numRows() instead. It can't be declared "protected" because DB_result is a separate object.


Overrides DB_common::numRows() (Determines the number of rows in a query result)

Parameters:

resource   $result   —  PHP's query result resource

[ Top ]

pgsqlRaiseError   [line 768]

object the pgsqlRaiseError( [int $errno = null])

Produces a DB_Error object regarding the current problem

Parameters:

int   $errno   —  if the error is being manually raised pass a DB_ERROR* constant here. If this isn't passed the error information gathered from the DBMS.

[ Top ]

quoteBoolean   [line 480]

string quoteBoolean( boolean $boolean)

Formats a boolean value for use within a query in a locale-independent manner.

Overrides DB_common::quoteBoolean() (Formats a boolean value for use within a query in a locale-independent manner.)

Parameters:

boolean   $boolean   —  the boolean value to be quoted.

[ Top ]

rollback   [line 618]

int rollback( )

Reverts the current transaction
  • Return: DB_OK on success. A DB_Error object on failure.

Overrides DB_common::rollback() (Reverts the current transaction)
[ Top ]

simpleQuery   [line 321]

mixed simpleQuery( string $query)

Sends a query to the database server
  • Return: + a PHP result resrouce for successful SELECT queries
    • the DB_OK constant for other successful queries
    • a DB_Error object on failure

Parameters:

string   $query   —  the SQL query string

[ Top ]

tableInfo   [line 883]

array tableInfo( object|string $result, [int $mode = null])

Returns information about a table or a result set

NOTE: only supports 'table' and 'flags' if $result is a table name.

  • Return: an associative array with the information requested. A DB_Error object on failure.
  • See: DB_common::tableInfo()

Overrides DB_common::tableInfo() (Returns information about a table or a result set)

Parameters:

object|string   $result   —  DB_result object from a query or a string containing the name of a table. While this also accepts a query result resource identifier, this behavior is deprecated.
int   $mode   —  a valid tableInfo mode

[ Top ]

_checkManip   [line 1108]

boolean _checkManip( string $query)

Checks if the given query is a manipulation query. This also takes into account the _next_query_manip flag and sets the _last_query_manip flag (and resets _next_query_manip) according to the result.
  • Return: true if the query is a manipulation query, false otherwise
  • Access: protected

Overrides DB_common::_checkManip() (Checks if the given query is a manipulation query. This also takes into account the _next_query_manip flag and sets the _last_query_manip flag (and resets _next_query_manip) according to the result.)

Parameters:

string   $query   —  The query to check.

[ Top ]
Documentation generated on Mon, 11 Mar 2019 16:04:20 -0400 by phpDocumentor 1.4.4. PEAR Logo Copyright © PHP Group 2004.