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 */
    public readonly int $current_field;
    public readonly int $field_count;
    public readonly ?array $lengths;
    public readonly int|string $num_rows;
    public int $type;
    /* Methods */
    public __construct(mysqli $mysql, int $result_mode = MYSQLI_STORE_RESULT)
    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): true
    public free(): void
    public close(): void
    public free_result(): void
    public getIterator(): Iterator
    }

    Properties

    type

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

    Changelog

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

    Table of Contents

    Improve This Page

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes

    There are no user contributed notes for this page.
    To Top