mysqli_stmt::store_result
Extending the MySQLi_Result
<?php
class Database_MySQLi extends MySQLi
{
public function query($query)
{
$this->real_query($query);
return new Database_MySQLi_Result($this);
}
}
class Database_MySQLi_Result extends MySQLi_Result
{
public function fetch()
{
return $this->fetch_assoc();
}
public function fetchAll()
{
$rows = array();
while($row = $this->fetch())
{
$rows[] = $row;
}
return $rows;
}
}
?>
The MySQLi_Result class
Introduction
Represents the result set obtained from a query against the database.
Class synopsis
MySQLi_Result
MySQLi_Result
{
/* Properties */
int $current_field
;
int $field_count;
array $lengths;
int $num_rows;
/* Methods */
}Table of Contents
- mysqli_result->current_field — Get current field offset of a result pointer
- mysqli_result::data_seek — Adjusts the result pointer to an arbitary row in the result
- mysqli_result::fetch_all — Fetches all result rows as an associative array, a numeric array, or both
- mysqli_result::fetch_array — Fetch a result row as an associative, a numeric array, or both
- mysqli_result::fetch_assoc — Fetch a result row as an associative array
- mysqli_result::fetch_field_direct — Fetch meta-data for a single field
- mysqli_result::fetch_field — Returns the next field in the result set
- mysqli_result::fetch_fields — Returns an array of objects representing the fields in a result set
- mysqli_result::fetch_object — Returns the current row of a result set as an object
- mysqli_result::fetch_row — Get a result row as an enumerated array
- mysqli_result->field_count — Get the number of fields in a result
- mysqli_result::field_seek — Set result pointer to a specified field offset
- mysqli_result::free — Frees the memory associated with a result
- mysqli_result->lengths — Returns the lengths of the columns of the current row in the result set
- mysqli_result->num_rows — Gets the number of rows in a result
add a note
User Contributed NotesMySQLi_Result
blar at blar dot de
08-Jan-2009 07:47
08-Jan-2009 07:47