Call to a member function fetch assoc on boolean in path

Question

I m getting the above error when running the below code to display bookings made from a database   lt  php                   servername    quot localhost quot            username    quot           quot            password    quot          quot            dbname    quot thelibr1 fyp quot                Create connection          conn   new mysqli  servername   username   password   dbname              Check connection         if   conn- gt connect error                die  quot Connection failed   quot     conn- gt connect error                                sql    quot SELECT id  tablename  numseats  person FROM confirms quot            result    conn- gt query  sql             gt                                    lt table id  quot Confirms quot  border   quot 2 quot  style  quot length 900px width 350px  quot  gt                 lt thead gt                   lt tr style   quot background-color   A4A4A4  quot  gt                     lt td gt Booking ID  lt  td gt                     lt td gt Table No   lt  td gt                     lt td gt No  of Seats  lt  td gt                     lt td gt Person  lt  td gt                   lt  tr gt                 lt  thead gt               lt tbody gt                   lt  php                   while   row    result- gt fetch assoc        null                       echo                      quot  lt tr gt                         lt td gt   row  id    lt  td gt                         lt td gt   row  tablename    lt  td gt                         lt td gt   row  numseats    lt  td gt                         lt td gt   row  person    lt  td gt                       lt  tr gt  n quot                                         gt               lt  tbody gt           lt  table gt   I only started to receive the error when i started hosting it live  It works fine on my personal computer  the databse connection works fine also

User · Answer

Please use if condition with while loop and try.

eg.

if ($result = $conn->query($query)) {

    /* fetch associative array */
    while ($row = $result->fetch_assoc()) {

    }
    /* free result set */
    $result->free();
}

User · Answer

OK  i just fixed this error   This happens when there is an error in query or table doesn t exist   Try debugging the query buy running it directly on phpmyadmin to confirm the validity of the mysql Query

User · Answer

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- gt query  sql  or die  conn- gt 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- gt fetch assoc        null     with just   while  row    result- gt fetch assoc        You could also add this for debugging   echo  number of rows       result- gt num rows

User · Answer

You have to update the php ini config file with in your host provider s server  trust me on this  more than likely there is nothing wrong with your code  It took me almost a month and a half to realize that most hosting servers are not up to date on php ini files  eg  php 5 5 or later  I believe

User · Answer

This error happen usually when tables in the query doesn t exist  Just check the table s spelling in the query  and it will work

[php] Call to a member function fetch_assoc() on boolean in <path>

Examples related to php

Examples related to mysqli