Become Zend Certified

Prepare for the ZCE exam using our quizzes (web or iPad/iPhone). More info...

When you're ready get 7.5% off your exam voucher using voucher CJQNOV23 at the Zend Store

The MySQLi_Result class

Introduction

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

MySQLi_Result {

/* Properties */

int $MySQLi_Result->current_field ;

int $field_count;

array $lengths;

int $num_rows;

/* Methods */

int mysqli_field_tell ( mysqli_result $result )

bool mysqli_result::data_seek ( int $offset )

mixed mysqli_result::fetch_all ([ int $resulttype = MYSQLI_NUM ] )

mixed mysqli_result::fetch_array ([ int $resulttype = MYSQLI_BOTH ] )

object mysqli_result::fetch_field_direct ( int $fieldnr )

object mysqli_result::fetch_field ( void )

object mysqli_result::fetch_object ([ string $class_name [, array $params ]] )

mixed mysqli_result::fetch_row ( void )

int mysqli_num_fields ( mysqli_result $result )

bool mysqli_result::field_seek ( int $fieldnr )

void mysqli_result::free ( void )

array mysqli_fetch_lengths ( mysqli_result $result )

int mysqli_num_rows ( mysqli_result $result )

}

mysqli_result::current_field - Get current field offset of a result pointer
mysqli_result::data_seek - Adjusts the result pointer to an arbitary 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