Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /var/www/html/api-truyentranh/includes/ |
<?php
class MyDB extends SQLite3
{
public $query_id = "";
public $record_row = array();
function __construct($link)
{
$this->open($link);
}
function query_my($the_query){
$this->query_id = $this->query($the_query);
return $this->query_id;
}
function exec_my($the_query){
$this->query_id = $this->exec($the_query);
return $this->query_id;
}
function insert_id(){
return $this->lastInsertRowID();
}
function fetch_row($query_id = "") {
if ($query_id == ""){
$query_id = $this->query_id;
}
$this->record_row = $query_id->fetchArray(SQLITE3_ASSOC);
return $this->record_row;
}
function get_num_rows($query_id = "") {
if($query_id=='') {
$res = $this->query_id->numColumns();
}else{
$res = $query_id->numColumns();
}
if($res>0){
return $res;
}else{
return 0;
}
}
function do_insert($table,$insData){
$columns = implode(", ",array_keys($insData));
$escaped_values = array_map(array($this,'real_escape_string'), array_values($insData));
foreach ($escaped_values as $idx=>$data){
$escaped_values[$idx] = "'".$data."'";
}
$values = implode(", ", $escaped_values);
$this->query_my("INSERT INTO $table ($columns) VALUES ($values);");
return $this->insert_id();
}
function real_escape_string($str){
return $this->escapeString($str);
}
function get_colum_tb($table){
$arr = array();
$q_colum = $this->query_my("SELECT name FROM PRAGMA_TABLE_INFO('".$table."');");
while ($r_colum = $this->fetch_row($q_colum)){
$arr[$r_colum['name']] = '';
}
return $arr;
}
}
?>