PHP save in MySQL for the Object coming from Javascript "JSON.stringify" via Ajax?

Question

I have an Object from Javascript pass to PHP (via AJAX):

var jsObject = {
    "name": "Michael Divo",
    "age": 27,
    "country": "United States"
};

jsObject_json = JSON.stringify( jsObject );

$.ajax({
    type: "POST",
    dataType: 'json',
    url: "http://www.example.com/myserver.php",
    data: { mydata: jsObject_json },
}) ...

In, myserver.php:

$json = json_decode($_POST["mydata"], true);

Then if i save that $json into the MySQL from this PHP end, it is saved as:

Array

.. in the Database, as that "Array" as a String.

So how do i properly SAVE this JSON into the MySQL please? (So that i can later retrieve it back as a JSON and read.)

USe serialize function to store into DB.

Jitendra Yadav
– Jitendra Yadav

2014-06-12 12:30:33 +00:00
Commented Jun 12, 2014 at 12:30 — Jitendra Yadav
– Jitendra Yadav, Commented Jun 12, 2014 at 12:30

Quentin · Accepted Answer · 2014-06-12 12:23:59Z

3

If you just want to pull it back as JSON, then don't run it through json_decode. Leave it as a string.

Most sensible systems, however, would have a database structure that would allow each of the fields in the JSON submission to be handled separately. Then you would access each field and add it in its own column in the INSERT query. You could then perform queries on the data beyond "Give me all the data" (e.g. WHERE country = 'United States').

$preparedStatement = $db->prepare('INSERT INTO data (name, age, country) VALUES (:name, :age, :country)');
$preparedStatement->execute(json_decode($_POST["mydata"], true));

answered Jun 12, 2014 at 12:23

Quentin

949k136 gold badges1.3k silver badges1.4k bronze badges

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

Comments

Sabri Aziri · Accepted Answer · 2014-06-12 12:24:49Z

0

You dont need to decode it before you store it into db, (store it as pure string), then if you what to get it back(somewhere else in your code) get that string and decode it.

answered Jun 12, 2014 at 12:24

Sabri Aziri

4,2045 gold badges33 silver badges45 bronze badges

Comments

greut · Accepted Answer · 2014-06-12 12:26:30Z

0

By using json_encode() you can reencode your Array into a JSON that can be stored into a TEXT field in MySQL. Or since, you already have it as a string, leave it as is.

$stmt = $db->prepare("INSERT INTO FOO (mydata) VALUES (:my_data)");
$stmt->execute($_POST);

answered Jun 12, 2014 at 12:26

greut

4,4031 gold badge32 silver badges49 bronze badges

Comments

Rohit Choudhary · Accepted Answer · 2014-06-12 12:33:45Z

0

As your Database schema is not provided here so assuming that you need to store the string only, in this case don't decode your json as this will turn json string to array. In case of you have schema then you can proceed by decoding this into array and then save elements according to you table schema.

answered Jun 12, 2014 at 12:33

Rohit Choudhary

2,2571 gold badge24 silver badges35 bronze badges

Comments

Gabber · Accepted Answer · 2014-06-12 12:59:18Z

0

try this

$str = $db->prepare("INSERT INTO table (json_array) VALUES (:json_data)");
$str->execute($_POST["mydata"]);

edited Jun 12, 2014 at 12:59

answered Jun 12, 2014 at 12:25

Gabber

7,2593 gold badges35 silver badges47 bronze badges

6 Comments

Quentin Over a year ago

Danger: You are vulnerable to SQL injection attacks that you need to defend yourself from.

Gabber Over a year ago

@Quentin now every thing is ok

Quentin Over a year ago

Except for not actually putting any placeholders in your query

Gabber Over a year ago

sorry @Quentin i am not php developer,so i have no idea about PHP,but i edit again my answer.if something wrong in my answer so plz correct it.

Quentin Over a year ago

And now you're vulnerable to SQL injection attacks again.

|

Collectives™ on Stack Overflow

PHP save in MySQL for the Object coming from Javascript "JSON.stringify" via Ajax?

5 Answers 5

Comments

Comments

Comments

Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related