Trying to get property of non-object MySQLi result

Question

Got a bit of PHP code I m struggling with - had a search around Google etc  and tried everything mentioned  but for some reason I m having trouble solving it   The problem is   I have some code that is querying a database for the presence of a particular user   The code  it s a method inside a class    lt  php global  mysqli     Query specified database for value  q    SELECT id FROM      database     WHERE username          username          r    mysqli- gt query  q   var dump  r   if   r- gt num rows           If row found username exists so return false     return false          gt    I ve var dumped the result of the query   r  and got this   object mysqli result  4  5      current field    gt  int 0    field count    gt  int 1    lengths    gt  NULL   num rows    gt  int 1    type    gt  int 0      This is correct  there should only be 1 row as above   I do get this error linking to the line saying if   r- gt num rows     Notice  Trying to get property of non-object in FILE on line LINE  but I don t know why since the object is valid  as above  and it should be working fine  From what I can tell it seems to be going through alright  I m just wondering why there s an error  I m sure it s something simple but I d appreciate any help

User · Answer

I think thats not the reason everybody told above. There is something wrong in your code, maybe miss spelling or mismatching with the database column names. If mysqli query gets no result then it will return false, so that it is not a object - is a wrong idea. Everything works fine. it returns 1 or 0 if query have result or not.

So, my suggestion is check your variable names and table column names or any other misspelling.

User · Answer

sql    SELECT   FROM table    result    conn- gt query  sql    if    result        trigger error  Invalid query       conn- gt error       check the error with mysqli error   function   probably your query has some faults

User · Answer

I have been working on to write a custom module in Drupal 7 and got the same error       Notice  Trying to get property of non-object    My code is something like this    function example node access  node   op   account      if   node- gt type     page   amp  amp   op     update         drupal set message  This poll has been published  you may not make changes to it    error        return NODE ACCESS DENY              Solution   I just added a condition if  is object  sqlResult    and everything went fine   Here is my final code    function mediaten node access  node   op   account         if  is object  node          if   node- gt type     page   amp  amp   op     update            drupal set message  This poll has been published  you may not make changes    error           return NODE ACCESS DENY

User · Answer

The cause of your problem is simple  So many people will run into the same problem  Because I did too and it took me hour to figure out  Just in case   someone else stumbles  The problem is in your query  your select statement is calling  dbname instead of table name  So its not found whereby returning false which is boolean  Good luck

User · Answer

Just thought I would expand on this a bit   If you perform a MYSQLI SELECT query that returns 0 results  it returns FALSE   However  if you get this error and you have written your own MYSQLI Query function  then you can also get this error if the query you are running is not a select but an update  An update query will return either TRUE or FALSE  So if you just assume that any non false result will have records returned  then you will trip up when you run an update or anything other than select   The easiest solution  once you have checked that its not false  is to first check that the result of the query is an object        sqlResult    connection- gt query  sql       if    sqlResult                            else if  is object  sqlResult                  sqlRowCount    sqlResult- gt num rows            else                sqlRowCount   0

[php] Trying to get property of non-object MySQLi result

Examples related to php

Examples related to mysqli