extends |
DbEngine |
---|
sqlite class
This class should be responsible for all sqlite Database activities
Methods | ||
---|---|---|
public
|
connect($db1 = "", $dhost1 = "", $duser1 = "", $dpass1 = ""): Sqlite
|
# |
public
|
cleanQuery($string)
|
# |
public
|
clearQuery($string)
|
# |
public
|
executeQuery($sql)
|
# |
public
|
executeQueryQuick($sql)
|
# |
public
|
commit()
|
# |
public
|
getDatabaseLink()
|
# |
public
|
prepare($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
|
fetchQuery($sql = "", $ttl = 0, $filename = "", $key = "id", $issave = false)
|
# |
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
|
# |