SCHLIX\cmsDatabase
Inherited from MySQLi
Protected Attributes
| protected | $is_initalized | = false |
| protected | $server | |
| protected | $username | |
| protected | $password | |
| protected | $db | |
| protected | $last_query | |
| protected | $last_query_result |
Public Attributes
| public | _debug_sql_ | = 0 |
Protected Methods
| protected array | fetch_result_as_array() Fetch the result of the last query and return it as an associative array Do not call this method directly
|
Public Methods
| public | __construct($server, $db, $username, $password) |
| public | q() Returns the query builder
|
| public | reselectDatabase() |
| public string | escapeString(string $s) Escape string, without the quote
|
| public type | sanitizeString(string $s, bool $add_quote=true) Escape string and add a quote by default. Set to FALSE so it won't add a quote
|
| public | getTableColumns($tablename) |
| public boolean | tableColumnExists(string $tablename, string $tablecolumn) Returns true if a table has the specified column
|
| public boolean | tableExists(string $tablename) Returns true if table exists. Use runtime (this script only
|
| public mixed | query(string $sql, array $data=NULL) Executes an SQL Query. If $data is specified, the variables will be bound to the specified query and escaped properly with mysqli_real_escape_string. If you are using a paremterized query, the default syntax is named statements like the PDO one, not the MySQLi one.
e.g. INTO tbl_example (id,value) VALUES (:id,:value)
Although it's doable, DO NOT mix sql with the value, e.g. if you want to do a non-paramterized statement, then don't mix it with the one that uses paramaterized statment
This is wrong: INTO tbl_example (id,value) VALUES (:id,'Sanitized string')
Although it will work it can have an unexpected outcome if the string contains variable name. e.g. ' .... String string string :example ....text'
|
| public array | getTimedCachedQueryResultArray(int $hours, int $minutes, int $seconds, string $sql, array $data=NULL) Returns a cached query result as an associative array (data row collection)
|
| public array Associative Array | getCachedQueryResultArray(string $sql, array $data=NULL) Returns a cached query result as an associative array (data row collection)
|
| public array Associative Array | getCachedQueryResultSingleRow(string $sql, array $data=NULL) Returns a single row from cache
|
| public array | getQueryResultSingleRow(string $sql, array $data=NULL) Get the first result of a query in (a single data row)
|
| public array | getQueryResultArray(string $sql, array $data=NULL) Get SQL query result as an associative array (data row collections)
|
| public int | getLastInsertID() Returns the last insert ID
|
| public | getLastQueryResult() |
| public | simpleInsertInto($table_name, $array) |
| public | simpleUpdate($table_name, $array, $where_key, $where_value) |
| public | searchAndReplace(string $table_name, string $field_name, string $search, string $replace, string $where_condition=NULL) Performs search and replace
|
| public | getAllRecordsFromTable($table_name, $data_fields, $extra_criteria, $fields=' *', $start, $end, $sortby='', $sortdirection='ASC', $from_cache=false) |
| public | generateSQLSelectParameters($tablename, $fields=' *', $extra_criteria='', $start, $end, $sortby='', $sortdirection='ASC', $force_limit=false) |
| public | generateSelectSQLStatement($tablename, $fields=' *', $extra_criteria='', $start, $end, $sortby='', $sortdirection='ASC', $add_where_clause=true, $force_limit=false) |
| public | __destruct() |