CHAPTER 6 – Fetching Modes

There are three ways to fetch rows of results, as in the old mysql extension: as an enumerated array, as an associative array, or as an object (see Table 6.4). Table 6.4 mysqli Fetch Functions Function Name Description mysqli_fetch_row(...) Sends a query to the database and buffers $mysqli->fetch_row() the results. Its parameter is the result object (function only). mysqli_fetch_assoc(...) Fetches all the results from the most recent $result->fetch_assoc() query on the connection and stores them in memory. Its parameter is connection resource (function only). mysqli_fetch_object(...) Fetches a row into an object. Its parameter is $result->fetch_object() the result object (function only).