How to convert object to string javascript

Question

I have an object that looks like this.

Object {Dry Aged Ribeye(medium): "1"
     , Dry Aged Ribeye(rare): "1"
     , Dry Aged Ribeye(well): "1"
     , favorite_tables: "{"dc76e9f0c0006e8f919e0c515c66dbba3982f785":[]}"
}

I wish to insert this to mysql in single column as is. If I try to insert it, it just says [object Object]. I tried to make it into string by JSON.stringify, Array.join() but no luck.

Help me convert this object into string.

What is the SQL query you're using? Can you post the code that you have? — Dana Woodman
– Dana Woodman, Commented Jul 9, 2015 at 2:50
Not sure if that Object you posted above is verbatim to what you're actually using, but that is syntactically incorrect — rgbchris
– rgbchris, Commented Jul 9, 2015 at 2:53
Your object is not a valid JSON. That is why you cannot stringify it — jpcanamaque
– jpcanamaque, Commented Jul 9, 2015 at 3:17

baao · Accepted Answer · 2015-07-09 03:03:54Z

1

I'm not sure if it will work with your object as its keys are invalid, but you can use JSON.stringify for converting an object to a string

var obj = {foo:'bar'};
console.log(JSON.stringify(obj));

answered Jul 9, 2015 at 3:03

baao

73.6k18 gold badges152 silver badges209 bronze badges

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

Comments

jpcanamaque · Accepted Answer · 2015-07-09 03:25:02Z

0

You have problem on creating your JSON object, specifically the way you created your keys. You have to enclose it within quotation marks (or might I say stringify it).

var obj = {
    'Dry Aged Ribeye(medium)': "1"
    , 'Dry Aged Ribeye(rare)': "1"
    , 'Dry Aged Ribeye(well)': "1"
    , 'favorite_tables' : {"dc76e9f0c0006e8f919e0c515c66dbba3982f785":[]}
};

console.log(JSON.stringify(obj));

answered Jul 9, 2015 at 3:25

jpcanamaque

1,0791 gold badge8 silver badges15 bronze badges

Comments

Dean Brown · Accepted Answer · 2015-07-09 03:28:01Z

0

If you have spaces in your keys then you must surround them with quotes.

var myObject ={"Dry Aged Ribeye(medium)": "1", 
  "Dry Aged Ribeye(rare)": "1", 
  "Dry Aged Ribeye(well)": "1", 
  "favorite_tables": "{'dc76e9f0c0006e8f919e0c515c66dbba3982f785':[]}"
}

I also replaced the double quotes in favorite_tables with single quotes. Alternatively you could escape them with \"

With these changes then JSON.stringify should work

answered Jul 9, 2015 at 3:28

Dean Brown

1564 bronze badges

Collectives™ on Stack Overflow

How to convert object to string javascript

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related