Accessing All Selected MySQL Rows in an Array

When querying data from a MySQL database, you may desire to store all the returned rows conveniently in an array. This provides you with the flexibility to manipulate and access the data more efficiently.

To achieve this, you can leverage the mysql_fetch_array() function, which retrieves a single row as an associative array. However, this method only fetches the first row by default. To access all the rows, you can utilize a while loop:

This loop will iterate through all the rows in the result set and append each row as an item in the $array. Finally, the array is converted to JSON format and echoed back to the browser.

For improved performance and enhanced security, it's recommended to use the MySQLi or MySQL PDO extensions instead of the deprecated mysql_* functions. If you switch to MySQLi, you can use the following code:

The mysqli_fetch_all() function will fetch all the rows in the result set as an array of associative arrays, which is then encoded into JSON and displayed.