mysqli_result::fetch_object

(PHP 5, PHP 7) Returns the current row of a result set as an object object mysqli_result::fetch_object ([ string $class_name = "stdClass" [, array $params ]] ) Object oriented style Procedural style object mysqli_fetch_object ( mysqli_result $result [, string $class_name = "stdClass" [, array $params ]] ) The mysqli_fetch_object() will return the current row result set as an object where the attributes of the object repres

mysqli_result::fetch_fields

(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

mysqli_result::fetch_field

(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

mysqli_result::fetch_field_direct

(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

mysqli_result::fetch_assoc

(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.

mysqli_result::fetch_array

(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

mysqli_result::fetch_all

(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.

mysqli_result::data_seek

(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

mysqli_result::$current_field

(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

mysqli_stmt::store_result

(PHP 5, PHP 7) Transfers a result set from a prepared statement bool mysqli_stmt::store_result ( void ) Object oriented style Procedural style bool mysqli_stmt_store_result ( mysqli_stmt $stmt ) You must call mysqli_stmt_store_result() for every query that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN), if and only if you want to buffer the complete result set by the client, so that the subsequent mysq