PHP PDOStatement::nextRowset方法代碼示例

 /**
  * @return $this
  */
 public function nextRowset()
 {
     if (!parent::nextRowset()) {
         throw new Exception\RuntimeException('Rowset is not available.');
     }
     return $this;
 }

 /**
  * 
  * @throws PDOException
  */
 public function _query()
 {
     if ($this->_rowset === false) {
         if (self::$_stmt) {
             while (self::$_stmt->nextRowset()) {
                 //如果已經在結果緩存中，則搜尋結果集
                 $query = array_shift(self::$_fetchingQueue);
                 $query->_rowset = $query->_fetchAll();
                 if ($query === $this) {
                     return;
                 }
             }
             self::$_stmt = null;
         }
         //將當前的語句插到第一個，然後把所有語句一口氣打包發送給mysql
         $keys = array_keys(self::$_waitingQueue, $this);
         if (count($keys)) {
             unset(self::$_waitingQueue[$keys[0]]);
         }
         $sql = $this->_select->assemble();
         if (count(self::$_waitingQueue)) {
             $sql .= ";\n" . implode(";\n", self::$_waitingQueue);
         }
         implode(";\n", self::$_waitingQueue);
         self::$_stmt = $this->_select->getAdapter()->query($sql);
         $this->_rowset = $this->_fetchAll();
         self::$_fetchingQueue = self::$_waitingQueue;
         self::$_waitingQueue = array();
     }
 }

 /**
  * Advances the reader to the next rowset
  * Not supported by mssql
  *
  * @return boolean
  */
 public function nextRowset()
 {
     if (false !== ($result = $this->_statement->nextRowset())) {
         $this->_index = null;
     }
     return $result;
 }

	/**
	 * Move to the next row
	 */
	public function nextRowset()
	{
		if ($this->_statement !== null) {
			$this->_statement->nextRowset();
		}
		$this->_index++;
	}

 /**
  * Retrieves the next rowset (result set) for a SQL statement that has
  * multiple result sets.  An example is a stored procedure that returns
  * the results of multiple queries.
  *
  * @return bool
  * @throws Zend_Db_Statement_Exception
  */
 public function nextRowset()
 {
     try {
         return $this->_stmt->nextRowset();
     } catch (PDOException $e) {
         require_once 'Zend/Db/Statement/Exception.php';
         throw new Zend_Db_Statement_Exception($e->getMessage());
     }
 }

 public function getMoreResults()
 {
     $this->checkClosed();
     $this->stmt->nextRowset();
     $this->resultSet = null;
     $this->updateCount = -1;
     if ($this->stmt->columnCount() == 0) {
         $this->updateCount = $this->stmt->rowCount();
         return false;
     }
     return true;
 }

 /**
  * 在一個多行集語句句柄中推進到下一個行集
  * @return bool
  */
 public function nextRowset()
 {
     return $this->_PDOStatement->nextRowset();
 }

 public static function next_result(\PDOStatement $stmt)
 {
     return $stmt->nextRowset();
 }

 /**
  * @return bool
  * @throws \Compeek\PDOWrapper\NotConnectedException
  */
 public function nextRowset()
 {
     $this->requireConnection();
     return $this->pdoStatement->nextRowset();
 }

 public function nextRowset()
 {
     $this->_pdoStatement->nextRowset();
 }

 private function ManageExecutionResult(\PDOStatement $dbStatement)
 {
     $result = array();
     $isValid = true;
     foreach ($this->dbConfigList() as $dbConfig) {
         if (!$isValid) {
             break;
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::SELECT)) {
             $dbStatement->setFetchMode(\PDO::FETCH_CLASS | \PDO::FETCH_PROPS_LATE, $dbConfig->daoClassName());
             $list = $dbStatement->fetchAll();
             $result = count($list) > 0 ? $list : array();
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::UPDATE)) {
             $result = true;
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::INSERT)) {
             $result = $this->dao->lastInsertId();
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::SHOWTABLES)) {
             $result = $dbStatement->fetchAll(\PDO::FETCH_NUM);
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::COLUMNNAMES)) {
             $result = $dbStatement->fetchAll(\PDO::FETCH_COLUMN);
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::COLUMNMETAS)) {
             $result = $dbStatement->fetch(\PDO::FETCH_ASSOC);
         } elseif ($this->CheckType($dbConfig->type(), DbExecutionType::MULTIROWSET)) {
             //TODO: to implement.
             $isValid = $dbStatement->nextRowset();
         }
     }
     $dbStatement->closeCursor();
     return $result;
 }

 /**
  * @return void 
  */
 public function nextRowset()
 {
     $this->execute();
     return parent::nextRowset();
 }

 /**
  * @return bool
  */
 public function nextRowset()
 {
     $archLog = array('method' => 'PDOStatement::nextRowset', 'input' => array(), 'output' => $this->PDOStatement->nextRowset(), 'pointer' => $this->assignPointerString());
     return self::setLogReturnOutput($archLog);
 }