How To Perform array_search In Multi Dimensional Array?

Question

I have this code :

$order_list = array ( array ("tangible", 1, 8, 33, 19000),
                      array ("tangible", 1, 9, 8, 19000),
                      array ("tangible", 6, 3, 24, 19000),
                      array ("tangible", 6, 2, 10, NULL),
                      array ("tangible", 1, 17, 11, 28000));

$key = array_search(3, array_column($order_list, $order_list[2]));

and I want to get the value of $order_list[$i][3] based on $order_list[$i][2].

for example, if I put :

3 I will get 24 in return

9 I will get 8 in return

and so on...

I tried to use array_search :

$key = array_search(3, array_column($order_list, $order_list[2]));

but I got this error :

Warning: array_column(): The column key should be either a string or an integer in /home/***/public_html/***.php on line 8

Warning: array_search() expects parameter 2 to be array, boolean given in /home/***/public_html/***.php on line 8

how to perform array_serach in this case? thanks before.

6 is not the key to perform search, bro. 6 is actually vendor_id. and 3 and 2 are product_id. we don't do search based on vendor_id, but based on product_id. and the result is 24 or 10. which are number of pcs. — Saint Robson
– Saint Robson, Commented Feb 12, 2016 at 9:59

Chetan Ameta · Accepted Answer · 2016-02-12 10:43:20Z

1

I created a general purpose function to get next value of current value in 2'd array. have a look on below function. Also look at variable description of function to understand input in function:

/***
 * @param array $array input array
 * @param $search_value value that need to be searched
 * @param $search_index index of inner array where current value exists
 * @return next value of current value
 */
function getNextSequence(array $array, $search_value, $search_index)
{
    $result = null;
    $key = array_search($search_value, array_column($array, $search_index));
    if ($key !== false) {
        $result = (isset($array[$key][$search_index + 1])) ? $array[$key][$search_index + 1] : null;
    }

    return $result;
}

$order_list = array(
    array("tangible", 1, 8, 33, 19000),
    array("tangible", 1, 9, 8, 19000),
    array("tangible", 6, 3, 24, 19000),
    array("tangible", 6, 2, 10, NULL),
    array("tangible", 1, 17, 11, 28000)
);

var_dump(getNextSequence($order_list, 3, 2)); //output: int(24)
var_dump(getNextSequence($order_list, 9, 2)); //output: int(8)
var_dump(getNextSequence($order_list, 10, 2)); //output: Null
var_dump(getNextSequence($order_list, 2, 2)); //output: int(10)

edited Feb 12, 2016 at 10:43

answered Feb 12, 2016 at 10:04

Chetan Ameta

7,8943 gold badges34 silver badges46 bronze badges

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

3 Comments

Saint Robson Over a year ago

bro, I tried : var_dump(getNextSequence($order_list, 8, 2)); this should give me 33 as result. but why your code give me NULL?

Saint Robson Over a year ago

it seems your code skip the first row of $order_list

Chetan Ameta Over a year ago

@RobertHanson its because if($key) condition its escaping 0 as well. Corrected my answer. Please have a look

Glynne Turner · Accepted Answer · 2016-02-12 09:52:11Z

1

<?php

$search = 9;

$order_list = array ( array ("tangible", 1, 8, 33, 19000),
                  array ("tangible", 1, 9, 8, 19000),
                  array ("tangible", 6, 3, 24, 19000),
                  array ("tangible", 6, 2, 10, NULL),
                  array ("tangible", 1, 17, 11, 28000));




foreach ($order_list as $string){

    if (in_array($search,$string)){
       //repsonse here
    }
}
?>

answered Feb 12, 2016 at 9:52

Glynne Turner

1496 bronze badges

Comments

Glynne Turner · Accepted Answer · 2016-02-12 10:04:47Z

1

another way.....

$search = 9;

$order_list = array ( array ("tangible", 1, 8, 33, 19000),
                  array ("tangible", 1, 9, 8, 19000),
                  array ("tangible", 6, 3, 24, 19000),
                  array ("tangible", 6, 2, 10, NULL),
                  array ("tangible", 1, 17, 11, 28000));




foreach ($order_list as $string){
    if ($string[2] == $search){
    print_r( $string);  
    }  
}

answered Feb 12, 2016 at 10:04

Glynne Turner

1496 bronze badges

Collectives™ on Stack Overflow

How To Perform array_search In Multi Dimensional Array?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related