Parse JSON with PHP within a Loop

Question

How do I parse this JSON with PHP?

[{"index":0,"date":" 20120029","title":"testtitle"}

There are multiple instances of this. for example:

[{"index":0,"date":" 20120029","title":"testtitle"},{"index":1,"date":" 20120007","title":"testtitle"},{"index":2,"date":" 20120006","title":"testtitle"}]

When I try an online parser i get this.

[
{
"index":0,
"date":" 20120029",
"title":"testtitle"
},
{
"index":1,
"date":" 20120007",
"title":"testtitle"
},
{
 "index":2,
 "date":" 20120006",
 "title":"testtitle"
}
]

What i need to know is how would i extract the data and get a variable for $index, $date, $title??

I need this within a foreach. So for every event echo it out?

Any help would be great.

Thanks

bitoshi.n · Accepted Answer · 2012-05-14 11:46:49Z

1

Try

$data = '[{"index":0,"date":" 20120029","title":"testtitle"},{"index":1,"date":" 20120007","title":"testtitle"},{"index":2,"date":" 20120006","title":"testtitle"}]';

$json = json_decode($data);
foreach($json as $v)
{
    echo $v->index;
    echo $v->date;
    echo $v->title;
}

answered May 14, 2012 at 11:46

bitoshi.n

2,3381 gold badge16 silver badges16 bronze badges

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

Comments

Sirko · Accepted Answer · 2012-05-14 11:53:32Z

1

In PHP you can use json_decode to convert the data back into an array/object (PHP docu). For the actual traversal I would prefer a usual for loop here.

$data = json_decode( '[{"index":0,"date":" 20120029","title":"testtitle"},{"index":1,"date":" 20120007","title":"testtitle"},{"index":2,"date":" 20120006","title":"testtitle"}]', true );

for( $i=0; $i<count($data); $i++ ) {
  echo $data[ $i ][ 'index' ];
  echo $data[ $i ][ 'date' ];
  echo $data[ $i ][ 'title' ];
}

But if you want to use a foreach loop:

foreach( $data as $item ) {
  echo $item[ 'index' ];
  echo $item[ 'date' ];
  echo $item[ 'title' ];
}

edited May 14, 2012 at 11:53

answered May 14, 2012 at 11:45

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

1 Comment

Ja͢ck Over a year ago

You forgot to pass the $assoc parameter to json_decode ... either that or you should use -> :)

Ja͢ck · Accepted Answer · 2012-05-14 11:46:19Z

0

You use json_decode() for that.

foreach (json_decode($str, true) as $item) {
    echo $item['title'], "\n";
}

answered May 14, 2012 at 11:46

Ja͢ck

174k39 gold badges269 silver badges316 bronze badges

Comments

Borislav Sabev · Accepted Answer · 2012-05-14 11:47:02Z

0

Why don't you try josn_decode()?

$myNewArrayMadeFromJSON = json_decode($jsonString);

for () {
 // A loop over $myNewArrayMadeFromJSON
}

answered May 14, 2012 at 11:47

Borislav Sabev

4,8781 gold badge27 silver badges30 bronze badges

Collectives™ on Stack Overflow

Parse JSON with PHP within a Loop

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related