How I fix this problem Call to a member function fetchAll() on boolean?

Question

I want to select all data for posts table according to department I tried to use this code but I got this error Call to a member function fetchAll() on boolean this is my code

    <?php
              if(isset($_GET['dept_n']))
              { 
                $de_id = $_GET['dept_n'];

              $sql = 'SELECT * FROM [posts WHERE dept_id = $de_id';
             $result = $connection->query($sql);

              $rows = $result->fetch_all();
              foreach($rows as $row)
              {
                $id = $row[0];
         echo"   <img src='./images/$row[3].jpg' style='width: 90%; height: 200px; '> 
            <h4 >$row[1]</h4>
}}?>

Welcome to stackoverflow. Can you show us what did you tryed? — Marty1452, Dec 04 '19 at 18:07
Your query failed. Most likely because of the typo here: `[posts` — aynber, Dec 04 '19 at 18:10
*"Call to a member function fetchAll()"* - That isn't in your code. You have a mysqli_ function and not PDO. — Funk Forty Niner, Dec 04 '19 at 18:10
@aynber I was going to mention the extra bracket too but you got there first :) — Funk Forty Niner, Dec 04 '19 at 18:11

score -1 · Answer 1 · answered Dec 04 '19 at 18:12

-1

First of all why you have bracket here?

 $sql = 'SELECT * FROM [posts WHERE dept_id = $de_id';

You dont have to use foreach. Use while loop:

while ($row = $result->fetch_assoc()){
     echo $row[“name of column”];
}

answered Dec 04 '19 at 18:12

Marty1452

430
5
19

And you missing quotes after echo in your code. – Marty1452 Dec 04 '19 at 18:15
I tried to use as you said but still the same problem – Lamees Mohammed Dec 04 '19 at 18:28

How I fix this problem Call to a member function fetchAll() on boolean?

1 Answers1