/**
* db_execute_return::db_execute()
*
* @param string $query : cau truy van
* @param string $file_line_query : Loi se ghi
* @return int :ID duoc them vao cuoi cung.
*/
function db_execute($query, $file_line_query = ""){
$dbinit = new db_init();
$this->links = @mysql_pconnect($dbinit->server, $dbinit->username, $dbinit->passworddb);
@mysql_select_db($dbinit->database);
@mysql_query("SET NAMES 'utf8'");
@mysql_query($query);
$total = @mysql_affected_rows();
//neu ket qua khong thanh cong và khong phai là insert ignore
if($total < 0 && strpos($query, "IGNORE") === false ){
$error = @mysql_error($this->links);
@mysql_close($this->links);
$dbinit->log("error_sql", $file_line_query . " " . $error . "\n" . $query);
}
$last_id = 0;
$this->result = @mysql_query("select LAST_INSERT_ID() as last_id",$this->links);
if($row = @mysql_fetch_array($this->result)){
$last_id = $row["last_id"];
}
@mysql_close($this->links);
//ghi query ra log de kiem tra
$dbinit->debug_query($query, $file_line_query);
//huy bien
unset($dbinit);
return $last_id;
}
function db_execute($query, $auto_log = true)
{
$dbinit = new db_init();
$this->links = mysqli_connect($dbinit->server, $dbinit->username, $dbinit->password);
mysqli_select_db($this->links, $dbinit->database);
mysqli_query($this->links, "SET NAMES 'utf8'");
mysqli_query($this->links, $query);
//log query để update lên server
if ($auto_log) {
$dbinit->log_execute_query($query);
}
$this->total = mysqli_affected_rows($this->links);
$last_id = 0;
$this->result = mysqli_query($this->links, "select LAST_INSERT_ID() as last_id");
if ($row = mysqli_fetch_array($this->result)) {
$last_id = $row["last_id"];
}
unset($dbinit);
mysqli_close($this->links);
return $last_id;
}
