PHP resource::fetchArray方法代码示例

 /**
  * Load a value from cache.
  *
  * @param  string $id
  * @param  string $time
  * @return mixed
  */
 public function load($id, $time)
 {
     $value = false;
     // Determine if the value already exists.
     $rows = [];
     $this->prepare("SELECT * FROM " . $this->table . " WHERE id = :id")->bindParams(['id' => sha1($id)])->execute();
     if ($this->isPdo) {
         while (($row = $this->result->fetchAll(\PDO::FETCH_ASSOC)) != false) {
             $rows[] = $row;
         }
     } else {
         while (($row = $this->result->fetchArray(SQLITE3_ASSOC)) != false) {
             $rows[] = $row;
         }
     }
     // If the value is found, check expiration and return.
     if (count($rows) > 0) {
         $data = $rows[0]['value'];
         $timestamp = $rows[0]['time'];
         if ($timestamp == 0 || time() - $timestamp <= $time) {
             $value = unserialize($data);
         }
     }
     return $value;
 }

 /**
  * Get the number of rows in the result set
  *
  * @return int
  */
 public function count()
 {
     switch ($this->mode) {
         case "mysql":
             $rows = $this->result->num_rows;
             break;
         case "postgres":
         case "redshift":
             $rows = pg_num_rows($this->result);
             break;
         case "odbc":
             $rows = odbc_num_rows($this->result);
             # The above function is unreliable, so if we got a zero count then double check it
             if ($rows < 1) {
                 $rows = 0;
                 /**
                  * If it is an update/delete then we just have to trust the odbc_num_rows() result,
                  * however it is some kind of select, then we can manually count the rows returned.
                  */
                 if (odbc_num_fields($this->result) > 0) {
                     $position = $this->position;
                     $this->seek(0);
                     while ($this->getNextRow()) {
                         ++$rows;
                     }
                     $this->seek($position);
                 }
             }
             break;
         case "sqlite":
             $rows = 0;
             while ($this->result->fetchArray()) {
                 $rows++;
             }
             $this->seek($this->position);
             break;
         case "mssql":
             $rows = mssql_num_rows($this->result);
             break;
     }
     if ($rows === false || $rows < 0) {
         throw new \Exception("Failed to get the row count from the result set");
     }
     return $rows;
 }

 /**
  * Get the lifetime of the value.
  *
  * @param  string $id
  * @return int
  */
 public function getLifetime($id)
 {
     // Determine if the value already exists.
     $rows = [];
     $value = 0;
     $this->prepare('SELECT * FROM "' . $this->table . '" WHERE "id" = :id')->bindParams(['id' => sha1($id)])->execute();
     if ($this->isPdo) {
         while (($row = $this->result->fetchAll(\PDO::FETCH_ASSOC)) != false) {
             $rows[] = $row;
         }
     } else {
         while (($row = $this->result->fetchArray(SQLITE3_ASSOC)) != false) {
             $rows[] = $row;
         }
     }
     // If the value is found, check expiration and return.
     if (count($rows) > 0) {
         $cacheValue = $rows[0];
         $value = $cacheValue['lifetime'];
     }
     return $value;
 }

 /**
  * Fetch an array from a database result set
  *
  * @param resource $res
  * @return array
  */
 protected function _fetch($res)
 {
     return $res->fetchArray(SQLITE3_ASSOC);
 }

 /**
  * Fetches a complete result as an object
  *
  * @param resource $result Resultset
  *
  * @throws Exception
  *
  * @return array of stdClass
  */
 public function fetchAll($result)
 {
     $ret = array();
     if (false === $result) {
         throw new Exception('Error while fetching result: ' . $this->error());
     }
     $result->fetchedByPMF = true;
     while ($row = $result->fetchArray(SQLITE3_ASSOC)) {
         $ret[] = (object) $row;
     }
     return $ret;
 }

 /**
  * Copies the contents of from_table in the first database into the
  * to a to_table of suitable schema in a second database. It assumes the
  * table exists in both databases
  *
  * @param string $from_table name of the table to be copied from
  * @param resource $from_dbm database resource for the from table
  * @param resource $to_table name of the table to be copied to
  * @param resource $to_dbm database resource for the to table
  */
 static function copyTable($from_table, $from_dbm, $to_table, $to_dbm)
 {
     $sql = "SELECT * FROM {$from_table}";
     if (($result = $from_dbm->execute($sql)) === false) {
         return false;
     }
     while ($row = $from_dbm->fetchArray($result)) {
         $statement = "INSERT INTO {$to_table} VALUES (";
         $comma = "";
         foreach ($row as $col => $value) {
             $statement .= $comma . " '" . $to_dbm->escapeString($value) . "'";
             $comma = ",";
         }
         $statement .= ")";
         if ($to_dbm->execute($statement) === false) {
             return false;
         }
     }
     return true;
 }

 public function nextRecord()
 {
     // Coalesce rather than replace common fields.
     if ($data = @$this->handle->fetchArray(SQLITE3_NUM)) {
         foreach ($data as $columnIdx => $value) {
             if (preg_match('/^"([a-z0-9_]+)"\\."([a-z0-9_]+)"$/i', $this->handle->columnName($columnIdx), $matches)) {
                 $columnName = $matches[2];
             } else {
                 if (preg_match('/^"([a-z0-9_]+)"$/i', $this->handle->columnName($columnIdx), $matches)) {
                     $columnName = $matches[1];
                 } else {
                     $columnName = trim($this->handle->columnName($columnIdx), "\"' \t");
                 }
             }
             // $value || !$ouput[$columnName] means that the *last* occurring value is shown
             // !$ouput[$columnName] means that the *first* occurring value is shown
             if (isset($value) || !isset($output[$columnName])) {
                 $output[$columnName] = is_null($value) ? null : (string) $value;
             }
         }
         return $output;
     } else {
         return false;
     }
 }

 /**
  * Returns an array containing all of the result set rows
  *
  * @param integer $fetchStyle           Controls how the next row will be returned to the caller.
  *                                      This value must be one of the Doctrine_Core::FETCH_* constants,
  *                                      defaulting to Doctrine_Core::FETCH_BOTH
  *
  * @param integer $columnIndex          Returns the indicated 0-indexed column when the value of $fetchStyle is
  *                                      Doctrine_Core::FETCH_COLUMN. Defaults to 0.
  *
  * @return array
  */
 public function fetchAll($fetchStyle = Doctrine_Core::FETCH_BOTH, $colnum = 0)
 {
     return $this->connection->fetchArray($this->result, $fetchStyle);
 }

 public function nextRecord()
 {
     if ($data = $this->handle->fetchArray(SQLITE3_ASSOC)) {
         return $data;
     } else {
         return false;
     }
 }