PHP mysqli_result::free方法代碼示例

 public function __destruct()
 {
     if (is_object($this->handle)) {
         $this->handle->free();
     }
     // Don't close statement as these may be re-used across the life of this request
     // if (is_object($this->statement)) $this->statement->close();
 }

 public function &free()
 {
     if ($this->m_error instanceof ZDatabaseQueryError) {
         unset($this->m_error);
     }
     $this->m_error = null;
     if ($this->m_result instanceof mysqli_result) {
         $this->m_result->free();
     }
     return $this;
 }

 /**
  * @param mysqli_result $mysqli_result
  * @param bool $single
  * @return array|bool|null
  */
 public function fetch($mysqli_result, $single)
 {
     $this->_('fields', array());
     foreach ($mysqli_result->fetch_fields() as $field) {
         $this->_('fields')[$field->name] = $this->rules[$this->types[$field->type]];
     }
     switch (true) {
         case !$mysqli_result:
             return null;
         case $single && $mysqli_result->num_rows == 0:
             $result = false;
             break;
         case $single:
             $result = $this->cast($mysqli_result->fetch_assoc());
             break;
         case $mysqli_result->num_rows == 0:
             $result = array();
             break;
         default:
             $result = array();
             while ($row = $mysqli_result->fetch_assoc()) {
                 $result[] = $this->cast($row);
             }
     }
     $mysqli_result->free();
     return $result;
 }

 /**
  * Binds this statement to the variables
  */
 protected function bind()
 {
     $variables = array();
     // Bind each field
     while ($field = $this->metadata->fetch_field()) {
         $this->columns[] = $field->name;
         // Note that while boundValues isn't initialised at this point,
         // later calls to $this->statement->fetch() Will populate
         // $this->boundValues later with the next result.
         $variables[] =& $this->boundValues[$field->name];
     }
     call_user_func_array(array($this->statement, 'bind_result'), $variables);
     $this->bound = true;
     $this->metadata->free();
     // Buffer all results
     $this->statement->store_result();
 }

 /**
  * @see \Iterator::current()
  *
  * @return mixed
  * @throws \OutOfRangeException
  */
 public function current()
 {
     // Seems overkill to define our own OutOfRangeException. Use default in this case
     if ($this->_pointer > $this->_numberOfRows - 1) {
         throw new \OutOfRangeException('Attempting to access a row that is outside of the number of rows in this result.');
     }
     $pointer = $this->_pointer;
     if (!array_key_exists($this->_pointer, $this->_mysqlResult)) {
         $this->_mysqlResult[$this->_pointer] = $this->_result->fetch_array(\MYSQLI_ASSOC);
         $this->_pointer++;
         $this->_moveToNextRow = true;
         $this->_processedRows++;
         // Free up results when there is no more row to process
         if ($this->_processedRows === $this->_numberOfRows) {
             $this->_result->free();
         }
     }
     return $this->_mysqlResult[$pointer];
 }

 /**
  * 
  * 關閉 stmt result mysqli的函數,傳入這三個東西就行
  * @param mysqli,stmt,result
  */
 static function close(mysqli $mysqli = null, mysqli_stmt $stmt = null, mysqli_result $result = null)
 {
     if ($result != null) {
         $result->free();
     }
     if ($stmt != null) {
         $stmt->close();
     }
     if ($mysqli != null) {
         $mysqli->close();
     }
 }

 /**
  * 釋放資源
  */
 public function free()
 {
     if ($this->result) {
         $this->result->free();
         $mysql = $this->mysql->connect();
         while ($mysql->more_results() && $mysql->next_result()) {
             $result = $mysql->store_result();
             if ($result) {
                 $result->free();
             }
         }
     }
 }

 /**
  * @param \mysqli_result $resource
  * @param string         $column
  *
  * @return mixed[]
  */
 protected function fetchResource($resource, $column)
 {
     $fields = $resource->fetch_fields();
     if (count($fields) == 0) {
         return [];
     }
     $result = $resource->fetch_all(MYSQLI_ASSOC);
     if (!is_array($result)) {
         return [];
     }
     $resource->free();
     $this->fixTypes($result, $fields, $column);
     return $result;
 }

 /**
  * free mysql resource
  *
  * @param \mysqli_result $res
  *
  * @throws DatabaseException|\Exception
  * @return bool
  */
 public function free($res)
 {
     $res->free();
     return true;
 }

 public function __destruct()
 {
     $this->result->free();
 }

 /**
  * 釋放所有與上次查詢結果所關聯的內存
  * @return bool
  */
 public function free()
 {
     return $this->result->free();
 }

 /**
  * @inheritdoc
  */
 public function __destruct()
 {
     if (is_object($this->result)) {
         $this->result->free();
     }
 }

 /**
  * 釋放sql查詢結果
  *
  * @param \mysqli_result $res 要釋放的結果
  * @return bool 成功返回true，失敗返回false
  */
 protected function _free($res)
 {
     return $res->free();
 }

 /**
  * Get all rows from the DB result.
  *
  * @param \mysqli_result|bool $result The return of query method.
  *
  * @return array The array of SQL rows
  */
 public function getRowsArray($result)
 {
     $rows = [];
     if (!$result) {
         return $rows;
     }
     while ($row = $result->fetch_assoc()) {
         $rows[] = $row;
     }
     $result->free();
     return $rows;
 }

 /**
  * Free the result
  */
 public function free()
 {
     if (is_object($this->resResult)) {
         $this->resResult->free();
     }
 }