How to use array_search for searching values from multiple values in an array

Question

I have array $DATA as below

{
    "LSP": "EXB",
    "AWB": "8421604",
    "SCANS": [
        {
            "SCAN_TIME": "2019-07-17 20:05:00",
            "SCAN_STATUS": "Uploaded",
            "SCAN_CODE": "001",
            "SCAN_LOCATION": "DLH"
        },
        {
            "SCAN_TIME": "2019-07-18 15:52:00",
            "SCAN_STATUS": "Picked Up",
            "SCAN_CODE": "0011",
            "SCAN_LOCATION": "DLH"
        },
        {
            "SCAN_TIME": "2019-07-19 00:22:00",
            "SCAN_STATUS": "Scanned",
            "SCAN_CODE": "003",
            "SCAN_LOCATION": "GAX"
        }

    ]
}

$CODES = array("0011","003");

Now I want to search the SCAN_CODE values in $CODES from $DATA

So using array_search the same returns an error. My current code to get KEY is

$SEARCH_KEY = array_search($CODES,array_column($DATA,"SCAN_CODE"));

$SEARCH_KEY returns

false

My requirement is to get the first INDEX VALUE even if there are multiple INDEXES with same VALUE for SCAN_CODE and I guess array_search returns only the first instance.

if you take a close look, SCANS contains array of objects and to use the array_search function you need to convert it to array first — BlackXero
– BlackXero, Commented Aug 20, 2019 at 12:06
$DATA is not possible to use array_column on. Use it on $DATA['SCANS'] adn it should work. And please post a working json. — Andreas
– Andreas, Commented Aug 20, 2019 at 12:08
@Andreas Notice: Undefined index: SCANS Warning: array_column() expects parameter 1 to be array Warning: array_search() expects parameter 2 to be array — Alpha
– Alpha, Commented Aug 20, 2019 at 12:10
yes that is because your json is invalid. post the real json — Andreas
– Andreas, Commented Aug 20, 2019 at 12:11
@Andreas also, array_search("003",array_column($DATA,"SCAN_CODE")); is working perfectly as it is string that is being searched. But it is not working with $CODES in place of "003" — Alpha
– Alpha, Commented Aug 20, 2019 at 12:12

Nick · Accepted Answer · 2019-08-20 12:33:07Z

1

Assuming that your $DATA is actually the JSON source, and that you've edited some of it out and left a dangling comma, then this code will find you the lowest index at which one of the values in $CODES appears. Note that you have to search for values individually, as array_search will otherwise look for the array as a value to match.

$DATA = json_decode($json, true);
$CODES = array("0011","003");
$SEARCH_KEY = count($DATA['SCANS']);
foreach ($CODES as $CODE) {
    $SEARCH_KEY = min($SEARCH_KEY, array_search($CODE,array_column($DATA['SCANS'],"SCAN_CODE")));
}
echo $SEARCH_KEY;

Output (for your data):

Demo on 3v4l.org

If you want to find the scan with the earliest SCAN_TIME which matches one of the codes, you can sort the SCANS and then get an index into the sorted array e.g.

$DATA = json_decode($json, true);
$CODES = array("0011","003");
$SEARCH_KEY = count($DATA['SCANS']);
$SCANS = $DATA['SCANS'];
array_multisort(array_column($SCANS, 'SCAN_TIME'), $SCANS);
print_r($SCANS);
foreach ($CODES as $CODE) {
    $SEARCH_KEY = min($SEARCH_KEY, array_search($CODE,array_column($SCANS,"SCAN_CODE")));
}
print_r($SCANS[$SEARCH_KEY]);

Output (for my changed data in this demo):

Array
(
    [SCAN_TIME] => 2019-07-19 00:22:00
    [SCAN_STATUS] => Scanned
    [SCAN_CODE] => 003
    [SCAN_LOCATION] => GAX
)

edited Aug 20, 2019 at 12:33

answered Aug 20, 2019 at 12:14

Nick

147k23 gold badges67 silver badges106 bronze badges

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

3 Comments

Alpha Over a year ago

Will it not work without foreach ? Also, there is high possibility that there will be multiple instances under SCANS So I need to find the first instance of my array_search() based on SCAN_TIME in ascending order with the values from $DATA['SCANS'].

Nick Over a year ago

@Alpha no, see my comment to your question. If the values in SCANS are in time order, this code will find the first one.

Nick Over a year ago

@Alpha see my edit. If the scans are not in time order, the new code will give you the value with the earliest times that matches a value in the $CODES array.

ascsoftw · Accepted Answer · 2019-08-20 12:24:10Z

1

array_search expects the parameter to be searched as string. You are passing an array. You need to loop through $CODES and search for each code.

foreach( $CODES as $code ) {
    $SEARCH_KEY = array_search( $code , array_column($DATA['SCANS'],"SCAN_CODE"));
    if( $SEARCH_KEY !== false ) { //If we have find the Key, break from the loop.
        break;
    }
}

Here is the working demo

edited Aug 20, 2019 at 12:24

answered Aug 20, 2019 at 12:15

ascsoftw

3,4842 gold badges17 silver badges23 bronze badges

2 Comments

Alpha Over a year ago

I think this will return the last value, I want the first instance of any of the values from $CODES from $DATA['SCANS'] based on SCAN_TIME in ascending order

ascsoftw Over a year ago

@Alpha Updated the answer to return first key. Previously it was getting all keys.

Babbal Ahsan · Accepted Answer · 2019-08-20 12:32:45Z

<?php 
$someJSON = '{
	        "LSP": "EXB",
            "AWB": "8421604",
			"SCANS": [{"SCAN_TIME": "2019-07-17 20:05:00",
			"SCAN_STATUS": "Uploaded",
			"SCAN_CODE": "001",
			"SCAN_LOCATION": "DLH"
			},{
            "SCAN_TIME": "2019-07-18 15:52:00",
            "SCAN_STATUS": "Picked Up",
            "SCAN_CODE": "0011",
            "SCAN_LOCATION": "DLH"
        },
        {
            "SCAN_TIME": "2019-07-19 00:22:00",
            "SCAN_STATUS": "Scanned",
            "SCAN_CODE": "003",
            "SCAN_LOCATION": "GAX"
        }

    ]
}';

 $someArray = json_decode($someJSON, true);
 $CODES = array("0011","003");
 $matched=array();
foreach($someArray['SCANS'] as $item)
{
   
	if (in_array($item['SCAN_CODE'], $CODES))
    {
	   
	   array_push($matched,$item['SCAN_CODE']);
	  
    }
}
echo"<pre>";
print_r($matched);
exit;

?>

Collectives™ on Stack Overflow

How to use array_search for searching values from multiple values in an array

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related