inserting json variable into database [duplicate]

Question

I want to insert a json object value in mysql database using php. The object is:

{"data":[{"code":"1234",name:"nike"},{"code":"1034",name:"relexo"}]}.

The database table name is product and the fields name are code and name. How to insert this?

What have you tried? StackOverflow is a site to help with code, not write code for you. Check out some other examples. — Erik Terwan
– Erik Terwan, Commented Oct 19, 2016 at 5:28
@T.J.Crowder this is JSON, he just didn't surround it in quotation marks — Grey
– Grey, Commented Oct 19, 2016 at 6:59

Grey · Accepted Answer · 2016-10-19 07:09:09Z

-2

quick explination on how you could read a JSON file and append it to a table in the database:

<?php
     //connect to DB
     $con = mysql_connect("username","password","") or die('Could not connect: ' . mysql_error());
    mysql_select_db("product", $con);

    //read the json file contents
    $jsondata = file_get_contents('empdetails.json');

    //convert json object to php associative array
    $data = json_decode($jsondata, true);

    //get the product details
    $code = $data[code];
    $name = $data[name];

    //insert into mysql table
    $sql = "INSERT INTO product(code, name) VALUES('$code', $name)"
    if(!mysql_query($sql,$con))
    {
       die('Error : ' . mysql_error());
    }

?>

this should be enough to get you going

answered Oct 19, 2016 at 7:09

Grey

89110 silver badges32 bronze badges

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

2 Comments

Erik Terwan Over a year ago

mysql_ is deprecated, you should use PDO with prepared statements, that also takes care of the sql injection issue with this code.

Grey Over a year ago

true, I've also been using PDO for my projects, but I find sql a good starting point for beginners to learn about database connections, even though it's not good practice, I should've noted this in my answer

Collectives™ on Stack Overflow

inserting json variable into database [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related