mysqli_result (class)

The mysqli_result class

Introduction

(PHP 5, PHP 7)

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

Changelog

Class synopsis

bool data_seek ( int $offset )

mixed fetch_all ([ int $resulttype = MYSQLI_NUM ] )

mixed fetch_array ([ int $resulttype = MYSQLI_BOTH ] )

array fetch_assoc ( void )

object fetch_field_direct ( int $fieldnr )

object fetch_field ( void )

array fetch_fields ( void )

object fetch_object ([ string $class_name = "stdClass" [, array $params ]] )

mixed fetch_row ( void )

bool field_seek ( int $fieldnr )

void free ( void )

Table of Contents

• 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 — Fetches all result rows as an associative array, a numeric array, or both
• mysqli_result::fetch_array — Fetch a result row as an associative, a numeric array, or both
• mysqli_result::fetch_assoc — Fetch a result row as an associative array
• 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 — Returns the current row of a result set as an object
• mysqli_result::fetch_row — Get a result row as an enumerated array
• mysqli_result::$field_count — Get the number of fields in a result
• mysqli_result::field_seek — Set result pointer to a specified field offset
• mysqli_result::free — Frees the memory associated with a result
• 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 a result