PHP - return each result from fetchAll

Question

I am trying to print my result data returned from the fetchAll function. How can i bind the name and desc variable to the returned results.

 <?php
$get = $db->prepare("SELECT * FROM Products ORDER BY DateAdded DESC LIMIT 4");
$get->execute(); 
$results = $get ->fetchAll(); 

  foreach($results as $result){ ?>
              $name = $result['Name'];
              $desc= $result['Desc'];
           <h4><?php echo $name ?></h4>
           <h4><?php echo $desc?></h4>

         <?php
         }
  ?>

?> should be after $desc= $result['Desc'];. Make an effort, learn php syntax carefully. — u_mulder
– u_mulder, Commented Jan 8, 2017 at 19:31

SuperDJ · Accepted Answer · 2017-01-08 19:35:10Z

1

Try the following:

$results = $get->fetchAll(PDO::FETCH_ASSOC); 

foreach($results as $key => $value){ ?>
   echo '<h4>'.$value['name'].'</h4>
       <h4>'.$value['desc'].'</h4>';         
}

You also had a space between $get and ->fetchAll()

You might want to remove the php closing tag ?> as it might give you problems when including.

answered Jan 8, 2017 at 19:35

SuperDJ

7,69911 gold badges44 silver badges80 bronze badges

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

Comments

Elon Than · Accepted Answer · 2017-01-08 19:32:35Z

0

You don't have to fetch all results at once to do that. It's better to use fetch method for that task.

while ($row = $get->fetch(PDO::FETCH_ASSOC)) {
    echo $row['Name'];
}

And about main problem here, you are missing closing tag after $result['Desc'];

answered Jan 8, 2017 at 19:32

Elon Than

9,8154 gold badges29 silver badges37 bronze badges

Collectives™ on Stack Overflow

PHP - return each result from fetchAll

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related