PHP/MongoDB - sort by time

Question

I have the following MongoDB object:

{
   "_id": ObjectId("50954f0d13f88da4a590e5ff"),
   "uname": "Eamorr",
   "1": {
     "table": "1",
     "color": "red",
     "time": NumberInt(1351963491),
     "niceTime": "2012-11-03T17: 24: 51+00: 00"
  },
   "3": {
     "table": "3",
     "color": "green",
     "time": NumberInt(1351963567),
     "niceTime": "2012-11-03T17: 26: 07+00: 00"
  },
   "4": {
     "table": "4",
     "color": "orange",
     "time": NumberInt(1351963506),
     "niceTime": "2012-11-03T17: 25: 06+00: 00"
  }
}

How do I sort this object by 'time'?

I want table 3 to be first, table 4 to be second and table 1 to be last in the list.

I'm really stuck... Please help!

Update: I should add, that my server returns the following JSON object:

[{
    "table": "4",
    "color": "orange",
    "time": 1351965770,
    "niceTime": "2012-11-03T18:02:50+00:00"
}, {
    "table": "3",
    "color": "red",
    "time": 1351964379,
    "niceTime": "2012-11-03T17:39:39+00:00"
}, {
    "table": "1",
    "color": "red",
    "time": 1351964997,
    "niceTime": "2012-11-03T17:49:57+00:00"
}]

Is it easier to sort this?

Many thanks,

user956584 · Accepted Answer · 2012-11-03 17:39:12Z

2

$coll->find($range, $co)->sort(array('time' => -1) );

answered Nov 3, 2012 at 17:39

user956584

5,5875 gold badges44 silver badges51 bronze badges

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

2 Comments

GBD Over a year ago

this will not sort embedded array inside object

user956584 Over a year ago

ach, so redesign table: data = [] , then sort data.time

Eamorr · Accepted Answer · 2012-11-03 18:06:54Z

1

Got it...

Using the second JSON (above), I did:

function my_sort($a, $b){
    if ($a['time'] > $b['time']) {
        return -1;
    } else if ($a['time'] < $b['time']) {
        return 1;
    } else {
        return 0;
    }
}

usort($obj,'my_sort');
echo json_encode($obj);

answered Nov 3, 2012 at 18:06

Eamorr

10.1k35 gold badges131 silver badges210 bronze badges

1 Comment

user956584 Over a year ago

When sorting small data is OK, when grow try caching + PHP V8 we-love-php.blogspot.com/2012/07/…

Collectives™ on Stack Overflow

PHP/MongoDB - sort by time

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related