过滤具有相似字符的多维数组

Question

I have a json file and I need to look for similar values in both columns. For the JSON, It has 5,000 rows so I don't think looping to each is the right way. My json looks like this:

{
   "code": "8485",
   "title": "A BAD DREAM",
   "artist": "KEANE"
 },
 {
   "code": "50957",
   "title": "A BIG HUNK O' LOVE",
   "artist": "ELVIS PRESLEY"
 },
 {
   "code": "55481",
   "title": "A BLUE GUITAR",
   "artist": "TANYA TUCKER"
 },

For example, I will look for things that has the letter 'B', it should look those that contain a letter 'B' for both the title and artist.

So what I did was converting the JSON to a multidimensional array. And I can't make the array_filter work with a multidimensional array.

Answer 1

This is how you can use array_filter

And you can use strpos to check if string contains a string.

Note: This will check if title OR artist (either one) has the search word or letter. If you are looking for both, see Syscall's answer. :)

$arr = '[
{
   "code": "8485",
   "title": "A BAD DREAM",
   "artist": "KEANE"
 },
 {
   "code": "50957",
   "title": "A BIG HUNK O\' LOVE",
   "artist": "ELVIS PRESLEY"
 },
 {
   "code": "55481",
   "title": "A BLUE GUITAR",
   "artist": "TANYA TUCKER"
 }
 ]
';

$arr = json_decode( $arr, true );

$search = "O"; /* Search letter O */

$result = array_filter( $arr, function( $v ) use ( $search ) {
    return strpos($v[ "title" ], $search) !== false || strpos($v[ "artist" ], $search) !== false;
});

echo "<pre>";
print_r( $result );
echo "</pre>";

This will result to:

Array
(
    [1] => Array
        (
            [code] => 50957
            [title] => A BIG HUNK O' LOVE
            [artist] => ELVIS PRESLEY
        )

)

For more info: http://php.net/manual/en/function.array-filter.php