按日期范围过滤此json数组创建新的json数组[关闭]

Question

I have a json array with these keys/values

{
    "results": [
        {
            "date": "2013-15-5",
            "position": "23",
            "race" : "2"
        },
        {
            "date": "2013-15-6",
            "position": "15",
            "race" : "4"
        },
        {
            "date": "2013-15-7",
            "position": "20",
            "race" : "5"
        },
        {
            "date": "2013-15-8",
            "position": "9",
            "race" : "9"
        }
    ]
}

Given I have two variables storing a $from and $to date in the same format 2013-15-5

How can I filter this json array so the output shows the range for 2013-15-6 - 2013-15-8 thanks

{
    "results": [
        {
            "date": "2013-15-6",
            "position": "15",
            "race" : "4"
        },
        {
            "date": "2013-15-7",
            "position": "20",
            "race" : "5"
        },
        {
            "date": "2013-15-8",
            "position": "9",
            "race" : "9"
        }
    ]
}

Answer 1

well convert the json to a php array, and pass it through array_filter as below

array_filter($array, function ($item) {
       $from = strtotime("2013-15-6");
       $to = strtotime("2013-15-8");

       $ts = strtotime($item['date']);
       if ($ts >= $from && $ts <= $to) return true;
       return false; 
});