| Methods |
public
|
connect($db1 = "", $dhost1 = "", $duser1 = "", $dpass1 = ""): Sqlite
Class Constructor
This returns the sqlite class object
Class Constructor
This returns the sqlite class object
|
#
|
public
|
cleanQuery($string)
Fix Bad Format in Query call clearQuery
Fix Bad Format in Query call clearQuery
Overrides
|
#
|
public
|
clearQuery($string)
Fix Bad Format in Query
|
#
|
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
|
row_fetch_array($result)
|
#
|
public
|
last_insert_id()
|
#
|
public
|
fetchQuery($sql = "", $ttl = 0, $filename = "", $key = "id", $issave = false)
|
#
|
public
|
getDbTables(): array
List Tables in Database. execute SHOW TABLES query. Override this function when you need to
create of database adapter.
List Tables in Database. execute SHOW TABLES query. Override this function when you need to
create of database adapter.
Overrides
|
#
|
public
|
getTableColumns(string $tablename): array
List Fields in a Table. Override this function when you need to
create of database adapter. Default work with MySQL
List Fields in a Table. Override this function when you need to
create of database adapter. Default work with MySQL
Parameters
| $tablename |
pass table name in database
|
Overrides
|
#
|
public
|
is_rows($result): boolean
Check if result has rows of data
Check if result has rows of data
Returns
Overrides
|
#
|