Search array by value in key and get another key's value

Question

here is my array:

[0] => Array
  (
      [messages] => Array
          (
              [0] => Array
                  (
                      [message] => This is for sandwich
                  )
              [1] => Array
                  (
                      [message] => This message is for burger
                  )

          )
      [price] => Array
          (
              [amount] => 5
              [currency] => USD
          )

[1] => Array
  (
      [messages] => Array
          (
              [0] => Array
                  (
                      [message] => This is a message for a delicious hotdog
                  )

          )
      [price] => Array
          (
              [amount] => 3
              [currency] => USD
          )
  )

i want to search in ALL arrays and I want to search for the word "burger". I want to get the price and amount of "burger" which is 5. If I search for the word "hotdog", it will return the price amount 3. How can i do that? thanks

Use a similar solution, replace the exact value match with a pregmatch or strpos stackoverflow.com/questions/8102221/… — Gayan Hewa
– Gayan Hewa, Commented May 27, 2017 at 3:37
@JohnJaoill I think every question has its own importance and value, but here you should make a try first then post for help with the code you have tried. — Sahil Gulati
– Sahil Gulati, Commented May 27, 2017 at 3:44
@JohnJaoill the accepted answer in the above comment , $product[$field] === $value this step needs to change strpos('burger', $product[$field]) > 0 — Gayan Hewa
– Gayan Hewa, Commented May 27, 2017 at 3:44

Edward · Accepted Answer · 2017-05-27 04:10:33Z

2

You can use a foreach loop and then use strpos or stripos.

foreach ($array as $row) {
    foreach ($row['messages'] as $row2) {
        if(strpos($row2['message'], 'burger') !== false) {
            $stringFound = true;
        } else {
            $stringFound = false;
        }
    }
    if($stringFound === true) {
        $price = $row['price']['amount'];
    } else {
        $price = '0';
    }
}
echo $price;

answered May 27, 2017 at 4:10

Edward

2,3792 gold badges22 silver badges33 bronze badges

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

Comments

Adharsh M · Accepted Answer · 2017-05-27 04:08:50Z

2

If $array be your array. I Think It may Work.

<?php
    $check = 'hotdog';

    foreach($array as $products){
        foreach($products['messages'] as $messages){
         if (strpos($messages['message'], $check) !== false) {
            echo $check.' Found. Price'. $products['price']['amount'] .'</br>' ;
         }
        }
    }
?>

answered May 27, 2017 at 4:08

Adharsh M

2,7903 gold badges23 silver badges35 bronze badges

Comments

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

Here we are using array_column, implode and preg_match.

1. array_column for retrieving specific column of an array

2. implode joins a array with a glue to make it string.

3. preg_match here for matching specific word in the given string.

Try this code snippet here

$toSearch="hotdog";

foreach($array as $key => $value)
{
    if(preg_match("/\b$toSearch\b/",implode(",",array_column($value["messages"],"message"))))
    {
        echo $value["price"]["amount"];
    }
}

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered May 27, 2017 at 4:11

Sahil Gulati

15.2k4 gold badges28 silver badges43 bronze badges

Comments

mickmackusa · Accepted Answer · 2022-07-26 10:04:48Z

Because you are searching for the first qualifying price only, it is best practice to use a conditional break to short circuit the loops. There is no reason to do more cycles if you have found a qualifying entry.
Instantiate the $amount variable with a null value before the loop to properly distinguish between a successful search and an unsuccessful one.
str_contain() is the modern function to case-sensitively search for a substring (PHP7.4 and higher). If you need case-insensitivity, you will need to use stripos($message['message'], $needle) !== false. If you need to match whole words, you will need to call preg_match("/\b$needle\b/i", $message['message']). If using regex and the $needle is coming from user input, you will need to apply escaping beforehand with $needle = preg_quote($needle, '/');.

Code: (Demo)

$needle = 'burger';

$amount = null;
foreach ($haystack as ['messages' => $messages, 'price' => $price]) {
    foreach ($messages as $message) {
        if (str_contains($message['message'], $needle)) {
            $amount = $price['amount'];
            break;
        }
    }
}
var_export($amount);
// 5

Collectives™ on Stack Overflow

Search array by value in key and get another key's value

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related