Laravel 5:Call to a member function fetch_assoc() on a non-object

Question

<?php $results = DB::select('select * from insurance_policy where Id = ?', [1]);

                                           $row = $results->fetch_assoc();
                                            echo $row["Amount"];
                                  ?>

Here is my code it is giving me a error:Call to a member function fetch_assoc() on a non-object. I am using Laravel 5

how should i fix the error – Gooseblogspot.com Mar 23 '15 at 01:13 — Gooseblogspot.com, Mar 23 '15 at 01:13

score 0 · Answer 1 · edited Dec 05 '15 at 01:57

0

DB::select would return an Array which stores the DB rows. You can iterate the results

foreach ($results as $row) { echo $row['Amount']; }

edited Dec 05 '15 at 01:57

Josh Crozier

233,099
56
391
304

answered Mar 23 '15 at 01:17

limen

67
7

Thank you for replying now this error comes. #Call to a member function toArray() on a non-object – Gooseblogspot.com Mar 23 '15 at 01:23
It seems that the previous answer is not correct. I changed it. :) – limen Mar 23 '15 at 01:29
Hi sorry for being a pain no w have got this error:#Cannot use object of type stdClass as array – Gooseblogspot.com Mar 23 '15 at 01:41

Laravel 5:Call to a member function fetch_assoc() on a non-object

1 Answers1