PHP PDOStatement::fetch方法代碼示例

 /**
  * Prefetch data
  */
 protected function prefetch()
 {
     if (!$this->currentFetched) {
         $this->currentData = $this->statement->fetch();
         $this->currentFetched = true;
     }
 }

 /**
  * @inheritDoc
  */
 public function next()
 {
     $this->cursorOffset++;
     // Fetching one row, located at the given offset in the result set
     // (This is what PDO::FETCH_ORI_ABS is for).
     $this->currentRow = $this->statement->fetch(\PDO::FETCH_ASSOC, \PDO::FETCH_ORI_ABS, $this->cursorOffset);
 }

 /**
  * 獲取單條數據
  * @param string $fetchStyle
  * @throws \HuiLib\Error\Exception
  * @return array|object
  */
 public function fetch()
 {
     if ($this->innerStatment == NULL) {
         throw new \HuiLib\Error\Exception('fetch必須先調用Query::query');
     }
     return $this->innerStatment->fetch($this->fetchStyle);
 }

 function getLine()
 {
     if (!$this->_result) {
         return false;
     }
     return $this->_result->fetch(PDO::FETCH_ASSOC);
 }

 protected function fetchRow()
 {
     $this->current = $this->pdoStatement->fetch();
     if ($this->current) {
         $this->current->castInts();
         $this->current->setNew(false);
     }
 }

 /**
  * Reads a piece of input data and advance to the next one.
  * Implementations must return null at the end of the input data set.
  * @return mixed
  */
 public function read()
 {
     if (!$this->ready) {
         $this->init();
     }
     $data = $this->stmnt->fetch(\PDO::FETCH_ASSOC);
     return $data ? $data : null;
 }

 /**
  * {@inheritdoc}
  */
 public function rewind()
 {
     if ($this->rewinded) {
         throw new InvalidMethodCallException('Cannot rewind a PDOStatement');
     }
     $this->current = $this->statement->fetch(\PDO::FETCH_ASSOC);
     $this->rewinded = true;
 }

 /** * @inheritDoc */
 public function next()
 {
     $this->key++;
     $this->result = $this->pdoStatement->fetch(\PDO::FETCH_OBJ, \PDO::FETCH_ORI_ABS, $this->key);
     if (false === $this->result) {
         $this->valid = false;
         return null;
     }
 }

 private function getDruaplNodeIdByWpPostId($wpPostId)
 {
     $this->getDruaplNodeIdByWpPostIdStatement->execute(array(':wp_post_id' => $wpPostId));
     $result = $this->getDruaplNodeIdByWpPostIdStatement->fetch(PDO::FETCH_ASSOC);
     if (!$result['nid']) {
         throw new Exception('No WP post ID: ' . $wpPostId);
     }
     return $result['nid'];
 }

 /**
  * @inheritDoc
  */
 public function next()
 {
     $this->key++;
     $this->result = $this->pdoStatement->fetch(PDO::FETCH_OBJ, PDO::FETCH_ORI_ABS, $this->key);
     if ($this->result === FALSE) {
         $this->valid = FALSE;
         return NULL;
     }
 }

 /**
  * <b>O parametro deve ser um array atribuitivo apenas com Id da tabela</b>
  * 
  * @param array $Dados
  * @return array
  */
 public function find(array $Dados)
 {
     $Condicao = array_keys($Dados)[0];
     $Id = "{$Condicao} = :{$Condicao}";
     $sql = "SELECT * FROM {$this->Table} WHERE {$Id}";
     $this->Stmt = Conn::prepare($sql);
     $this->Stmt->execute($Dados);
     return $this->Stmt->fetch();
 }

 /**
  * Fetch next result
  * 
  * @param boolean|string $object Fetch as object
  * @return \stdClass
  */
 public function next($object = TRUE)
 {
     if ($object) {
         if ($object === TRUE) {
             return $this->stmt->fetchObject();
         }
         return $this->stmt->fetchObject($object);
     }
     return $this->stmt->fetch(\PDO::FETCH_ASSOC);
 }

 public function fetch()
 {
     $this->executeQuery();
     $rs = $this->statement->fetch(PDO::FETCH_ASSOC);
     if ($rs === null) {
         return false;
     } else {
         return $rs;
     }
 }

 /**
  * Advances the curesor in the statement
  * Closes the cursor if the end of the statement is reached
  */
 public function next()
 {
     $this->currentRow = $this->stmt->fetch(PDO::FETCH_NUM);
     $this->currentKey++;
     $this->isValid = (bool) $this->currentRow;
     if (!$this->isValid) {
         $this->closeCursor();
         if ($this->enableInstancePoolingOnFinish) {
             Propel::enableInstancePooling();
         }
     }
 }

 public function next()
 {
     $this->current = null;
     if (($restore = $this->statement->fetch(\PDO::FETCH_ASSOC)) !== false) {
         $this->current = clone $this->storable;
         $this->current->schema()->validate($restore);
         if (isset($restore['guid'])) {
             $this->current->guid($restore['guid']);
             $this->storage->register($this->current);
         }
         $this->current->restore($restore);
     }
 }