Fatal error: Cannot use object of type mysqli_result as array

Question

I am trying to get the result from my database table tbl_newpage but it throws error. I don't know why it throws error

The following line

   $page = $mysqli->real_escape_string($_GET['page']);

   $result=array();

   if($stmt = $mysqli->prepare("select * from tbl_newpage where name=?")){

     $stmt->bind_param("s", $page);

     $stmt->execute();

     $result = $stmt->get_result();

     while($row = $result->fetch_array()){

       $result[] = array($row); //This is where the error appears 
                echo "hello ";print_r($row);die();

     }

     $objSmarty->assign("result", $result);
   }

Throws error

Fatal error: Cannot use object of type mysqli_result as array in /var/www/html/examplesite/phpfile.php on line 22

Change $result[] array to some other name something like $data because $result array store value of get_result() — Saty
– Saty, Commented Jul 15, 2016 at 5:16

Barmar · Accepted Answer · 2016-07-16 05:29:41Z

3

You're using the same variable $result for both the result of $stmt->get_result() and also the array of values that you're fetching. So on the second iteration of the loop, when it does

$row = $result->fetch_array()

$result no longer contains the mysqli result, it contains the array, and you can't call fetch_array() on an array. Use different variable names for them.

$output = array();
while ($row = $result->fetch_array()) {
    $output[] = $row;
}
$objSmarty->assign("result", $output);

Also, $row is already an array, you probably don't want to nest it in another array before pushing it onto the $output array.

edited Jul 16, 2016 at 5:29

answered Jul 15, 2016 at 5:21

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Niklesh Raut · Accepted Answer · 2016-07-15 05:16:39Z

3

Try by changing final result as finalResult

 $page = $mysqli->real_escape_string($_GET['page']);

 $finalResult=array();

 if($stmt = $mysqli->prepare("select * from tbl_newpage where name=?")){

 $stmt->bind_param("s", $page);

 $stmt->execute();

 $result = $stmt->get_result();

 while($row = $result->fetch_array()){

   $finalResult[] = array($row);
            echo "hello ";print_r($row);die();

 }

 $objSmarty->assign("result", $finalResult);
 }

answered Jul 15, 2016 at 5:16

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges

1 Comment

scriptkiddie Over a year ago

Thanks, that's the problem

Collectives™ on Stack Overflow

Fatal error: Cannot use object of type mysqli_result as array

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related