[ Index ]

PHP Cross Reference of phpBB 3.0 Beta 3

title

Body

[close]

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

(no description)

Copyright: (c) 2005 phpBB Group
License: http://opensource.org/licenses/gpl-license.php GNU Public License
Version: $Id: dbal.php,v 1.46 2006/11/10 13:49:05 acydburn Exp $
File Size: 699 lines (17 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

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


Class: dbal  - X-Ref

Database Abstraction Layer

dbal()   X-Ref
Constructor


sql_return_on_error($fail = false)   X-Ref
return on error or display error message


sql_num_queries($cached = false)   X-Ref
Return number of sql queries and cached sql queries used


sql_add_num_queries($cached = false)   X-Ref
Add to query count


sql_close()   X-Ref
DBAL garbage collection, close sql connection


sql_fetchrowset($query_id = false)   X-Ref
Fetch all rows


sql_fetchfield($field, $rownum = false, $query_id = false)   X-Ref
Fetch field
if rownum is false, the current row is used, else it is pointing to the row (zero-based)


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


sql_build_array($query, $assoc_ary = false)   X-Ref
Build sql statement from array for insert/update/select statements

Idea for this from Ikonboard
Possible query values: INSERT, INSERT_SELECT, MULTI_INSERT, UPDATE, SELECT


sql_in_set($field, $array, $negate = false)   X-Ref
Build IN, NOT IN, = and <> sql comparison string.


sql_multi_insert($table, &$sql_ary)   X-Ref
Run more than one insert statement.

param: $sql_ary array multi-dimensional array holding the statement data.
param: $table string table name to run the statements on
return: bool false if no statements were executed.

_sql_validate_value($var)   X-Ref
Function for validating values


sql_build_query($query, $array)   X-Ref
Build sql statement from array for select and select distinct statements

Possible query values: SELECT, SELECT_DISTINCT

sql_error($sql = '')   X-Ref
display sql error page


sql_report($mode, $query = '')   X-Ref
Explain queries




Generated: Wed Nov 22 00:35:05 2006 Cross-referenced by PHPXref 0.6