コード例 #1
0
 /**
  * Execute query
  *
  * @param string $query unparsed query
  * @param mixed ... unlimited number of variables for placeholders
  * @return mixed result set for "SELECT" statement / generated ID for an AUTO_INCREMENT field for insert statement / Affected rows count for DELETE/UPDATE statements
  */
 public static function query($query)
 {
     if (!self::$raw) {
         fn_set_hook('db_query', $query);
     }
     $args = func_get_args();
     $query = self::process($query, array_slice($args, 1), true);
     $result = false;
     if (!empty($query)) {
         if (!self::$raw) {
             fn_set_hook('db_query_process', $query);
         }
         if (defined('DEBUG_QUERIES')) {
             fn_print_r($query);
         }
         $time_start = microtime(true);
         $result = self::$_db->query($query);
         $a_row = self::$_db->affectedRows($result);
         Debugger::set_query($query, microtime(true) - $time_start);
         self::_error($result, $query);
         // Get last inserted ID
         $i_id = self::$_db->insertId();
         if (!self::$raw) {
             fn_set_hook('db_query_executed', $query, $result);
         }
         // "true" will be returned for Update/Delete/Insert/Replace statements. "SELECT" returns MySQLi/PDO object
         if ($result === true) {
             $cmd = substr($query, 0, 6);
             // Check if it was insert statement with auto_increment value and return it
             if (!empty($i_id)) {
                 $result = $i_id;
             } elseif ($cmd == 'UPDATE' || $cmd == 'DELETE' || $cmd == 'INSERT') {
                 $result = $a_row;
             }
             // Check if query updated data in the database and run cache handlers
             if (!empty($result) && preg_match("/^(UPDATE|INSERT INTO|REPLACE INTO|DELETE FROM) " . self::$_table_prefix . "(\\w+) /", $query, $m)) {
                 Registry::setChangedTables($m[2]);
             }
         }
     }
     self::$raw = false;
     return $result;
 }
コード例 #2
0
ファイル: Database.php プロジェクト: askzap/ultimate
 /**
  * Execute query
  *
  * @param string $query unparsed query
  * @param mixed ... unlimited number of variables for placeholders
  * @return mixed result set for "SELECT" statement / generated ID for an AUTO_INCREMENT field for insert statement / Affected rows count for DELETE/UPDATE statements
  */
 public static function query($query)
 {
     if (!self::$raw) {
         fn_set_hook('db_query', $query);
     }
     $args = func_get_args();
     $query = self::process($query, array_slice($args, 1), true);
     $result = false;
     if (!empty($query)) {
         if (!self::$raw) {
             fn_set_hook('db_query_process', $query);
         }
         if (defined('DEBUG_QUERIES')) {
             fn_print_r($query);
         }
         $time_start = microtime(true);
         $result = self::$db->query($query);
         if (!self::error($result, $query)) {
             $insert_id = self::$db->insertId();
             Debugger::set_query($query, microtime(true) - $time_start);
             if (!self::$raw) {
                 fn_set_hook('db_query_executed', $query, $result);
             }
             // "true" will be returned for Update/Delete/Insert/Replace statements. "SELECT" returns MySQLi/PDO object
             if ($result === true) {
                 $cmd = substr($query, 0, 6);
                 // Check if it was insert statement with auto_increment value and return it
                 if (!empty($insert_id)) {
                     $result = $insert_id;
                 } elseif ($cmd == 'UPDATE' || $cmd == 'DELETE' || $cmd == 'INSERT') {
                     $result = self::$db->affectedRows($result);
                 }
                 // Check if query updated data in the database and run cache handlers
                 if (!empty($result) && preg_match("/^(UPDATE|INSERT INTO|REPLACE INTO|DELETE FROM) " . self::$table_prefix . "(\\w+) /", $query, $m)) {
                     Registry::setChangedTables($m[2]);
                 }
             }
         } else {
             // Lost connection, try to reconnect
             if (self::tryReconnect()) {
                 return self::query($query);
                 // Assume that the table is broken
                 // Try to repair
             } elseif (preg_match("/'(\\S+)\\.(MYI|MYD)/", self::$db->error(), $matches)) {
                 self::$db->query("REPAIR TABLE {$matches['1']}");
                 return self::query($query);
             }
         }
     }
     self::$raw = false;
     return $result;
 }