dbal
public class dbal
| Field Summary | |
|---|---|
| mixed | Wildcards for matching any (%) or exactly one (_) character within LIKE expressions |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| mixed | Current sql layer |
| mixed | |
| mixed | Exact version of the DBAL, directly queried |
| mixed | |
| mixed | |
| mixed | |
| mixed | |
| Method Summary | |
|---|---|
| void | Constructor |
| void | sql_add_num_queries(bool cached) Add to query count |
| void | sql_bit_and(string column_name, int bit, string compare) Run binary AND operator on DB column. |
| void | sql_bit_or(string column_name, int bit, string compare) Run binary OR operator on DB column. |
| bool | sql_buffer_nested_transactions() Returns whether results of a query need to be buffered to run a transaction while iterating over them. |
| void | sql_build_array(mixed query, bool assoc_ary) Build sql statement from array for insert/update/select statementsIdea for this from Ikonboard Possible query values: INSERT, INSERT_SELECT, UPDATE, SELECT |
| void | sql_build_query(mixed query, mixed array) Build sql statement from array for select and select distinct statementsPossible query values: SELECT, SELECT_DISTINCT |
| void | DBAL garbage collection, close sql connection |
| void | sql_error(str sql) display sql error page |
| void | sql_fetchfield(mixed field, bool rownum, bool query_id) Fetch field if rownum is false, the current row is used, else it is pointing to the row (zero-based) |
| void | sql_fetchrowset(bool query_id) Fetch all rows |
| void | sql_in_set(string field, array array, bool negate, bool allow_empty_set) Build IN or NOT IN sql comparison string, uses or = on single element arrays to improve comparison speed |
| string | sql_like_expression(string expression) Correctly adjust LIKE expression for special characters Some DBMS are handling them in a different way |
| bool | sql_multi_insert(string table, mixed sql_ary, array &$sql_ary) Run more than one insert statement. |
| void | sql_num_queries(bool cached) Return number of sql queries and cached sql queries used |
| void | sql_query_limit(mixed query, mixed total, int offset, int cache_ttl) Build LIMIT query Doing some validation here. |
| void | sql_report(mixed mode, str query) Explain queries |
| void | sql_return_on_error(bool fail) return on error or display error message |
public mixed $any_char
Wildcards for matching any (%) or exactly one (_) character within LIKE expressions
public mixed $curtime = 0
public mixed $db_connect_id = false
public mixed $dbname = ''
public mixed $html_hold = ''
public mixed $multi_insert = false
public mixed $num_queries = array()
public mixed $one_char
public mixed $open_queries = array()
public mixed $persistency = false
public mixed $query_hold = ''
public mixed $query_result
public mixed $return_on_error = false
public mixed $server = ''
public mixed $sql_error_returned = array()
public mixed $sql_error_sql = ''
public mixed $sql_error_triggered = false
public mixed $sql_layer = ''
Current sql layer
public mixed $sql_report = ''
public mixed $sql_server_version = false
Exact version of the DBAL, directly queried
public mixed $sql_time = 0
public mixed $transaction = false
public mixed $transactions = 0
public mixed $user = ''
public void __construct()
Constructor
public void sql_add_num_queries(bool cached)
Add to query count
public void sql_bit_and(string column_name, int bit, string compare)
Run binary AND operator on DB column. Results in sql statement: "{$column_name} & (1 << {$bit}) {$compare}"
public void sql_bit_or(string column_name, int bit, string compare)
Run binary OR operator on DB column. Results in sql statement: "{$column_name} | (1 << {$bit}) {$compare}"
public bool sql_buffer_nested_transactions()
Returns whether results of a query need to be buffered to run a transaction while iterating over them.
public void sql_build_array(mixed query, bool assoc_ary)
Build sql statement from array for insert/update/select statements
Idea for this from Ikonboard Possible query values: INSERT, INSERT_SELECT, UPDATE, SELECT
public void sql_build_query(mixed query, mixed array)
Build sql statement from array for select and select distinct statements
Possible query values: SELECT, SELECT_DISTINCT
public void sql_close()
DBAL garbage collection, close sql connection
public void sql_error(str sql)
display sql error page
public void sql_fetchfield(mixed field, bool rownum, bool query_id)
Fetch field if rownum is false, the current row is used, else it is pointing to the row (zero-based)
public void sql_fetchrowset(bool query_id)
Fetch all rows
public void sql_in_set(string field, array array, bool negate, bool allow_empty_set)
Build IN or NOT IN sql comparison string, uses <> or = on single element arrays to improve comparison speed
public string sql_like_expression(string expression)
Correctly adjust LIKE expression for special characters Some DBMS are handling them in a different way
public bool sql_multi_insert(string table, mixed sql_ary, array &$sql_ary)
Run more than one insert statement.
public void sql_num_queries(bool cached)
Return number of sql queries and cached sql queries used
public void sql_query_limit(mixed query, mixed total, int offset, int cache_ttl)
Build LIMIT query Doing some validation here.
public void sql_report(mixed mode, str query)
Explain queries
public void sql_return_on_error(bool fail)
return on error or display error message
Database Abstraction Layer