pclib  2.9.5
Lightweight PHP framework
Public Member Functions | Data Fields
PgsqlDriver Class Reference

PostgreSQL database driver. More...

Inheritance diagram for PgsqlDriver:
AbstractDriver

Public Member Functions

 connect ($ds)
 Connect to database. More...
 
 close ()
 Close database connection.
 
 seek ($res, $rowno)
 Seek resource $res to position $rowno.
 
 getInsertId ()
 Return last insert id.
 
 numRows ($res=null)
 Return number of rows in result $res.
 
 affectedRows ($res=null)
 Return number of rows affected.
 
 query ($sql)
 Execute query $sql.
 
 fetch ($res=null, $fmt='a')
 Fetch one row from query result. More...
 
 lastError ()
 Return last driver error message.
 
 codePage ($cp)
 Set connection character set. More...
 
 dbName ()
 Return current database name.
 
 indexes ($table)
 Return indexes of table $table as associative array.
 
 columns ($table)
 Return columns metadata (name,size,type,nullable,default) of table $table as associative array. More...
 
 escape ($str, $type='string')
 Escape parameters for usage in database query. More...
 
- Public Member Functions inherited from AbstractDriver
 setLimit ($numRows, $offset=0)
 The portable way to perform limit. More...
 
 quote ($str)
 Quote identifier.
 

Data Fields

 $ucase = 0
 Convert array keys of result set to UPPERCASE, if > 0. More...
 
- Data Fields inherited from AbstractDriver
 $connection
 Active database connection link.
 
 $error
 Contains last error message - test it after calling any db-function to check if any error occurs.
 
 $res
 Store last query result resource. More...
 
 $forceReconnect = true
 Create new connection even if connection with same params exists.
 
 $extension
 Required PHP extension - such as 'mysql'.
 
 $verboseErrors = false
 Include internal details (such as SQL code) into error messages.
 

Additional Inherited Members

- Protected Attributes inherited from AbstractDriver
 $limit
 Store portable limit clausule.
 

Detailed Description

PostgreSQL database driver.

Implements support of PostgreSQL database engine.

Member Function Documentation

◆ codePage()

codePage (   $cp)

Set connection character set.

Parameters
string$cpcodepage - e.g. 'cp1250'

Reimplemented from AbstractDriver.

◆ columns()

columns (   $table)

Return columns metadata (name,size,type,nullable,default) of table $table as associative array.

Returns
array $columns

Reimplemented from AbstractDriver.

◆ connect()

connect (   $ds)

Connect to database.

Parameters
array$dsdatasource: array( 'driver' => $driver, 'host' => $host, 'dbname' => $dbname, 'user' => $user, 'passw' => $passw, 'codepage' => $codepage );

Reimplemented from AbstractDriver.

◆ escape()

escape (   $str,
  $type = 'string' 
)

Escape parameters for usage in database query.

Parameters
string$strString (parameter) to be escaped
string$typeCan be 'string' or 'ident'
Returns
string $str escaped string

Reimplemented from AbstractDriver.

◆ fetch()

fetch (   $res = null,
  $fmt = 'a' 
)

Fetch one row from query result.

If result $res is ommited, it uses last query result.

Parameters
resource$resQuery result resource
string$fmtformat of result a - assoc, o - object, r - row, ar - array, f - field
Returns
array|object $row result row

Reimplemented from AbstractDriver.

Field Documentation

◆ $ucase

$ucase = 0

Convert array keys of result set to UPPERCASE, if > 0.

Hack for access to pclib system tables, which assumes uppercase field names.


The documentation for this class was generated from the following file: