(PHP 5, PHP 7) Returns the next field in the result set object mysqli_result::fetch_field ( void ) Object oriented style Procedural style object mysqli_fetch_field ( mysqli_result $result ) Returns the definition of one column of a result set as an object. Call this function repeatedly to retrieve information about all columns in the result set. Parameters: result Procedu

(PHP 5, PHP 7) Get a result row as an enumerated array mixed mysqli_result::fetch_row ( void ) Object oriented style Procedural style mixed mysqli_fetch_row ( mysqli_result $result ) Fetches one row of data from the result set and returns it as an enumerated array, where each column is stored in an array offset starting from 0 (zero). Each subsequent call to this function will return the next row within the result set, or N

(PHP 5, PHP 7) Returns an array of objects representing the fields in a result set array mysqli_result::fetch_fields ( void ) Object oriented style Procedural style array mysqli_fetch_fields ( mysqli_result $result ) This function serves an identical purpose to the mysqli_fetch_field() function with the single difference that, instead of returning one object at a time for each field, the columns are returned as an array of

(PHP 5 >= 5.3.0, PHP 7) Fetches all result rows as an associative array, a numeric array, or both mixed mysqli_result::fetch_all ([ int $resulttype = MYSQLI_NUM ] ) Object oriented style Procedural style mixed mysqli_fetch_all ( mysqli_result $result [, int $resulttype = MYSQLI_NUM ] ) mysqli_fetch_all() fetches all result rows and returns the result set as an associative array, a numeric array, or both.

(PHP 5, PHP 7) Fetch a result row as an associative array array mysqli_result::fetch_assoc ( void ) Object oriented style Procedural style array mysqli_fetch_assoc ( mysqli_result $result ) Returns an associative array that corresponds to the fetched row or NULL if there are no more rows. Note: Field names returned by this function are case-sensitive. Note: This function sets NULL fields to the PHP NULL value.

(PHP 5, PHP 7) Fetch a result row as an associative, a numeric array, or both mixed mysqli_result::fetch_array ([ int $resulttype = MYSQLI_BOTH ] ) Object oriented style Procedural style mixed mysqli_fetch_array ( mysqli_result $result [, int $resulttype = MYSQLI_BOTH ] ) Returns an array that corresponds to the fetched row or NULL if there are no more rows for the resultset represented by the result parameter. mysqli_fe

(PHP 5, PHP 7) Fetch meta-data for a single field object mysqli_result::fetch_field_direct ( int $fieldnr ) Object oriented style Procedural style object mysqli_fetch_field_direct ( mysqli_result $result , int $fieldnr ) Returns an object which contains field definition information from the specified result set. Parameters: result Procedural style only: A result set ident

(PHP 5, PHP 7) Adjusts the result pointer to an arbitrary row in the result bool mysqli_result::data_seek ( int $offset ) Object oriented style Procedural style bool mysqli_data_seek ( mysqli_result $result , int $offset ) The mysqli_data_seek() function seeks to an arbitrary result pointer specified by the offset in the result set. Parameters: result Procedural style onl

(PHP 5, PHP 7) Returns SQLSTATE error from previous statement operation string mysqli_stmt_sqlstate ( mysqli_stmt $stmt ) Object oriented style string $mysqli_stmt->sqlstate; Procedural style Returns a string containing the SQLSTATE error code for the most recently invoked prepared statement function that can succeed or fail. The error code consists of five characters. '00000' means no error. The values are specified by

(PHP 5, PHP 7) Get current field offset of a result pointer int mysqli_field_tell ( mysqli_result $result ) Object oriented style int $mysqli_result->current_field ; Procedural style Returns the position of the field cursor used for the last mysqli_fetch_field() call. This value can be used as an argument to mysqli_field_seek(). Parameters: result Procedural style only