PostgreSQL Database Abstraction Layer

Minimum Requirement is Version 7.3+

Located in /includes/db/postgres.php (line 26)

dbal
   |
   --dbal_postgres

mixed $last_query_text = '' (line 28)

mixed $pgsql_version (line 29)

Inherited Variables

Inherited from dbal

dbal::$any_char
dbal::$curtime
dbal::$dbname
dbal::$db_connect_id
dbal::$html_hold
dbal::$multi_insert
dbal::$num_queries
dbal::$one_char
dbal::$open_queries
dbal::$persistency
dbal::$query_hold
dbal::$query_result
dbal::$return_on_error
dbal::$server
dbal::$sql_error_returned
dbal::$sql_error_sql
dbal::$sql_error_triggered
dbal::$sql_layer
dbal::$sql_report
dbal::$sql_time
dbal::$transaction
dbal::$transactions
dbal::$user

sql_affectedrows (line 238)

Return number of affected rows

void sql_affectedrows ()

sql_connect (line 34)

Connect to server

void sql_connect ( $sqlserver,  $sqluser,  $sqlpassword,  $database, [ $port = false], [ $persistency = false], [ $new_link = false])

• $sqlserver
• $sqluser
• $sqlpassword
• $database
• $port
• $persistency
• $new_link

sql_escape (line 343)

Escape string used in sql query

Note: Do not use for bytea values if we may use them at a later stage

void sql_escape ( $msg)

• $msg

sql_fetchrow (line 246)

Fetch current row

void sql_fetchrow ([ $query_id = false])

• $query_id

sql_freeresult (line 316)

Free sql result

void sql_freeresult ([ $query_id = false])

• $query_id

sql_nextid (line 287)

Get last inserted id after insert statement

void sql_nextid ()

sql_query (line 157)

Base query method

• return: When casted to bool the returned value returns true on success and false on failure
• access: public

mixed sql_query ([string $query = ''], [int $cache_ttl = 0])

• string $query: Contains the SQL query which shall be executed
• int $cache_ttl: Either 0 to avoid caching or the time in seconds which the result shall be kept in cache

sql_rowseek (line 267)

Seek to given row number

rownum is zero-based

void sql_rowseek ( $rownum,  &$query_id)

• $rownum
• &$query_id

sql_server_info (line 119)

Version information about used database

void sql_server_info ()

_sql_close (line 373)

Close sql connection

• access: private

void _sql_close ()

_sql_custom_build (line 212)

Build db-specific query data

• access: private

void _sql_custom_build ( $stage,  $data)

• $stage
• $data

_sql_error (line 361)

return sql error array

• access: private

void _sql_error ()

_sql_like_expression (line 352)

Build LIKE expression

• access: private

void _sql_like_expression ( $expression)

• $expression

_sql_query_limit (line 220)

Build LIMIT query

void _sql_query_limit ( $query,  $total, [ $offset = 0], [ $cache_ttl = 0])

• $query
• $total
• $offset
• $cache_ttl

_sql_report (line 382)

Build db-specific report

• access: private

void _sql_report ( $mode, [ $query = ''])

• $mode
• $query

_sql_transaction (line 128)

SQL Transaction

• access: private

void _sql_transaction ([ $status = 'begin'])

• $status

Inherited Methods

Inherited From dbal

dbal::dbal()
dbal::sql_add_num_queries()
dbal::sql_build_array()
dbal::sql_build_query()
dbal::sql_close()
dbal::sql_error()
dbal::sql_fetchfield()
dbal::sql_fetchrowset()
dbal::sql_in_set()
dbal::sql_like_expression()
dbal::sql_multi_insert()
dbal::sql_num_queries()
dbal::sql_query_limit()
dbal::sql_report()
dbal::sql_return_on_error()
dbal::sql_transaction()
dbal::_sql_validate_value()