Get all mysql selected rows into an array

by

I would suggest the use of MySQLi or MySQL PDO for performance and security purposes, but to answer the question:

while($row = mysql_fetch_assoc($result)){
     $json[] = $row;
}

echo json_encode($json);

If you switched to MySQLi you could do:

$query = "SELECT * FROM table";
$result = mysqli_query($db, $query);

$json = mysqli_fetch_all ($result, MYSQLI_ASSOC);
echo json_encode($json );

More Related Contents:

  1. Sign in form always showing "Wrong Credentials"
  2. Prevent creating duplicate entries in PHP
  3. i have stored array in database as a string how can retrieve that array?
  4. Insert array into MySQL database with PHP
  5. Sum values of multidimensional array by key without loop
  6. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  7. Save PHP array to MySQL?
  8. Notice: Array to string conversion in
  9. mysql_fetch_array, mysql_fetch_assoc, mysql_fetch_object
  10. How get all values in a column using PHP?
  11. mysql select query within a serialized array
  12. PDO fetch one column from table into 1-dimensional array
  13. Select from mysql table WHERE field=’$array’?
  14. MySQL query using an array [duplicate]
  15. How to insert json array into mysql database
  16. Why do I get “Resource id #4” when I apply print_r() to an array in PHP? [duplicate]
  17. PHP/SQL Insert Error when using Named Placeholders
  18. Create PHP array from MySQL column
  19. Save array in mysql database
  20. MySQL PHP – SELECT WHERE id = array()? [duplicate]
  21. How to get count of rows in MySQL table using PHP?
  22. MySQL Prepared statements with a variable size variable list
  23. php multi-dimensional array remove duplicate [duplicate]
  24. How can I enable the MySQLi extension in PHP 7?
  25. MySQL server has gone away – in exactly 60 seconds
  26. Why is password_verify returning false?
  27. Laravel OrderBy relationship count
  28. Doctrine – How to print out the real sql, not just the prepared statement?
  29. Re-index numeric array keys [duplicate]
  30. Sort an array of associative arrays by column value

Leave a Comment