php How to combine 2 json data and echo a result order by date?

Question

{"query":
{"data":{
"item":[{"title":"some word1",
"date":"Sat, 26 Feb 2011 21:02:01"},
{"title":"some word2",
"date":"Sat, 26 Feb 2011 17:02:01"}]
}}}


{"query":
{"text":{
"body":[{"title":"some word3",
"time":"Sat, 26 Feb 2011 20:22:21"},
{"title":"some word4",
"time":"Sat, 26 Feb 2011 19:11:59"}]
}}}

There have 2 json data, how to combine them and echo a result which is order by date? I need a result like:

some word1 Sat, 26 Feb 2011 21:02:01
some word3 Sat, 26 Feb 2011 20:22:21
some word4 Sat, 26 Feb 2011 19:11:59
some word2 Sat, 26 Feb 2011 17:02:01

Thanks

amitchd · Accepted Answer · 2011-02-27 10:06:34Z

2

Use json_decode to decode the json string into an array and then sort the array using any sorting algorithm.

answered Feb 27, 2011 at 10:06

amitchd

9755 silver badges8 bronze badges

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

2 Comments

nico Over a year ago

Don't forget you should use array_merge to merge the 2 arrays!

cj333 Over a year ago

do you have a demo or tutorial like this? Thanks.

Nick Weaver · Accepted Answer · 2011-02-27 10:59:23Z

0

You will have to do some work to combine them. To get a sort result like you provided you need to combine the "item" array of the second json string with the array "body" of the first one. To compare the dates be aware that the fields of the two json string have two different name: "time" and "date", this has to be taken care of in your sort function.

The structures a bit better reabable:

{
   "query":{
      "data":{
         "item":[
            {
               "title":"some word1",
               "date":"Sat, 26 Feb 2011 21:02:01"
            },
            {
               "title":"some word2",
               "date":"Sat, 26 Feb 2011 17:02:01"
            }
         ]
      }
   }
}


{
   "query":{
      "text":{
         "body":[
            {
               "title":"some word3",
               "time":"Sat, 26 Feb 2011 20:22:21"
            },
            {
               "title":"some word4",
               "time":"Sat, 26 Feb 2011 19:11:59"
            }
         ]
      }
   }
}

edited Feb 27, 2011 at 10:59

answered Feb 27, 2011 at 10:54

Nick Weaver

47.3k12 gold badges100 silver badges108 bronze badges

2 Comments

nico Over a year ago

PHP has a json_decode function that will do all the work for you.

Nick Weaver Over a year ago

Of course, but it does not magically do the sorting which the OP requested.

Oliver O'Neill · Accepted Answer · 2011-02-27 16:39:39Z

Something like this?

<?php
$data = array();

// Parse the json into a clean array
$json = json_decode('{"query": 
    {"data":
    { "item":[{"title":"some word1", "date":"Sat, 26 Feb 2011 21:02:01"},
    {"title":"some word2", "date":"Sat, 26 Feb 2011 17:02:01"}] }}} ');

foreach($json->query->data->item as $body){
    $data[strtotime($body->date)][] = $body->title;
}

$json = json_decode(' {"query": 
{"text":
{ "body":[
{"title":"some word3", "time":"Sat, 26 Feb 2011 20:22:21"}, 
{"title":"some word4", "time":"Sat, 26 Feb 2011 19:11:59"}] }}}');

foreach($json->query->text->body as $body){
    $data[strtotime($body->time)][] = $body->title;
}

// Sort the timestamps
ksort($data,SORT_NUMERIC);

// Display the data any way you want
foreach($data as $timestamp => $titles){
    foreach($titles as $title){
        echo $title, ' ', date('r',$timestamp), PHP_EOL;
    }
}

Collectives™ on Stack Overflow

php How to combine 2 json data and echo a result order by date?

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related