<!--?</span--> php
class SQLiteDB extends SQLite3 {
function __construct(){
try {
// Open the database file
$this->open('./ccfcf4572e60f80522c1cf0f8e4b95c3.db');
}catch (Exception $e){
die($e->getMessage());
}
}
}
class DBUtils
{
private static $db;
private static function instance()
{
if (! self::$db) {
self::$db = new SQLiteDB();
}
}
/ * *
* create a table
* @param string $sql
* /
public static function create($sql)
{
self::instance();
$result = @self::$db->query($sql);
if ($result) {
return true;
}
return false;
}
/ * *
* Perform add, delete or modify operations
* @param string $sql
* /
public static function execute($sql)
{
self::instance();
return @self::$db->exec($sql);
$result = @self::$db->exec($sql);
if ($result) {
return true;
}
return false;
}
/ * *
* Get the number of records
* @param string $sql
* @return int
* /
public static function count($sql)
{
self::instance();
$result = @self::$db->querySingle($sql);
return $result ?  $result : 0;
}
/ * *
* Query a single field
* @param string $sql
* @return void|string
* /
public static function querySingle($sql)
{
self::instance();
$result = @self::$db->querySingle($sql);
return $result ?  $result : '';
}
/ * *
* Query a single record
* @param string $sql
* @return array
* /
public static function queryRow($sql)
{
self::instance();
$result = @self::$db->querySingle($sql, true);
return $result;
}
/ * *
* Gets the insert ID
* @param $table
* @return mixed
* /
public static function getLastInsertId($table)
{
return self::$db->querySingle('select last_insert_rowid() from '.$table.' LIMIT 1');
}
/ * *
* Query multiple records
* @param string $sql
* @return array
* /
public static function queryList($sql)
{
self::instance();
$result = array();
$ret = @self::$db->query($sql);
if (! $ret) {
return $result;
}
while ($row = $ret->fetchArray(SQLITE3_ASSOC)) {
array_push($result, $row);
}
return $result;
}
}