php array looping through two arrays with different indexes

Question

I have two arrays,one containing a list of names (array name = canNAMES),

["name 1","name 2","name 3"];

the first array has around 70 values within, And my second array has around 600 objects within it (array name=data),

[
{
    "agency": "test agency",
    "work_end": "21-Oct",
    "contractor": "name n",
    "rate": "Â£30.00",
    "hours": 32,
    "exp": null,
    "net": "Â£960.00",
    "vat": "Â£192.00",
    "gross": "Â£1,152.00"
},
{
    "agency": "test agency",
    "work_end": "21-Oct",
    "contractor": "name n",
    "rate": "Â£25.00",
    "hours": 30,
    "exp": null,
    "net": "Â£750.00",
    "vat": "Â£150.00",
    "gross": "Â£900.00"
}
]

I am trying to use php in_array function to get the objects that has the names listed in the first array out.

when I use it as below I am able to get the required results but it only reads up-to 70 records

foreach ($canNAMES as $index => $row) {
    if (in_array($row, (array) $data[$index]["contractor"])) {
        $MAIN[] = $data[$index];
    }
}

The above code is where i loop through the first array(canNAMES array) that has 70 records. when i try looping through the second array(data array) i get an undefined offset error as the first array doesn't have a index above 69.

My question is how to solve this issue, is there a better way to do what i am trying.

Thanks

Have you tried foreaching the $data array and check $canNAMES? — Lithilion
– Lithilion, Commented Nov 7, 2018 at 8:19

Nigel Ren · Accepted Answer · 2018-11-07 08:28:12Z

1

If the names aren't unique then you can easily just loop through each sets of data matching one against the other...

$canNAMES = ["name 1","name 2","name 3"];

$data = json_decode ('[
{
    "agency": "test agency",
    "work_end": "21-Oct",
    "contractor": "name 3",
    "rate": "Â£30.00",
    "hours": 32,
    "exp": null,
    "net": "Â£960.00",
    "vat": "Â£192.00",
    "gross": "Â£1,152.00"
},
{
    "agency": "test agency",
    "work_end": "21-Oct",
    "contractor": "name 1",
    "rate": "Â£25.00",
    "hours": 30,
    "exp": null,
    "net": "Â£750.00",
    "vat": "Â£150.00",
    "gross": "Â£900.00"
}
]');

foreach ( $canNAMES as $name )  {
    foreach ( $data as $entry ) {
        if ( $name == $entry->contractor )    {
            print_r($entry);
        }
    }
}

edited Nov 7, 2018 at 8:28

answered Nov 7, 2018 at 8:24

Nigel Ren

57.2k11 gold badges49 silver badges59 bronze badges

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

1 Comment

dWinder Over a year ago

I think use` in_array` is better readability (as in my post) - but it all the same as this one...

dWinder · Accepted Answer · 2018-11-07 08:33:21Z

1

I guess you want all the element in the data array that have a name that exist in the canNAMES array.

Consider the following:

$canNAMES = ["ccc","bbb","eee"];
$data = json_decode('[{"id":1, "contractor": "aaa"}, {"id":2, "contractor": "ddd"}, {"id":3, "contractor": "ccc"}, {"id":4, "contractor": "bbb"}]');
$res = array();

foreach($data as $elem) {
    if (in_array($elem->contractor, $canNAMES))
        $res[] = $elem;
}

echo print_r($res);
return;

answered Nov 7, 2018 at 8:33

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

1 Comment

Nigel Ren Over a year ago

This is actually the better way of doing it, saves the two scans.

Collectives™ on Stack Overflow

php array looping through two arrays with different indexes

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related