Can I store a JavaScript Object in a mySQL database?

Question

I am gathering data from a webpage visitor and putting it into a JavaScript object I create. But later I want to be able to reference the data they entered.

I have access to a MySQL database, so is there a way for me to store this object there?

I want to try and keep it in the object format instead of breaking it up into its separate parts.

Answer 1

Store a JSON.stringified version of your object in the database, then JSON.parse it when you want the object back again. It would look something like this:

var myObj = {some: data, other: stuff};
var myObjString = JSON.stringify(myObj);
// store string in mySQL database here

// load string from database
var myJSONString = //mySQL database call
var myLoadedObj = JSON.parse(myJSONString);