PHP - Advanced search value in multidimensional array

Question

I'm making a PHP page that can display the BackupJobs of the last week. I get all of the backup-jobs from an API that puts it into a JSON format.

I'm stuck on the point where I have a BackupSetID and want to echo all BackupJobs that matches with the BackupSetID onto a page.

Array:

{

    "Status": "OK",
    "Data": [
        {
            "BackupJob": [
                "2019-07-30-16-00-00",
                "2019-07-30-17-00-00",
                "2019-07-30-18-00-00",
                "2019-07-30-21-00-00",
                "2019-07-30-23-00-00",
                "2019-07-31-08-00-00",
                "2019-07-31-09-00-00",
                "2019-07-31-10-00-00",
                "2019-07-31-11-00-00",
                "2019-07-31-12-00-00",
                "2019-07-31-13-00-00",
                "2019-07-31-14-00-00",
                "2019-07-31-15-00-00",
                "2019-07-31-16-00-00",
                "2019-07-31-17-00-00",
                "2019-07-31-18-00-00",
                "2019-07-31-21-00-00",
                "2019-07-31-23-00-00",
                "2019-08-01-08-00-00",
                "2019-08-01-09-00-00"
            ],
            "BackupSetID": "1369227132163",
            "Removed": false
        },
        {
            "BackupJob": [
                "2019-07-22-18-00-00",
                "2019-07-22-22-00-00",
                "2019-07-23-10-00-00",
                "2019-07-23-14-00-00",
                "2019-07-23-18-00-00",
                "2019-07-23-22-00-00",
                "2019-07-24-10-00-00",
                "2019-07-24-14-00-00",
                "2019-07-24-18-00-00",
                "2019-07-24-22-00-00",
                "2019-07-25-10-00-00",
                "2019-07-25-14-00-00",
                "2019-07-25-18-00-00",
                "2019-07-25-22-00-00",
                "2019-07-26-10-00-00",
                "2019-07-26-14-00-00",
                "2019-07-26-18-00-00",
                "2019-07-26-22-00-00",
                "2019-07-27-10-00-00",
                "2019-07-27-14-00-00",
                "2019-07-27-18-00-00",
                "2019-07-27-22-00-00",
                "2019-07-28-10-00-00",
                "2019-07-28-14-00-00",
                "2019-07-28-18-00-00",
                "2019-07-28-22-00-00",
                "2019-07-29-10-00-00",
                "2019-07-29-14-00-00",
                "2019-07-29-18-00-00",
                "2019-07-29-22-00-00",
                "2019-07-30-10-00-00",
                "2019-07-30-14-00-00",
                "2019-07-30-18-00-00",
                "2019-07-30-22-00-00",
                "2019-07-31-10-00-00",
                "2019-07-31-14-00-00",
                "2019-07-31-18-00-00",
                "2019-07-31-22-00-00"
            ],
            "BackupSetID": "1369227067996",
            "Removed": false
        }
    ]

}

How would I display only the BackupJobs of the last week with (for example): BackupSetID = 1369227067996?

I tried to search between values. But without a result.

Can there be multiple matches with BackupSetID ? In other words, can there be multiple BackupSetID to match with? — mighty_dev
– mighty_dev, Commented Aug 1, 2019 at 7:19
@FeikeFalkena Ok. What does this key mean "Removed": false? Does it have any significance? — mighty_dev
– mighty_dev, Commented Aug 1, 2019 at 7:25
Did you try simple foreach loop? what is your desire output? — dWinder
– dWinder, Commented Aug 1, 2019 at 7:26

dWinder · Accepted Answer · 2019-08-01 07:55:34Z

1

You can combine the 2 condition in the same foreach loop:

$backupSetID = 1369227067996; // id to search on
$lastWeekTime = date("Y-m-d-h-i", strtotime('sunday last week'));
foreach ($arr["data"] as $e) {
    if ($e["BackupSetID"] == $backupSetID) { // check if ID match
        foreach($e["BackupJob"] as $job)
            if ($job > $lastWeekTime) echo "Found $job \n"; // check for last week
    }
}

answered Aug 1, 2019 at 7:55

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

1 Comment

Feike Falkena Over a year ago

Thank you. Why didnt I think that by myself :D Here is my code I made from it pastebin.com/JRQbzQE2

Kankatala Krishna · Accepted Answer · 2019-08-01 09:57:51Z

0

You need to convert json string to array using json_decode function.

$array = json_decode($data,true);
$backupSetID = "1369227067996";
$required_data = [];
if(count($array)){
    foreach ($array['Data'] as $index => $value) {        
        if($value["BackupSetID"] == $backupSetID){
            $required_data = $value['BackupJob'];
        }
    }
}

Required Result: print_r($required_data);

answered Aug 1, 2019 at 9:57

Kankatala Krishna

763 bronze badges

Collectives™ on Stack Overflow

PHP - Advanced search value in multidimensional array

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related