How to save this json array to MYSQL database

arrays, json, mysql, php, string

Solution

$json = '[{"id":"108124505876479","name":"Wakeboarding"},{"id":"112003352149145","name":"Bouldering"},{"id":"110008522357035","name":"Handball"}]';
$data = json_decode($json, true);
$sports = array();
foreach ($data as $item) {
    $sports[] = $item['name'];
}

if you want commas separating them:

$output = implode(', ', $sports);

Problem

I want to save this json array that my fb-login returns to a database. However I don't really know how to convert that into a string using php. ``` [{"id":"108124505876479","name":"Wakeboarding"},{"id":"112003352149145","name":"Bouldering"},{"id":"110008522357035","name":"Handball"}] ``` I have tried this code below but I am even not quite sure anymore whether what the fb login return is a json array or not. ``` $json = '{"id":"108124505876479","name":"Wakeboarding"},{"id":"112003352149145","name":"Bouldering"},{"id":"110008522357035","name":"Handball"}'; var_dump(json_decode($json)); ``` How would I be able to save the different sports to my database in a string? Any help would be much appreciated. Thanks. EDIT: The upper part returns NULL. SECOND EDIT: ``` if (array_key_exists('sports', $me)){ $json = '$me['sports']'; PROBLEM IS HERE $data = json_decode($json, true); $sports = array(); foreach ($data as $item) { $sports[] = $item['name']; } $user->fb_sports = $sports; } ```

Original source