Warning mysqli num rows expects parameter 1 to be mysqli result boolean given in

Question

struggling with my web design assignment  I ve been following a tutorial to add in a search feature for my website  but I ve been getting the following error   Warning  mysqli num rows   expects parameter 1 to be mysqli result  boolean given in  search php on line 31  line 31 is  or was    lt pre gt if mysqli num rows  results   gt   1  lt  pre gt    That was the original error  as per instructions in the comments  I ve since revised the code    lt pre gt          lt  php    capture search term and remove spaces at its both ends if the is any  searchTerm   trim   GET  keyword        check whether the name parsed is empty if  searchTerm              echo  Enter the name brand of what you re looking for        exit         database connection info  host    localhost    db name    sookehhh shopsy db    username    sookehhh shopsy    password    xxxx        connecting to server and creating link to database  link   mysqli connect  host   username   password   db name  or die  Could not connect      mysqli connect error        MYSQL search statement  query    SELECT   FROM sookehhh shopsy db WHERE name LIKE       mysqli real escape string  link   searchTerm               original query query    SELECT   FROM sookehhh shopsy db WHERE name LIKE    searchTerm       results   mysqli query  link   query      added suggestion below - not sure if correct place  if    result        die mysqli error  link           check whethere there were matching records in the table by counting the number of results returned    if mysqli num rows  results   gt   1         output           while  row   mysqli fetch array  results                  output     Product Name       row  name       lt br   gt             output     Price       row  price       lt br   gt              echo  output    else     echo  There was no matching record for that item      searchTerm    gt   lt  pre gt    made necessary changes and updated yet again -   now the only error message I m getting here is  Table  sookehhh shopsy db sookehhh shopsy db  doesn t exist   I m assuming that I need to change the username  perhaps because it s too similar   Anywho  thanks for your help so far  and I apologise for my complete ignorance   I ve been trying to teach myself  but unfortunately time is a luxury I just don t have at the moment

User · Answer

The problem is your query returned false meaning there was an error in your query   After your query you could do the following   if    result        die mysqli error  link        Or you could combine it with your query    results   mysqli query  link   query  or die mysqli error  link      That will print out your error   Also    you need to sanitize your input   You can t just take user input and put that into a query  Try this    query    SELECT   FROM shopsy db WHERE name LIKE       mysqli real escape string  link   searchTerm            In reply to  Table  sookehhh shopsy db sookehhh shopsy db  doesn t exist  Are you sure the table name is sookehhh shopsy db  maybe it s really like users or something

[php] Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

Examples related to php

Examples related to mysql