while loop inside an array?

Question

I'm trying to figure out if I'm able to do a while loop inside an array

while($row = $retail -> fetch(PDO::FETCH_ASSOC)){

$json['data'][] = array(

'id'=>$row['idretailers'],
"category"=>$row['category'],
"headline"=>$row['headline'],
'price'=> array ("full_price" => $row['price']),
'description'=>$row['description'],
"comments" => array(
while($row_c = $comments -> fetch(PDO::FETCH_ASSOC)){

 // more items  
})
);
}

There's a while loop within the comments, is that possible?

Thanks!

simply try it, see that you'll get a syntax error and try a different approach. Short: no it's not possible. — Yoshi
– Yoshi, Commented Jun 20, 2012 at 14:17
@deceze it came from my own sense of understanding :-D, i didn't know about that great scientist before, thx for sharing his name and thx to wiki , cheers — Khurram
– Khurram, Commented Jun 20, 2012 at 14:35
@JohnConde I did try it. I ment to ask which approach should I take to accomplish something similar. — hellomello
– hellomello, Commented Jun 20, 2012 at 17:10

jeroen · Accepted Answer · 2012-06-20 14:20:52Z

2

The way you write it is not possible, but there is a simple solution:

"comments" => $comments -> fetchAll(PDO::FETCH_ASSOC)

answered Jun 20, 2012 at 14:20

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

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

Comments

Mike Mackintosh · Accepted Answer · 2012-06-20 14:49:24Z

1

Since you are inserting it into a JSON String, do it like this:

while($row = $retail -> fetch(PDO::FETCH_ASSOC)){

    $json['data'][] = array(

        "id"=>$row['idretailers'],
        "category"=>$row['category'],
        "headline"=>$row['headline'],
        "price"=> array ("full_price" => $row['price']),
        "description"=>$row['description'],
        "comments" => $comments->fetchAll()
    );
}

Otherwise, you could call implode on the comments:

while($row = $retail -> fetch(PDO::FETCH_ASSOC)){

    $json['data'][] = array(

        "id"=>$row['idretailers'],
        "category"=>$row['category'],
        "headline"=>$row['headline'],
        "price"=> array ("full_price" => $row['price']),
        "description"=>$row['description'],
        "comments" => implode("\n", $comments->fetchAll());
    );
}

answered Jun 20, 2012 at 14:49

Mike Mackintosh

14.3k7 gold badges64 silver badges87 bronze badges

1 Comment

hellomello Over a year ago

+1 and answer for full script of example, and other method approach

Collectives™ on Stack Overflow

while loop inside an array?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related