DB

Database Server host (IP or hostname)

fatal abbort on connection error, default true

Type of query [insert, replace, update]

Table Name

1-dim Array with field names (select) or 2-dim Array with field names and their field values

2-dim Array with additional options $params['table_structure'] --> Pass table structure array to perform additional auto-transformation based on field information $params['where'] --> Where condition, e.g. where=>'id=1' $params['limit'] --> Limit condition, e.g. limit=>'1,10'

If true, lquery() instead of query() will be used.

Returns DB->query result

SQL Query String (with system-wide table name placeholders e.g. ###sys|tablename###)

SQL Query String

SQL Query String

SQL Query String

Commit Status

String to be escaped

If enabled float values will be converted to the correct mySQL syntax

escaped string

Search Term (e.g. master AND proxy OR tennis), Support for AND, OR, and ""

2-dim array with search term parts $return['mode'], $return['term']

string SQL Query

Returns null if server is not running MariaDB

Get the current Charset

multi-dim array with table structure

Assoc-Array, e.g. array('fieldname'=>'fieldvalue', ....)

Array with query SQLs or array pairs with Query and Placeholders e.g. ['SQL1', 'SQL2, ['SQL :placeholder', ['placeholder':'Hello']]]

Set to true to return an array of results if needed

By default all queries are executed within a single transaction for best performance (e.g. inserts bundled in a single transaction massively reduce the need to recalculate the index)

If returnResults is true all results are being returned as array

SQL Query with classic markers (?) or named marker (e.g. ':name')

Simple Array (for classic marker - must be the same order as in SQL) OR Assoc Array (for named marker)

DEBUG Filename (FILE)

DEBUG Line (LINE)

TTL in seconds

Cache PREFIX for removal

SQL Query

Fetch function that is used for SELECT queries [MYSQLI_ASSOC, MYSQLI_BOTH, MYSQL_NUM. Use 'mysql_result' or 'mysql_result_nobuffer' to work on mysql result object]

DEBUG Filename (FILE)

DEBUG Line (LINE)

Cache TTL (Negativ TTL invalidates and refreshes existing caches)

Cache Group

reference to string indicates if query was an update/delete or an insert (INSERT, UPDATE, DELETE)

Returns false in case of error or no records, Returns the number of affected rows in case of UPDATE/DELETE statement, Returns a result array in case of SELECT statement

SQL Query

Assoc Array with placeholder values

Fetch function that is used for SELECT queries [MYSQLI_ASSOC, MYSQLI_BOTH, MYSQL_NUM or 'mysql_result']

DEBUG Filename (FILE)

DEBUG Line (LINE)

Cache TTL (Negativ TTL invalidates and refreshes existing caches)

Cache Group

reference to string indicates if query was an update/delete or an insert (INSERT, UPDATE, DELETE)

Returns false in case of error, Returns the number of affected rows in case of UPDATE/DELETE statement, Returns a result array in case of SELECT statement

string SQL Query

Query String with placeholders

Assoc-Array with keys being the placeholder names, e.g. ['firstname'=>'Daniel'] can be referenced with ' :firstname ' in query

Return Format: 'value' -> Returns the query with the values inserted OR 'prepared_statement' -> Returns the query with ? placeholders and the respective values in $value_list

Returns the used values in the order as they are being used in the query

Rollback Status

SQL Query

Returns resource to the data source

enable or disable autocommit

TimeZone in mySQL Timezone format

Assoc-Array, e.g. array('fieldname'=>'fieldvalue', ....)