MySQLi query returns only one row

by 
 mysqli_result::fetch_array

only fetches a single row as an array, you are looking for

 mysqli_result::fetch_all

to fetch all the rows.

More info here

http://php.net/manual/en/mysqli-result.fetch-all.php

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. MySQL vs MySQLi when using PHP [closed]
  4. Fatal error: Call to undefined function mysqli_connect()
  5. PHP error: “Cannot pass parameter 2 by reference”
  6. How to get count of rows in MySQL table using PHP?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. How to bind mysqli bind_param arguments dynamically in PHP?
  9. What is the difference between PHP echo and PHP return in plain English?
  10. mysqli fetch_all() not a valid function?
  11. Dynamic select mysqli query with dynamic parameters returns error doesn’t match number of bind variables [duplicate]
  12. Headers and client library minor version mismatch
  13. MySQLi Bind Param with an array for IN [duplicate]
  14. How to check if a row exist in the database using PDO?
  15. PHP PDO and MySQLi [duplicate]
  16. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  17. mysqli query results to show all rows
  18. mysqli_real_connect(): (HY000/2002): No such file or directory
  19. mysqli + xdebug breakpoint after closing statement result in many warnings
  20. INSERT query produces “Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given”
  21. php password_verify() hash and pass won’t match
  22. How to use mysqli_query() in PHP?
  23. PHP to MySQL SSL Connections
  24. Call to undefined method mysqli_result::fetch()
  25. Which is fastest in PHP- MySQL or MySQLi?
  26. prepared parameterized query with PDO
  27. How to make mysqli connect function?
  28. Dynamically bind mysqli_stmt parameters and then bind result
  29. Check to see if an email is already in the database using prepared statements
  30. How to insert into MySQL using mysqli

Leave a Comment