extends |
DbEngine |
|---|
MySQL class
This class should be responsible for all mysql Database activities
| Methods | ||
|---|---|---|
public
|
connectServer($dhost1, $duser1, $dpass1): MySQL
|
# |
public
|
connect($db1 = "", $dhost1 = "", $duser1 = "", $dpass1 = "")
|
# |
public
|
selectDB($db1)
|
# |
public
|
cleanQuery($string)
|
# |
public
|
clearQuery($string)
|
# |
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
|
runSQL($table, $ar)
|
# |
public
|
insertSQL($frm, $txttbl)
|
# |
public
|
insertSQLMulti(array $arr, string $txttbl): string
|
# |
public
|
searchSQL($frm, $tbllist, $where, $OP)
|
# |
public
|
createDatabase()
|
# |
public
|
createTable($sql)
|
# |
public
|
dropTable($tableName)
|
# |
public
|
isRecordExist(string $sql): bool|Array
|
# |
public
|
row_fetch_assoc($result)
|
# |
public
|
row_fetch_array($result)
|
# |
public
|
last_insert_id()
|
# |
| Properties | |||
|---|---|---|---|
public
static
|
|
$dlink
|
# |
public
static
|
|
$isConnect = false
|
# |
public
|
|
$all_query_ok = true
|
# |
public
|
|
$sphp_api = null
|
# |