how to fetch all the row of the result in php mysql?

by

As NikiC pointed out you should not be using the mysql_ functions any longer, you can fetch the entire array in both PDO and mysqli, Here is a example to fetch all rows using the mysqli->fetch_all function, hope this helps!

//Database Connection
$sqlConn =  new mysqli($hostname, $username, $password, $database);

//Build SQL String
$sqlString = "SELECT * FROM my_table";

//Execute the query and put data into a result
$result = $sqlConn->query($sqlString);

//Copy result into a associative array
$resultArray = $result->fetch_all(MYSQLI_ASSOC);

//Copy result into a numeric array
$resultArray = $result->fetch_all(MYSQLI_NUM);

//Copy result into both a associative and numeric array
$resultArray = $result->fetch_all(MYSQLI_BOTH);

More Related Contents:

  1. nested json using php and mysql
  2. How to create this type of JSON data from PHP [closed]
  3. How to convert the json image url string into Bitmap image to display images in android application
  4. JSON encode MySQL results
  5. PHP MySQL Google Chart JSON – Complete Example [closed]
  6. The holy grail of cleaning input and output in php?
  7. org.json.JSONException: Value
  8. Send data from android to server via JSON
  9. Sending HTML Code Through JSON
  10. What is the type this string? a:1:{s:2:”en”;}
  11. How to build a JSON array from mysql database
  12. UTF-8 character encoding battles json_encode() [duplicate]
  13. How to insert json array into mysql database
  14. The ultimate emoji encoding scheme
  15. How to get the first key of many duplicated json key? [duplicate]
  16. for loop is not executed /getting error like loop is not working
  17. PHP – Change value y,n in database [closed]
  18. I can’t view the database content on a php page [closed]
  19. Undefined function mysql_connect()
  20. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  21. Issue reading HTTP request body from a JSON POST in PHP [duplicate]
  22. Maximum execution time in phpMyadmin
  23. PHP PDO – Num Rows
  24. Post and get at the same time in php
  25. How to update/edit a JSON file using PHP [closed]
  26. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  27. What is the best way to insert multiple rows in PHP PDO MYSQL?
  28. access denied for user @ ‘localhost’ to database ” [closed]
  29. How does {} affect a MySQL Query in PHP? [duplicate]
  30. Limit pagination page number

Leave a Comment