Class MySQL

`extends`	`DbEngine`

MySQL class

This class should be responsible for all mysql Database activities

Sphp\kit\DbEngine
- MySQL

Located at Score/SphpDoc/lib/MySQL.php

Methods
`public`	`connect($db1 = "", $dhost1 = "", $duser1 = "", $dpass1 = ""): MySQL` Class Constructor This returns the MySQL class object Class Constructor This returns the MySQL class object	#
`public`	`cleanQuery($string)` Fix Bad Format in Query call clearQuery Fix Bad Format in Query call clearQuery Overrides `Sphp\kit\DbEngine::cleanQuery()`	#
`public`	`clearQuery($string)` Fix Bad Format in Query Fix Bad Format in Query Overrides `Sphp\kit\DbEngine::clearQuery()`	#
`public`	`executeQuery($sql)`	#
`public`	`executeQueryQuick($sql)`	#
`public`	`commitRollback()`	#
`public`	`commit()`	#
`public`	`rollback()`	#
`public`	`disableAutoCommit()`	#
`public`	`enableAutoCommit()`	#
`public`	`getDatabaseLink()`	#
`public`	`multiQuery($sql)`	#
`public`	`prepare($sql)`	#
`public`	`executeQueryJFX($sql)`	#
`public`	`executeQueryQuickJFX($sql)`	#
`public`	`disconnect()`	#
`public`	`updateSQL($frm, $txttbl, $where)`	#
`public`	`insertSQL($frm, $txttbl)`	#
`public`	`searchSQL($frm, $tbllist, $where, $OP)`	#
`public`	`createDatabase()`	#
`public`	`createTable($sql)`	#
`public`	`dropTable($tableName)`	#
`public`	`isRecordExist($sql)`	#
`public`	`row_fetch_assoc($result)`	#
`public`	`last_insert_id()`	#
`public`	`isCacheExpired($filename, $ttl)`	#
`public`	`fetchQuery($sql = "", $ttl = 0, $filename = "", $key = "id", $issave = false)`	#
`public`	`insertCache($filename, $key, $data = [], $tbls = "", $sql = "")`	#
`public`	`clearCache($filename)`	#
`public`	`updateCache($filename, $keymap, $data = [], $where = "", $tbls = "", $sql = "")`	#
`public`	`deleteCache($filename, $keymap, $where = "", $tbls = "", $sql = "")`	#
`public`	`updateCacheSQL($filename, $key, $sql, $priority = 1)`	#
`public`	`executeUpdateCacheSQL($filename)`	#

Methods inherited from Sphp\kit\DbEngine
`getTableSQL(), getTableColumns(), getDbTables(), getCreateTableSQL(), saveToCache(), getFromCache()`

Properties
`public static`	`$dlink`	#
`public static`	`$isConnect = false`	#
`public`	`$all_query_ok = true`	#

Namespaces

Classes

Exceptions

Functions

Class MySQL

Overrides

Overrides