MySQLi Tutorial MySQLi References

The mysqli_result class



The mysqli_result class represents the result set obtained from a query against the database.

Class synopsis

class mysqli_result implements Traversable {
  //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
}

❮ MySQLi Functions Reference