PHP MySQLi::more_results方法代码示例

 public function multiQuery($sSQL)
 {
     $start = microtime(true);
     $this->connect();
     // Increase the counter
     $this->query_counter++;
     $result = $this->connection->multi_query(trim($sSQL));
     // FLUSH RESULTS
     // @TODO make these usable
     do {
         $r = $this->connection->store_result();
         if ($r) {
             $r->free();
         }
         if (!$this->connection->more_results()) {
             break;
         }
         //$this->connection->next_result();
     } while ($this->connection->next_result());
     $duration = microtime(true) - $start;
     $this->addQueryLog($sSQL, $duration);
     if (!$result) {
         //var_dump (debug_backtrace ());
         //$data = debug_backtrace ();
         //print_r ($data);
         //echo $sSQL;
         $ex = new DbException('MySQL Error: ' . $this->connection->error);
         $ex->setQuery($sSQL);
         throw $ex;
     } elseif ($result instanceof MySQLi_Result) {
         return new Result($result);
     }
     // Insert ID will return zero if this query was not insert or update.
     $this->insert_id = intval($this->connection->insert_id);
     // Affected rows
     $this->affected_rows = intval($this->connection->affected_rows);
     if ($this->insert_id > 0) {
         return $this->insert_id;
     }
     if ($this->affected_rows > 0) {
         return $this->affected_rows;
     }
     return $result;
 }

 protected function cleanConnection()
 {
     while ($this->dbcon->more_results()) {
         $this->dbcon->next_result();
         $res = $this->dbcon->use_result();
         if ($res instanceof mysqli_result) {
             $res->free();
         }
     }
 }

 protected function _multiQuery($query)
 {
     $this->connect();
     $this->_driver->multi_query($query);
     if ($this->_driver->error) {
         throw new Miaox_SphinxQl_Connection_Exception('[' . $this->_driver->errno . '] ' . $this->_driver->error . ' [ ' . $query . ']');
     }
     $result = array();
     $count = 0;
     do {
         if (false !== ($resource = $this->_driver->store_result())) {
             $result[$count] = array();
             while (!is_null($row = $resource->fetch_assoc())) {
                 $result[$count][] = $row;
             }
             $resource->free_result();
         }
         $count++;
     } while ($this->_driver->more_results() && $this->_driver->next_result());
     return $result;
 }

 /**
  * Runs a query and returns a result object
  *  
  * @param string $query
  * @return Application_Model_Queryresult
  */
 public function query($query)
 {
     // If there is no query we can't really do anything
     if (!$query) {
         $this->error = 'No query was requested.';
         return false;
     }
     // If there is no connection handle, get one
     if (!$this->_dbh) {
         $this->_getDbh();
     }
     $return = false;
     // Check again to make sure we are good
     if ($this->_dbh) {
         // Start stacking
         Application_Model_Queryprofiler::setQuery($query);
         // Start the timer
         $start = microtime(true);
         // Handle processing of the result data setting
         //$rs = $this->_dbh->query($query);
         $result = new Application_Model_Queryresult();
         if ($this->_dbh->multi_query($query)) {
             do {
                 if (($rs = $this->_dbh->use_result()) !== false) {
                     $result->setResult($rs);
                     $rs->free();
                 } else {
                     if ($this->_dbh->errno) {
                         // there was an error
                         $this->error .= ' ' . $this->_dbh->error;
                     }
                 }
             } while ($this->_dbh->more_results() && $this->_dbh->next_result());
         } else {
             if (($rs = $this->_dbh->query($query)) !== false) {
                 $result->setResult($rs);
                 $rs->free();
             } else {
                 if ($this->_dbh->errno) {
                     $this->error = $this->_dbh->error;
                 }
             }
         }
         // Stop the time
         $stop = microtime(true);
         // Handle errors
         //if ($this->_dbh->error) {
         //	$this->error = $this->_dbh->error;
         //}
         // Handle timer
         $totaltime = $stop - $start;
         Application_Model_Queryprofiler::setQueryTime($totaltime);
         Application_Model_Queryprofiler::setQueryError($this->error);
         // Set the result sets, record sets and statistics
         $result->setResultStats();
         //$return = $rs;
         $return = $result;
     } else {
         $this->error = 'There is no database connector.';
     }
     return $return;
 }