How do I store all results from an SQL query in a multidimensional array? How do I store all results from an SQL query in a multidimensional array? sql sql

How do I store all results from an SQL query in a multidimensional array?


php sql 

$data = array(); // create a variable to hold the informationwhile (($row = mysql_fetch_array($result, MYSQL_ASSOC)) !== false){  $data[] = $row; // add the row in to the results (data) array}print_r($data); // print result

Update Feb '17 Now that it's 2017, it's advised you use PDOs over mysql_*. A lot safer and can return this natively with fetchAll (as shown in `TrexXx's answer).

php sql

The only way to avoid doing a loop would to use PDO (PHP Data Objects) which is a better way to access database in PHP and you could do this :

$pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');    $q = $pdo->query('select * from yourtable');$r = $q->fetchAll();    var_dump($r);

php sql

If you need to store all rows returned by the query in an array, try this:

$result = array(); while ( $row = mysql_fetch_array($result, MYSQL_ASSOC) ){    $result[] = $row}

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last