PHP Get values from array using a specific value

Question

I need to get values from a multidimensional array using a specific value in PHP.

For example, given this array I would like to extract data based on index [1] equal to 'MUFA-D' then use the other values found in [3],[4] which would be '141' and 'Purity FM Synthetic'

Array
(
    [0] => Array
        (
            [0] => CHI
            [1] => MUFA-D
            [2] => 1
            [3] => 141
            [4] => Purity FM Synthetic
            [5] => 5
            [6] => Lubricants
        )

    [1] => Array
        (
            [0] => CHI
            [1] => BRD1-IS
            [2] => 1
            [3] => 146
            [4] => Food Grade Silicon
            [5] => 3
            [6] => Lubricants
        )

    [2] => Array
        (
            [0] => CHI
            [1] => BRD1-MC
            [2] => 1
            [3] => 145
            [4] => SAE 140 Oil
            [5] => 1
            [6] => Lubricants
        )


    [3] => Array
        (
            [0] => CHI
            [1] => JBC-BAK-B
            [2] => 1
            [3] => 141
            [4] => Purity FM Synthetic
            [5] => 5
            [6] => Lubricants
        )

)

Similar to one of my previous posts but a just need to target only a specific value and retrieve values from that data set — bbrindza, Jun 13 '22 at 17:10
My thought would be to get the array data based on a a value and reference the values So if "MUFA-D" is found in [1][1] I could get the data I need in [1][3] , [1][4]. — bbrindza, Jun 13 '22 at 17:14
Not completely sure how to do that Riggs. I tried a few examples of a loop but could not get it to work. Was hope there was a built-in PHP function that may available — bbrindza, Jun 13 '22 at 17:18
In any journey you have to summon up your courage and take the first step — RiggsFolly, Jun 13 '22 at 17:20
Could there be more than one occurance in the array that matches MUFA-D? — RiggsFolly, Jun 13 '22 at 17:20

RiggsFolly · Accepted Answer · 2022-06-14T14:51:36.803

A simple loop over the array, checking for the first occurance that matches and then returning the values will suffice for this

$in = [
    ['CHICAGO', 'MUFA-D', 1, 141, 'Purity FM Synthetic', 5, 'Lubricants'],
    ['CHICAGO', 'BRD1-IS', 1, 146, 'Food Grade Silicon', 3, 'Lubricants'],
    ['CHICAGO', 'BRD1-MC', 1, 145, 'SAE 140 Oil', 1, 'Lubricants'],
    ['CHICAGO', 'JBC-BAK-B', 1, 141, 'Purity FM Synthetic', 5, 'Lubricants']
];

function getStuff($in, $lookIn, $forValue, array $gets)
{
    foreach ($in as $arr){
        if ( $arr[$lookIn] == $forValue) {
            $res = [];
            foreach ($gets as $get){
                $res[] = $arr[$get];
            }
            return $res;
        }
    }
}

$result = [];
$result[] = getStuff($in, 1, 'MUFA-D', [3,4]);
print_r($result);

RESULT

Array
(
    [0] => Array
        (
            [0] => 141
            [1] => Purity FM Synthetic
        )

)

To return multiple finds, just move the positioning of the return

$in = [ 
    ['CHICAGO', 'MUFA-D', 1, 141, 'Purity FM Synthetic', 5, 'Lubricants'], 
    ['CHICAGO', 'MUFA-D', 1, 141, 'Test Part', 3, 'Oil'], 
    ['CHICAGO', 'BRD1-IS', 1, 146, 'Food Grade Silicon', 3, 'Lubricants'], 
    ['CHICAGO', 'BRD1-MC', 1, 145, 'SAE 140 Oil', 1, 'Lubricants'], 
    ['CHICAGO', 'JBC-BAK-B', 1, 141, 'Purity FM Synthetic', 5, 'Lubricants'] 
    ];

function getStuff($in, $lookIn, $forValue, array $gets)
{
    $res = [];
    foreach ($in as $arr){
        if ( $arr[$lookIn] == $forValue) {

            foreach ($gets as $get){
                $res[] = $arr[$get];
            }
        }
    }
    return $res;
}

$result = [];
$result = getStuff($in, 1, 'MUFA-D', [3,4]);
print_r($result);

RESULT

Array
(
    [0] => 141
    [1] => Purity FM Synthetic
    [2] => 141
    [3] => Test Part
)

Or this would make a more usable result array

function getStuff($in, $lookIn, $forValue, array $gets)
{
    $res = [];
    foreach ($in as $arr){
        if ( $arr[$lookIn] == $forValue) {
            $t = [];
            foreach ($gets as $get){
                $t[] = $arr[$get];
            }
            $res[] = $t;
        }
    }
    return $res;
}

$result = [];
$result = getStuff($in, 1, 'MUFA-D', [3,4]);
print_r($result);

RESULT

Array
(
    [0] => Array
        (
            [0] => 141
            [1] => Purity FM Synthetic
        )
    [1] => Array
        (
            [0] => 141
            [1] => Test Part
        )
)

I might use `array_intersect_key()` instead of an inner loop -- only as a style preference. — mickmackusa, Jun 20 '22 at 10:53

PHP Get values from array using a specific value

1 Answers1