How to insert a JSON Array into Mysql? [closed]

Question

I look for examples to solve my problem but im confused. If Ii have a json array like this:

$json = '{"a":"test","b":"test2"},{"a":"test3","b":"test4"}';

//decode to get as php variable
$obj = json_decode($json);

My problem is when i try to insert the values in the database

mysql_query("INSERT INTO suspiciousactivity (ID,Notes)
VALUES ('".$obj->{'a'}."','".$obj->{'b'}."')")or die(mysql_error());

I get this error: duplicate entry for key PRIMARY

How can I insert a multiple values from my JsonArray to my database?

Seems to me like you already have a suspiciousactivity entry with ID = test — Explosion Pills
– Explosion Pills, Commented Feb 6, 2013 at 19:13
So, you're using results from suspicious activity, and insert it into your database without sanitising? Please change your code, stop using mysql_ functions. They are deprecated and no longer maintained. Your code is very insecure and vulnerable for SQL injection. — thaJeztah
– thaJeztah, Commented Feb 6, 2013 at 22:21

Ciberman · Accepted Answer · 2013-02-06 19:17:18Z

1

try to use:

$json = '{"a":"test","b":"test2"},{"a":"test3","b":"test4"}';

//decode to get as php variable
$arr = json_decode($json,true); //true to decode as a array not an object

mysql_query("INSERT INTO suspiciousactivity (ID,Notes)
VALUES ('".$arr[0]['a']."','".$arr[0]['b']."')")or die(mysql_error());
//use it as an array.

answered Feb 6, 2013 at 19:17

Ciberman

9541 gold badge11 silver badges25 bronze badges

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

3 Comments

Ciberman Over a year ago

sorry, try now. I have changed ´$obj´ for ´$arr´

user2033349 Over a year ago

i try but echo $arr[0]['a']; is empty

user2033349 Over a year ago

sorry i was missin the [] in the $json thanks it works for me

Collectives™ on Stack Overflow

How to insert a JSON Array into Mysql? [closed]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related