Trying to get property of non-object in

Question

on Control page    lt  php   include  pages db php       results   mysql query  SELECT   FROM sidemenu WHERE  menu id      menu    ORDER BY  id  ASC LIMIT 1    con      sidemenus   mysql fetch object  results     gt    on View Page    lt  php foreach   sidemenus as  sidemenu     gt     lt  php echo  sidemenu- gt mname   lt br   gt     gt   lt  php endforeach    gt    Error is      Notice  Trying to get property of non-object in C  wamp www phone pages init php on line 22   Can you fix it  I don t have any idea what happened

User · Answer

sidemenu is not an object  so you can t call methods on it  It is probably not being sent to your view  or  sidemenus is empty

User · Answer

Check the manual for mysql fetch object    It returns an object  not an array of objects   I m guessing you want something like this   results   mysql query  SELECT   FROM sidemenu WHERE  menu id      menu    ORDER BY  id  ASC LIMIT 1    con     sidemenus   array    while   sidemenu   mysql fetch object  results          sidemenus      sidemenu        Might I suggest you have a look at PDO  PDOStatement  fetchAll PDO  FETCH OBJ  does what you assumed mysql fetch object   to do

User · Answer

lt  php foreach   sidemenus- gt mname as  sidemenu     gt   lt  php echo  sidemenu    lt br   gt     gt    or   sidemenus   mysql fetch array  results     then   lt  php echo  sidemenu  mname     lt br   gt     gt

User · Answer

Your error  Notice  Trying to get property of non-object in C  wamp www phone pages init php on line 22  Your comment   22 is  lt  php echo  sidemenu- gt mname  quot  lt br   gt  quot    gt    sidemenu is not an object  and you are trying to access one of its properties  That is the reason for your error

[php] Trying to get property of non-object in

Examples related to php

Examples related to mysql

Examples related to object

Examples related to foreach

Examples related to fetch