PHP Handbuch
Zurück |  | Weiter

# mysqli_store_result

(PHP 5)

mysqli_store_result

(no version information, might be only in CVS)

mysqli->store_result() -- Transfers a result set from the last query

## Beschreibung

Procedural style:

mysqli_result mysqli_store_result ( mysqli link )

Object oriented style (method):

class mysqli {
mysqli_result store_result ( void )
}

Transfers the result set from the last query on the database connection represented by the `link` parameter to be used with the mysqli_data_seek() function.

## Parameter Liste

`link`

  Procedural style only: A link identifier returned by mysqli_connect() or mysqli_init()

## Rückgabewerte

Returns a buffered result object or `FALSE` if an error occurred.

> Anmerkung: mysqli_store_result() returns `FALSE` in case the query didn't return a result set (if the query was, for example an INSERT statement). This function also returns `FALSE` if the reading of the result set failed. You can check if you have got an error by checking if mysqli_error() doesn't return an empty string, if mysqli_errno() returns a non zero value, or if mysqli_field_count() returns a non zero value. Also possible reason for this function returning `FALSE` after successfull call to mysqli_query() can be too large result set (memory for it cannot be allocated). If mysqli_field_count() returns a non-zero value, the statement should have produced a non-empty result set.

## Anmerkungen

> Anmerkung: Although it is always good practice to free the memory used by the result of a query using the mysqli_free_result() function, when transfering large result sets using the mysqli_store_result() this becomes particularly important.

## Beispiele

See mysqli_multi_query().

## Siehe auch

mysqli_real_query()
mysqli_use_result()

Zurück | Zum Anfang | Weiter
mysqli_stmt_store_result | Nach oben | mysqli_thread_id