mysqli_result類

(PHP 5, PHP 7, PHP 8)

簡介

代表從一個數據庫查詢中獲取的結果集。

更新日誌

**更新日誌**
版本	說明
5.4.0	Iterator support was added, as mysqli_result now implements Traversable.

class mysqli_result {

/* 屬性 */

int $current_field;

int $field_count;

?array $lengths;

int|string $num_rows;

/* 方法 */

mysqli_field_tell(mysqli_result $result): int

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

mysqli_num_fields(mysqli_result $result): int

public field_seek(int $index): bool

public free(): void

mysqli_fetch_lengths(mysqli_result $result): array|false

mysqli_num_rows(mysqli_result $result): int|string

}

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_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 — 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