/** * 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; }