The mysqli_result class

(PHP 5, PHP 7, PHP 8)

Introduction

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

Class synopsis

class mysqli_result implements IteratorAggregate {
/* Properties */
int $current_field;
int $field_count;
?array $lengths;
int|string $num_rows;
/* Methods */
public data_seek(int $offset): bool
public fetch_all(int $mode = MYSQLI_NUM): array
public fetch_array(int $mode = MYSQLI_BOTH): array|null|false
public fetch_assoc(): array|null|false
public fetch_column(int $column = 0): null|int|float|string|false
public fetch_field_direct(int $index): object|false
public fetch_field(): object|false
public fetch_fields(): array
public fetch_object(string $class = "stdClass", array $constructor_args = []): object|null|false
public fetch_row(): array|null|false
public field_seek(int $index): bool
public free(): void
public close(): void
public free_result(): void
public getIterator(): Iterator
}

Changelog

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

Table of Contents