How to save this json array to MYSQL database

Question

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;
                }

What exactly is the problem? json_encode or serialize should work just fine. — Peon
– Peon, Commented Feb 4, 2014 at 9:56
$json should have those square brackets around the outside - use jsoneditoronline.org to check if it is valid JSON. — Luke Wenke
– Luke Wenke, Commented Feb 4, 2014 at 9:58
And cross your fingers and hope you'll never have to query through this structured data saved as a string. Because who needs normal forms? — Alex
– Alex, Commented Feb 4, 2014 at 9:58
What is $me equal to? Also $json = '$me['sports']'; is not valid code. — Luke Wenke
– Luke Wenke, Commented Feb 5, 2014 at 0:21

Luke Wenke · Accepted Answer · 2014-02-04 10:06:12Z

7

$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);

answered Feb 4, 2014 at 10:06

Luke Wenke

1,1462 gold badges24 silver badges45 bronze badges

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

3 Comments

patrick Over a year ago

this works fine. However, I get the error that what I receive from Facebook is an array, not a string. I have edited the question.

Luke Wenke Over a year ago

You need quotes before and after the square brackets like I've said in my answer. Otherwise it isn't valid PHP though it is valid Javascript. BTW what is $me equal to?

Luke Wenke Over a year ago

Can use use var_dump with $me and copy and paste the results?

user3117825 · Accepted Answer · 2014-02-04 10:01:16Z

1

use :

 $json = serialize($json);

answered Feb 4, 2014 at 10:01

user3117825

4 Comments

patrick Over a year ago

Now this is what is returned: s:134:"{"id":"108124505876479","name":"Wakeboarding"},{"id":"112003352149145","name":"Bouldering"},{"id":"110008522357035","name":"Handball"}"; Is there a way to only save the sports?

user3117825 Over a year ago

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

patrick Over a year ago

I have edited the question. I get the error that what I receive from Facebook is an array, not a string.

patrick Over a year ago

the Facebook array containing user data from login.

nbloos · Accepted Answer · 2014-02-04 10:02:48Z

1

$json1 = '{"id":"108124505876479","name":"Wakeboarding"},{"id":"112003352149145","name":"Bouldering"},{"id":"110008522357035","name":"Handball"}';
$json2 = '[{"id":"108124505876479","name":"Wakeboarding"},{"id":"112003352149145","name":"Bouldering"},{"id":"110008522357035","name":"Handball"}]';

var_dump(json_decode($json1,true));
var_dump(json_decode($json2,true));

watch the difference

answered Feb 4, 2014 at 10:02

nbloos

293 bronze badges

Comments

Luke Wenke · Accepted Answer · 2014-02-04 09:57:22Z

0

If var_dump(json_decode($json)) returns what you'd expect just save $json directly into the database.

answered Feb 4, 2014 at 9:57

Luke Wenke

1,1462 gold badges24 silver badges45 bronze badges

2 Comments

patrick Over a year ago

I would like to save a string of all the sports.

Luke Wenke Over a year ago

there should be square brackets around it all... try copying it into jsoneditoronline.org also use var_dump(json_decode($json, true)) to convert it into associative arrays.

Mariusz Jamro · Accepted Answer · 2015-02-03 07:32:43Z

0

$string=mysql_real_escape_string($json);

edited Feb 3, 2015 at 7:32

Mariusz Jamro

31.9k25 gold badges129 silver badges170 bronze badges

answered Feb 3, 2015 at 6:27

MrPostman

33

Collectives™ on Stack Overflow

How to save this json array to MYSQL database

5 Answers 5

3 Comments

4 Comments

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

4 Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related