[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/includes/db/ -> postgres.php (summary)

(no description)

Copyright: (c) 2005 phpBB Group
License: http://opensource.org/licenses/gpl-license.php GNU Public License
Version: $Id$
File Size: 485 lines (10 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

dbal_postgres:: (16 methods):
  sql_connect()
  sql_server_info()
  _sql_transaction()
  sql_query()
  _sql_custom_build()
  _sql_query_limit()
  sql_affectedrows()
  sql_fetchrow()
  sql_rowseek()
  sql_nextid()
  sql_freeresult()
  sql_escape()
  _sql_like_expression()
  _sql_error()
  _sql_close()
  _sql_report()


Class: dbal_postgres  - X-Ref

PostgreSQL Database Abstraction Layer
Minimum Requirement is Version 7.3+

sql_connect($sqlserver, $sqluser, $sqlpassword, $database, $port = false, $persistency = false, $new_link = false)   X-Ref
Connect to server


sql_server_info($raw = false, $use_cache = true)   X-Ref
Version information about used database

param: bool $raw if true, only return the fetched sql_server_version
param: bool $use_cache If true, it is safe to retrieve the value from the cache
return: string sql server version

_sql_transaction($status = 'begin')   X-Ref
SQL Transaction


sql_query($query = '', $cache_ttl = 0)   X-Ref
Base query method

param: string    $query        Contains the SQL query which shall be executed
param: int        $cache_ttl    Either 0 to avoid caching or the time in seconds which the result shall be kept in cache
return: mixed                When casted to bool the returned value returns true on success and false on failure

_sql_custom_build($stage, $data)   X-Ref
Build db-specific query data


_sql_query_limit($query, $total, $offset = 0, $cache_ttl = 0)   X-Ref
Build LIMIT query


sql_affectedrows()   X-Ref
Return number of affected rows


sql_fetchrow($query_id = false)   X-Ref
Fetch current row


sql_rowseek($rownum, &$query_id)   X-Ref
Seek to given row number
rownum is zero-based


sql_nextid()   X-Ref
Get last inserted id after insert statement


sql_freeresult($query_id = false)   X-Ref
Free sql result


sql_escape($msg)   X-Ref
Escape string used in sql query
Note: Do not use for bytea values if we may use them at a later stage


_sql_like_expression($expression)   X-Ref
Build LIKE expression


_sql_error()   X-Ref
return sql error array


_sql_close()   X-Ref
Close sql connection


_sql_report($mode, $query = '')   X-Ref
Build db-specific report




Generated: Wed Oct 2 15:03:47 2013 Cross-referenced by PHPXref 0.7.1