mysqliresult

mysqli_result is a class in the MySQLi extension for PHP that represents the result set of a database query. When you execute a query using mysqli_query() or mysqli_stmt::execute(), and the query returns data (such as a SELECT statement), mysqli_query() or mysqli_stmt::execute() returns an object of type mysqli_result.

This object provides methods to access and process the data returned from the database. Common operations include fetching rows one by one, fetching all rows at once, or determining the number of rows in the result set. For instance, the fetch_assoc() method retrieves the current row as an associative array, where column names are keys. Similarly, fetch_row() retrieves the current row as a numerically indexed array, and fetch_array() can return either type or both. The fetch_all() method fetches all rows from the result set as an array.

The num_rows property of a mysqli_result object allows you to easily determine how many rows were returned by the query. If a query does not return data, such as an INSERT or UPDATE statement, the mysqli_query() function will return TRUE or FALSE instead of a mysqli_result object. It is important to check the return type of mysqli_query() to handle both successful data retrieval and successful non-data-returning queries appropriately. Freeing the memory associated with a mysqli_result object is typically handled automatically by PHP when the script finishes, but explicitly calling free() can be useful in long-running scripts or when dealing with very large result sets.