Auto order an array based on Json key value

Question

I created this code to reference a Json array and built a list:

<?php

    $json = file_get_contents('events.json');

    $jsonArray = json_decode($json, true); // decode the JSON into an associative array

    foreach ($jsonArray as $value) {

        if (($value['active'] === 't') && ($value['fromDate'] >= $currentDate)) {

            echo '<p>'.$value['title'].' '.$value['fromDate'].' - '.$value['toDate'].'</p>';
        }
    }

    echo $currentDate;  
?>

However, I can't figure out how to organize by a value in the Json file:

[
    {

        "active": "f",
        "title": "My Third Event",
        "city": "Robert Downey Jr.",
        "ST": "Robert Downey Jr.",
        "fromDate": "01/17",
        "toDate": "01/20",
        "website": "http://google.com",
        "email": "[email protected]",
        "logo": ""
    },
    {

        "active": "t",
        "title": "My First Event",
        "city": "Robert Downey Jr.",
        "ST": "Robert Downey Jr.",
        "fromDate": "05/12",
        "toDate": "01/20",
        "website": "http://google.com",
        "email": "[email protected]",
        "logo": ""
    }
]

I want to use "fromDate" to dynamically organize each entry when loaded. Any advise? FYI - i have reviewed the PHP manual and other SO entries, but i'm new to PHP and Ive not got my head totally wrapped around the concepts just yet. Thanks!

So you want to order your array by the key toDate ?!

Rizier123
– Rizier123

2015-04-10 21:23:05 +00:00
Commented Apr 10, 2015 at 21:23 — Rizier123
– Rizier123, Commented Apr 10, 2015 at 21:23
Yes. order each entry by fromDate... not toDate.

trobbins26
– trobbins26

2015-04-10 21:35:46 +00:00
Commented Apr 10, 2015 at 21:35 — trobbins26
– trobbins26, Commented Apr 10, 2015 at 21:35

Rizier123 · Accepted Answer · 2015-04-10 21:41:54Z

1

This should work for you:

Here I just sort your array with usort() by comparing the timestamps of the "fromDate".

usort($jsonArray, function($a, $b) {
    if(strtotime($a["fromDate"]) == strtotime($b["fromDate"]))
        return 0;
    return strtotime($a["fromDate"]) > strtotime($b["fromDate"])? 1: -1;
});

answered Apr 10, 2015 at 21:41

Rizier123

59.8k17 gold badges106 silver badges167 bronze badges

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

2 Comments

trobbins26 Over a year ago

Guiness! that worked. However I may need to dynamically get the year as it will eventually change.

Rizier123 Over a year ago

@trobbins26 You're welcome! See my updated answer, forgot that strtotime() just takes the current year if you don't add one, so it should all works fine

Collectives™ on Stack Overflow

Auto order an array based on Json key value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related