- * return on error or display error message

- * Return number of sql queries and cached sql queries used

- * Add to query count

- * DBAL garbage collection, close sql connection

- * Build LIMIT query

- * Doing some validation here.

- * Fetch all rows

- * Seek to given row number

- * rownum is zero-based

- * Fetch field

- * if rownum is false, the current row is used, else it is pointing to the row (zero-based)

- * Correctly adjust LIKE expression for special characters

- * Some DBMS are handling them in a different way

- *

- * @param string $expression The expression to use. Every wildcard is escaped, except $this->any_char and $this->one_char

- * @return string LIKE expression including the keyword!

- * Build a case expression

- *

- * Note: The two statements action_true and action_false must have the same data type (int, vchar, ...) in the database!

- *

- * @param string $condition The condition which must be true, to use action_true rather then action_else

- * @param string $action_true SQL expression that is used, if the condition is true

- * @param string $action_else SQL expression that is used, if the condition is false, optional

- * @return string CASE expression including the condition and statements

- * Build a concatenated expression

- *

- * @param string $expr1 Base SQL expression where we append the second one

- * @param string $expr2 SQL expression that is appended to the first expression

- * @return string Concatenated string

- * Returns whether results of a query need to be buffered to run a transaction while iterating over them.

- *

- * @return bool Whether buffering is required.

- * SQL Transaction

- * @access private

- // If there was a previously opened transaction we do not commit yet... but count back the number of inner transactions

- // Check if there is a transaction (no transaction can happen if there was an error, with a combined rollback and error returning enabled)

- * Build sql statement from array for insert/update/select statements

- *

- * Idea for this from Ikonboard

- * Possible query values: INSERT, INSERT_SELECT, UPDATE, SELECT, DELETE

- *

- * Build IN or NOT IN sql comparison string, uses <> or = on single element

- * arrays to improve comparison speed

- *

- * @access public

- * @param string $field name of the sql column that shall be compared

- * @param array $array array of values that are allowed (IN) or not allowed (NOT IN)

- * @param bool $negate true for NOT IN (), false for IN () (default)

- * @param bool $allow_empty_set If true, allow $array to be empty, this function will return 1=1 or 1=0 then. Default to false.

- * Run binary AND operator on DB column.

- * Results in sql statement: "{$column_name} & (1 << {$bit}) {$compare}"

- *

- * @param string $column_name The column name to use

- * @param int $bit The value to use for the AND operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29

- * @param string $compare Any custom SQL code after the check (for example "= 0")

- * Run binary OR operator on DB column.

- * Results in sql statement: "{$column_name} | (1 << {$bit}) {$compare}"

- *

- * @param string $column_name The column name to use

- * @param int $bit The value to use for the OR operator, will be converted to (1 << $bit). Is used by options, using the number schema... 0, 1, 2...29

- * @param string $compare Any custom SQL code after the check (for example "= 0")

- * Returns SQL string to cast a string expression to an int.

- *

- * @param string $expression An expression evaluating to string

- * @return string Expression returning an int

- * Returns SQL string to cast an integer expression to a string.

- *

- * @param string $expression An expression evaluating to int

- * @return string Expression returning a string

- * Run LOWER() on DB column of type text (i.e. neither varchar nor char).

- *

- * @param string $column_name The column name to use

- *

- * @return string A SQL statement like "LOWER($column_name)"

- * Run more than one insert statement.

- *

- * @param string $table table name to run the statements on

- * @param array $sql_ary multi-dimensional array holding the statement data.

- *

- * @return bool false if no statements were executed.

- * @access public

- * Build sql statement from array for select and select distinct statements

- *

- * Possible query values: SELECT, SELECT_DISTINCT

- * display sql error page

- * Explain queries

- * Gets the estimated number of rows in a specified table.

- *

- * @param string $table_name Table name

- *

- * @return string Number of rows in $table_name.

- * Prefixed with ~ if estimated (otherwise exact).

- *

- * @access public

- * Gets the exact number of rows in a specified table.

- *

- * @param string $table_name Table name

- *

- * @return string Exact number of rows in $table_name.

- *

- * @access public

- * Connect to server

- * Version information about used database

- * @param bool $raw if true, only return the fetched sql_server_version

- * @param bool $use_cache forced to false for Interbase

- * @return string sql server version

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

- * @inheritdoc

- * @inheritdoc

- * Connect to server

- * 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

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Seek to given row number

- * rownum is zero-based

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

- * Escape string used in sql query

- * Connect to server

- * 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

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * @note number of bytes returned depends on odbc.defaultlrl php.ini setting. If it is limited to 4K for example only 4K of data is returned max.

- * Get last inserted id after insert statement

- * Free sql result

- * Connect to server

- * 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

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Get last inserted id after insert statement

- * Free sql result

- * Connect to server

- * @access public

- * 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

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Seek to given row number

- * rownum is zero-based

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

- * Gets the estimated number of rows in a specified table.

- *

- * @param string $table_name Table name

- *

- * @return string Number of rows in $table_name.

- * Prefixed with ~ if estimated (otherwise exact).

- *

- * @access public

- * Gets the exact number of rows in a specified table.

- *

- * @param string $table_name Table name

- *

- * @return string Exact number of rows in $table_name.

- *

- * @access public

- * Connect to server

- * 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

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Seek to given row number

- * rownum is zero-based

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

- * Connect to server

- * Version information about used database

- * @param bool $raw if true, only return the fetched sql_server_version

- * @param bool $use_cache forced to false for Oracle

- * @return string sql server version

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Seek to given row number

- * rownum is zero-based

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

- * Connect to server

- * 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

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Seek to given row number

- * rownum is zero-based

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

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

- * @inheritdoc

- * @inheritdoc

- * Connect to server

- * 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 stored value from the cache

- * @return string sql server version

- * 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

- *

- * @access public

- * Return number of affected rows

- * Fetch current row

- * Seek to given row number

- * rownum is zero-based

- * Get last inserted id after insert statement

- * Free sql result

- * Escape string used in sql query

- * Correctly adjust LIKE expression for special characters