Why I am getting error when getting booking from database? [duplicate]

by

The query method can return false instead of a result set in case there is an error. That is why you get the error on the fetch_assoc method call, which obviously does not exist when $result is false.

This means you have an error in your SELECT statement. To get that error displayed, do this:

 $result = $conn->query($sql) or die($conn->error);

Most probably you have a wrong spelling for the table name or a column name. Maybe when moving to the host you did not create that table correctly, and made a spelling mistake there.

You should in fact see the same error when executing the same query via phpAdmin.

Also, replace this line:

while(($row = $result->fetch_assoc()) !== null){

with just:

while($row = $result->fetch_assoc()) {

You could also add this for debugging:

echo "number of rows: " . $result->num_rows;

More Related Contents:

  1. Seperating html form from php file
  2. How would I build this JSON using a PHP array
  3. Can I try/catch a warning?
  4. Fatal error: Maximum execution time of 30 seconds exceeded
  5. How to use mysqli prepared statements?
  6. PHP MySQL Google Chart JSON – Complete Example [closed]
  7. How to change public folder to public_html in laravel 5
  8. The character encoding of the HTML document was not declared
  9. Async curl request in PHP
  10. PHP array multiple sort – by value then by key?
  11. How to limit file upload type file size in PHP?
  12. How to call a php script/function on a html button click
  13. Get week number in month from date in PHP?
  14. Using the PHP HTTP_ACCEPT_LANGUAGE server variable
  15. Redirecting to authentication dialog – “An error occurred. Please try again later”
  16. How to test if a user has SELECTED a file to upload?
  17. Output is in seconds. convert to hh:mm:ss format in php
  18. How to include External CSS and JS file in Laravel 5
  19. How to create a twig custom tag that executes a callback?
  20. ReflectionException: Class ClassName does not exist – Laravel
  21. php output with sleep()
  22. Rotate array elements to the left (move first element to last and re-index)
  23. Simple dynamic breadcrumb
  24. PHP: get number of decimal digits
  25. Concatenate values of n arrays in php
  26. Simple way to read single record from MySQL
  27. Try Catch cannot work with require_once in PHP?
  28. PHP Apple Enhanced Push Notification read error response
  29. Why doesn’t sprintf() output anything?
  30. While I am debugging PHP Script in Eclipse, it doesn’t load mysql extension

Leave a Comment