php echo json in foreach loop

Question

I have product ids like this 1,2,3 in $product_ids

$product_ids = explode(',', $product_ids);
$product_ids = array_filter($product_ids);

foreach ($product_ids as $key => $product_id) {

      $sth = $this->db->prepare("SELECT * FROM products Where id =:id ");
      $sth->execute(array( ':id' => $product_id ));
      $final_data = $sth->fetchAll();

      echo json_encode($final_data);
}

how can I format json with this code in for loop echo json not working is there any other way plz help

What do you want the result to be?

deceze
– deceze ♦

2012-11-12 11:00:43 +00:00
Commented Nov 12, 2012 at 11:00 — deceze
– deceze ♦, Commented Nov 12, 2012 at 11:00
i want json format all products

SAGAR.GUDETI
– SAGAR.GUDETI

2012-11-12 11:01:51 +00:00
Commented Nov 12, 2012 at 11:01 — SAGAR.GUDETI
– SAGAR.GUDETI, Commented Nov 12, 2012 at 11:01

Mudaser Ali · Accepted Answer · 2012-11-12 11:03:21Z

4

    $product_ids = explode(',', $product_ids);
    $product_ids = array_filter($product_ids);
    $final_data = array();
    foreach ($product_ids as $key => $product_id) {

          $sth = $this->db->prepare("SELECT * FROM products Where id =:id ");
          $sth->execute(array( ':id' => $product_id ));
          $final_data[$product_id] = $sth->fetchAll();


    }
    echo json_encode($final_data);

answered Nov 12, 2012 at 11:03

Mudaser Ali

4,3593 gold badges30 silver badges32 bronze badges

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

Collectives™ on Stack Overflow

php echo json in foreach loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related