mysqli fetch assoc expects parameter 1 to be mysqli result boolean given

Question

I am pretty new to PHP and MySQL and I just can t figure this one out  I have searched all around the forum but haven t found an answer I can make sense of  I originally was using mysql fetch assoc   but I could only search numbers and I received errors when searching for letters as well  I hope I am on the right track here  Thank you in advance for all your help    con   mysqli connect  hostname  username  password  or die    lt script language  javascript  gt alert  Unable to connect to database   lt  script gt     mysqli select db  con   dbname    if  isset   GET  part           partid     GET  part         sql    SELECT            FROM  usertable          WHERE PartNumber    partid         result   mysqli query  con   sql        row   mysqli fetch assoc  result         partnumber    partid       nsn    row  NSN         description    row  Description         quantity    row  Quantity         condition    row  Conditio

User · Answer

mysqli fetch assoc   expects parameter 1 to be mysqli result  boolean given   This means that the first parameter you passed is a boolean  true or false    The first parameter is  result  and it is false because there is a syntax error in the query         WHERE PartNumber    partid      You should never directly include a request variable in a SQL query  else the users are able to inject SQL in your queries   See SQL injection    You should escape the variable         WHERE PartNumber        mysqli escape string  conn  partid           Or better  use Prepared Statements

User · Answer

What happens in your code if  usertable is not a valid table or doesn t include a column PartNumber or part is not a number   You must escape  partid and also read the document for mysql fetch assoc   because it can return a boolean

User · Answer

Mysqli makes use of object oriented programming  Try using this approach instead   function dbCon             if  mysqli   new mysqli   hostname    username    password    databasename    return  mysqli  else return false     if  dbCon    exit   lt script language  javascript  gt alert  Unable to connect to database   lt  script gt     else  con dbCon     if  isset   GET  part           partid     GET  part         sql    SELECT            FROM  usertable          WHERE PartNumber    partid         result  con- gt query  sql query        row    result- gt fetch assoc          partnumber    partid       nsn    row  NSN         description    row  Description         quantity    row  Quantity         condition    row  Conditio        Let me know if you have any questions  I could not test this code so you might need to tripple check it

User · Answer

This happens when your result is not a result  but a  false  instead   You should change this line   sql    SELECT   FROM  usertable WHERE PartNumber    partid     to this    sql    SELECT   FROM  usertable WHERE PartNumber    partid     because the   can interprete  variables while   cannot   Works fine with integers  numbers   for strings you need to put the  variable in single quotes  like   sql    SELECT   FROM  usertable WHERE PartNumber     partid       If you want   have to work with single quotes  then php CAN NOT interprete the variables  you will have to do it like this     sql    SELECT   FROM    usertable   WHERE string column       string    AND integer column      number

User · Answer

You are single quoting your SQL statement which is making the variables text instead of variables    sql    SELECT        FROM  usertable      WHERE PartNumber    partid

[php] mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given

Examples related to php

Examples related to search

Examples related to mysqli