The mysqli_result class

Introduction

Represents the result set obtained from a query against the database.

mysqli_result

implements IteratorAggregate

/* Properties */

public readonly int $current_field;

public readonly int $field_count;

public readonly arraynull $lengths;

public readonly intstring $num_rows;

public int $type;

/* Methods */

public __construct(mysqli $mysql, int $result_mode = MYSQLI_STORE_RESULT)

public bool data_seek(int $offset)

public array fetch_all(int $mode = MYSQLI_NUM)

public arraynullfalse fetch_array(int $mode = MYSQLI_BOTH)

public arraynullfalse fetch_assoc()

public nullintfloatstringfalse fetch_column(int $column = 0)

public objectfalse fetch_field()

public objectfalse fetch_field_direct(int $index)

public array fetch_fields()

public objectnullfalse fetch_object(string $class = "stdClass", array $constructor_args = [])

public arraynullfalse fetch_row()

public true field_seek(int $index)

public void free()

public void close()

public void free_result()

public Iterator getIterator()

type: Stores whether the result is buffered or unbuffered as an int (MYSQLI_STORE_RESULT or MYSQLI_USE_RESULT, respectively).

Version	Description
8.0.0	mysqli_result implements IteratorAggregate now. Previously, Traversable was implemented instead.

Table of Contents

mysqli_result::__construct — Constructs a mysqli_result object
mysqli_result::$current_field — Get current field offset of a result pointer
mysqli_result::data_seek — Adjusts the result pointer to an arbitrary row in the result
mysqli_result::fetch_all — Fetch all result rows as an associative array, a numeric array, or both
mysqli_result::fetch_array — Fetch the next row of a result set as an associative, a numeric array, or both
mysqli_result::fetch_assoc — Fetch the next row of a result set as an associative array
mysqli_result::fetch_column — Fetch a single column from the next row of a result set
mysqli_result::fetch_field — Returns the next field in the result set
mysqli_result::fetch_field_direct — Fetch meta-data for a single field
mysqli_result::fetch_fields — Returns an array of objects representing the fields in a result set
mysqli_result::fetch_object — Fetch the next row of a result set as an object
mysqli_result::fetch_row — Fetch the next row of a result set as an enumerated array
mysqli_result::$field_count — Gets the number of fields in the result set
mysqli_result::field_seek — Set result pointer to a specified field offset
mysqli_result::free — Frees the memory associated with a result
mysqli_result::getIterator — Retrieve an external iterator
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 the result set