how do i store android json array in php databse?

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":"(785) 583-7086","name":"Website 22-2-16"},
      {"phone":"(904) 136-2961","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

decode to convert in array and loop through it and store. you should have searched a bit. — Suchit kumar
– Suchit kumar, Commented Mar 4, 2017 at 12:08

Rajdeep Paul · Accepted Answer · 2017-03-04 12:09:25Z

1

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

$a='[{"phone":"(785) 583-7086","name":"Website 22-2-16"}, {"phone":"(904) 136-2961","name":"Abhi"}]';

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

answered Mar 4, 2017 at 12:09

Rajdeep Paul

16.9k3 gold badges21 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

how do i store android json array in php databse?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related