PHP MySQL mysqli num rows expects parameter 1 to be mysqli result boolean given

Question

I m trying to Integrate HTML Purifier http   htmlpurifier org  to filter my user submitted data but I get the following error below  And I was wondering how can I fix this problem   I get the following error   on line 22  mysqli num rows   expects parameter 1 to be mysqli result  boolean given    line 22 is    if  mysqli num rows  dbc     0      Here is the php code   if  isset   POST  submitted          Handle the form       require once        htmlpurifier library HTMLPurifier auto php         config   HTMLPurifier Config  createDefault         config- gt set  Core Encoding    UTF-8       replace with your encoding      config- gt set  HTML Doctype    XHTML 1 0 Strict       replace with your doctype      purifier   new HTMLPurifier  config          mysqli   mysqli connect  localhost    root        sitename         dbc   mysqli query  mysqli  SELECT users    profile                                    FROM users                                   INNER JOIN contact info ON contact info user id   users user id                                   WHERE users user id 3          about me   mysqli real escape string  mysqli   purifier- gt purify   POST  about me           interests   mysqli real escape string  mysqli   purifier- gt purify   POST  interests         if  mysqli num rows  dbc     0             mysqli   mysqli connect  localhost    root        sitename             dbc   mysqli query  mysqli  INSERT INTO profile  user id  about me  interests                                        VALUES    user id     about me     interests           if   dbc    TRUE             dbc   mysqli query  mysqli  UPDATE profile                                       SET about me     about me   interests     interests                                        WHERE user id     user id              echo   lt p class  changes-saved  gt Your changes have been saved  lt  p gt        if    dbc               There was an error   do something about it here            print mysqli error  mysqli           return

User · Answer

The query either returned no rows or is erroneus, thus FALSE is returned. Change it to

if (!$dbc || mysqli_num_rows($dbc) == 0)

mysqli_num_rows:

Return Values

Returns TRUE on success or FALSE on failure. For SELECT, SHOW, DESCRIBE or EXPLAIN mysqli_query() will return a result object.

User · Answer

dbc is returning false   Your query has an error in it   SELECT users    profile   --You do not join with profile anywhere                                   FROM users                                   INNER JOIN contact info                                   ON contact info user id   users user id                                   WHERE users user id 3      The fix for this in general has been described by Raveren

[php] PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given

Examples related to php

Examples related to mysql