php json encode outputting invalid json from mysql results

Question

Possible Duplicate:
encode json using php?

$hello_world = $this->session->all_userdata();
foreach($hello_world as $key=>$product_id)
{
$query['products']  = $this->Global_products->globalFindProductsViewed($product_id);
    foreach($query['products'] as $product)
{
$ryan[] = $product->name;
}

}
foreach($ryan as $r) 
{
    echo json_encode(array($r));
}

The output then looks like this: ["Alpine 50W x 4 Apple® iPod®-Ready In-Dash CD Deck"]

I know I cant access this with JavaScript. Can someone suggest how I can make this work?

The output looks fine to me. What do you believe the problem is? — Ignacio Vazquez-Abrams, Sep 24 '11 at 15:29
No because I know that in order to access the data it has to be in a certain format. — Ryan, Sep 24 '11 at 15:32
Like this format: [{"hello":"Rand McNally Soft Case for Most 5\" GPS"},{"hello":"Rand McNally Hard Case for Most 5\" GPS"} — Ryan, Sep 24 '11 at 15:34
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/3752/discussion-between-rpm-and-ignacio-vazquez-abrams) — Ryan, Sep 24 '11 at 15:34
`js> eval('["Alpine 50W x 4 Apple® iPod®-Ready In-Dash CD Deck"]')[0]` `Alpine 50W x 4 Apple® iPod®-Ready In-Dash CD Deck` (but don't actually use `eval()` to parse your JSON) — Ignacio Vazquez-Abrams, Sep 24 '11 at 15:34

score 1 · Accepted Answer · answered Sep 24 '11 at 15:29

1

JSON encoding every array element separately doesn't make sense.

Remove the foreach, and just do a

echo json_encode($ryan);

answered Sep 24 '11 at 15:29

Pekka

442,112
142
972
1,088

php json encode outputting invalid json from mysql results

1 Answers1