Send json object to mysql using jquery/javascript/php?

Question

I have a page that generates json data from several fields and I want to send it to a mysql database. I currently have a link, the user clicks the link, the javascript takes the information they've inputed and sends it to a server. Due to the nature, I need all the data in one field in the mysql database. Any ideas?

EDIT: The data comes from several contenteditable divs, in such a way that there is a specific hierarchy. Such as

Data : {
  Heading : 1,
    info1 : 1,
    info2 : 2,
    info3 : 3
    },{
  Heading : 2,
    info1 : 1,
    info2 : 2,
    info3 : 3
    }

At some point in the future, you or someone you love will realize that storing "all the data in one field in the mysql database" was a Bad Idea. — Dolph
– Dolph, Commented Jul 8, 2010 at 0:37

Matthew Flaschen · Accepted Answer · 2010-07-08 00:34:18Z

1

You can use a AJAX post. E.g.:

$.ajax({
    url: someURL,
    type: 'post',
    data: JSON.stringify(myObj),
    contentType: 'application/json',
    dataType: 'json',
    success: function(data, status, xhr)
    {
       // ...
    }
});

To make sure you have JSON.stringify, use json2. The contentType means you are posting a JSON document, the dataType means you expect to receive one from the server.

On the server, you use json_decode to decode, and json_encode to encode a response.

answered Jul 8, 2010 at 0:34

Matthew Flaschen

286k53 gold badges523 silver badges554 bronze badges

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

1 Comment

DavidR Over a year ago

Thanks, stringify was what I needed. I had never heard of that before.

Nathan H · Accepted Answer · 2010-07-08 00:30:28Z

0

Maybe you could use the "serialize" concept?

In jQuery: http://api.jquery.com/serialize/

In PHP: http://us.php.net/manual/en/function.serialize.php

So you would take all the input, serialize it via jQuery, send the big string to the server and store in your database as-is? Then later when you retrieve it in php, you can unseralize it.

answered Jul 8, 2010 at 0:30

Nathan H

49.7k60 gold badges172 silver badges251 bronze badges

3 Comments

Matthew Flaschen Over a year ago

serialize does not output JSON.

Dolph Over a year ago

JSON is a serialized object.

Nathan H Over a year ago

but then you can easily unserialize in php and then json_encode, no?

Collectives™ on Stack Overflow

Send json object to mysql using jquery/javascript/php?

2 Answers 2

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related