我如何在php数据库中存储android json数组？

Question

I am developing an android application to store and invite user contacts on the server.

the array I am having from android is JSON format.

$a='[
      {"phone":"[phone]","name":"Website 22-2-16"},
      {"phone":"[phone]","name":"Abhi"}
]';

I want these two attributes phone and name sent into an iteration in PHP and store in respective columns like name and phone in MySQL using PHP

Answer 1

Decode the json string using json_decode() function and loop through the decoded array using foreach loop, like this:

$a='[{"phone":"[phone]","name":"Website 22-2-16"}, {"phone":"[phone]","name":"Abhi"}]';

$decoded_json = json_decode($a, true);
foreach($decoded_json as $details){
    // phone: $details['phone']
    // name: $details['name']
    // perform your INSERT operation
}