Search for unique row in a multidimensional array using an associative array containing two elements

Question

I'm trying to get the values from the second array which match the associative elements from the first array.

$array1 can only possibly match one row (at most) with the qualifying sr_no and batch_id values because the combination of these two columns will always provide uniqueness. In other words, when a match is found, there will be no chance of making another match in the remaining data.

$array1 = ['sr_no' => 72, 'batch_id' => 1];

$array2 = [ 
    ['quantity' => 22, 'sr_no' => 71, 'batch_id' => 2, 'inq_id' => 91],
    ['quantity' => 35, 'sr_no' => 72, 'batch_id' => 1, 'inq_id' => 92],
    ['quantity' => 20, 'sr_no' => 69, 'batch_id' => 3, 'inq_id' => 90],  
];

Expected Output:

['quantity' => 35, 'sr_no' => 72, 'batch_id' => 1, 'inq_id' => 92]

I tried with $result = array_diff_assoc($array2, $array1);, but it's printing the entire $array2 array values.

@mickmackusa Only one match will be there in the $array2 with the sr_no and batch_id combination — Hello
– Hello, Commented Mar 28, 2021 at 6:36

mickmackusa · Accepted Answer · 2021-03-28 07:31:20Z

2

You should stop iterating as soon as a match is found.

If your $array1 is designed to be flexible, use array_intersect_assoc() to return the matching elements, then check that all required matches are found.

Code: (Demo)

$array1 = ['sr_no' => 72, 'batch_id' => 1];

$array2 =
[ 
    ['quantity' => 22, 'sr_no' => 71, 'batch_id' => 2, 'inq_id' => 91],
    ['quantity' => 35, 'sr_no' => 72, 'batch_id' => 1, 'inq_id' => 92],
    ['quantity' => 20, 'sr_no' => 69, 'batch_id' => 3, 'inq_id' => 90],  
];

$result = null;
foreach ($array2 as $row) {
    if (array_intersect_assoc($array1, $row) === $array1) {
        $result = $row;
        break;
    }
}
var_export($result);

Output:

array (
  'quantity' => 35,
  'sr_no' => 72,
  'batch_id' => 1,
  'inq_id' => 92,
)

edited Mar 28, 2021 at 7:31

answered Mar 28, 2021 at 7:15

mickmackusa♦

49.3k13 gold badges98 silver badges165 bronze badges

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

Collectives™ on Stack Overflow

Search for unique row in a multidimensional array using an associative array containing two elements

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related