pclib
2.9.5
Lightweight PHP framework
|
PostgreSQL database driver. More...
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. | |
PostgreSQL database driver.
Implements support of PostgreSQL database engine.
codePage | ( | $cp | ) |
Set connection character set.
string | $cp | codepage - e.g. 'cp1250' |
Reimplemented from AbstractDriver.
columns | ( | $table | ) |
Return columns metadata (name,size,type,nullable,default) of table $table as associative array.
Reimplemented from AbstractDriver.
connect | ( | $ds | ) |
Connect to database.
array | $ds | datasource: array( 'driver' => $driver, 'host' => $host, 'dbname' => $dbname, 'user' => $user, 'passw' => $passw, 'codepage' => $codepage ); |
Reimplemented from AbstractDriver.
escape | ( | $str, | |
$type = 'string' |
|||
) |
Escape parameters for usage in database query.
string | $str | String (parameter) to be escaped |
string | $type | Can be 'string' or 'ident' |
Reimplemented from AbstractDriver.
fetch | ( | $res = null , |
|
$fmt = 'a' |
|||
) |
Fetch one row from query result.
If result $res is ommited, it uses last query result.
resource | $res | Query result resource |
string | $fmt | format of result a - assoc, o - object, r - row, ar - array, f - field |
Reimplemented from AbstractDriver.
$ucase = 0 |
Convert array keys of result set to UPPERCASE, if > 0.
Hack for access to pclib system tables, which assumes uppercase field names.