使用php动态搜索jsonarray多个值

Question

i have a json array

[  
  {  
     "id":1.25,
     "name":"rose",
     "Number":15,
     "SSN":[  
         12345,
         3455
     ]
  },

  {  
     "id":1.15,
     "name":"orchid",
     "Number":7,
     "SSN":[  
        12345,
        3455
     ]
  }
]

i want to get the id value if user searched with any ssn or name or by number.the input for search may not be single value that means it may be combination of ssn and name or it may be name,ssn and number .Any combination of name number ,ssn may be inputs .i have to get id value if the inputs matches using php .i used xpath for xml but i want to search fron json.can someone suggest me with any idea..thank you...

Answer 1

To search user ID by analyzing JSON string use the following approach with array_filter and array_intersect_assoc functions:

$json_str = '[ { "id":1.25, "name":"rose", "Number":15, "SSN":[ 12345, 3455 ] }, { "id":1.15, "name":"orchid", "Number":7, "SSN":[ 12345, 3455 ] }]';
$decoded = json_decode($json_str, true);

// base search structure
$search_structure = ['name' => "", 'Number' => 0];

// let's say, the following inputs have come from API (some of them may be empty or omitted)
$number = 7;
$ssn = "3455";

if ($number && is_numeric($number)) $search_structure['Number'] = $number;
$search_structure = array_filter($search_structure); // filtering out empty params
$count_params = count($search_structure);
$user_id = 0;

foreach ($decoded as $item) {
    if ($count_params == count(array_intersect_assoc($search_structure, $item))) {
        if (!$ssn || ($ssn && in_array($ssn, $item['SSN']))) {
            $user_id = $item['id'];
            break;
        }
    }
}

print_r(($user_id)? "User id: $user_id" : "User with specified params not found!");

The output:

User id: 1.15