mysqli - MySQL INSERT INTO Syntax Error 1064 -


Sorry, there is a syntax error in my MySQL statement again! I'm pretty sure this is JSON, but I'm using mysqli_real_escape_string to avoid it, though this can not be enough?

This is my statement:

<< / code>, headers, Html_body, Mailbox_hash, Message_id, REPLY_TO, Send_date, theme, tag, text_body, / Code from code> email (attachment, cc, cc_full, date, >, to_full) value ([{["Content \": \ "VGhpcyBpcyBhdHRhY2htZW50IGNvbnRlbnRzLCBiYXNlLTY0IGVyY29kZWQu \", \ "ContentLength \": 60, \ "ContentType \ ": \" Text \ / plain \ ", \" name \ ": \" test.txt \ "}], \" first cc \ ", secondCc@postmarkapp.com, [{\" email \ ": "Firstcc@postmarkapp.com \", \ "name \": \ "first cc \"}, {\ "email \": \ "secondCc@postmarkapp.com \"}], Mon, 5 Mar 2012 14:33 : 50 +0100, support@postmarkapp.com, [{\ "name \": \ "X-Header Test matches \", \ "value \": \ "\" }],

This is a test HTML body , SampleHash, 73e6d360-66eb-11e1-8e72-a8904824019b, Replyto@postmarkapp.com, 2014-08-14 09:06:00, 14-08- 2014 09:06, testtag, this is a test text body, \ "Firstname Last Name \", [{"Email \": \ "Mailbox+hash@inbound.postmarkapp.com \", \ "Name \": \ "First name last name \"}]

I get this error:

"There is an error in your SQL syntax; Line 1 (1064) in " <: Manual that to use to correct syntax" \ "VGhpcyBpcyBhdHRhY2htZW50IGNvbnRlbnRzLCBiYXNlLTY0IGVuY29kZWQu \", \ [{\ "content \" your server Check the version that matches the p> I really hope someone can help me where I'm actually going wrong so I would like to know for the next time as an explanation also that you All thanks, much appreciated!)

Yek values ​​should be wrapped in quotes, such as:

included in the email (attachments, CC, Sisi_puarn, date, , headers, Html_body, Mailbox_hash, Message_id, REPLY_TO, send_date, theme, tag, text_body, for , to_full) values ​​( "[{\" content \ "of : \" VGhpcyBpcyBhdHRhY2htZW50IGNvbnRlbnRzLCBiYXNlLTY0IGVuY29kZWQu \ ", \" ContentLength \ ": 60, \ "ContentType \": \ "text \ / plain \", \ "name \": \ "test.txt \"}] "," \ "first cc \", secondCc@postmarkapp.com "," [{{ "Email \": \ "firstcc@postmarkapp.com \", \ "name \": \ "first cc \"}, {\ "email \": \ "secondcc @ postmark app.com \"}] ", "Mon, 5 Mar 2012 14:33:50 + 0100 "," support@postmarkapp.com "," [{\ "name \": \ "X-Header Test matches \", \ "Price \":. \ "\"}] "," This is a test HTML body

"," SampleHash "," 73e6d360-66eb-11e1-8e72-a8904824019b is "," Replyto@postmarkappkcom "," 2014-08-14 09:06:00 "," 14-08-2014 09:06 "," TestTag "," This is a test text body. "," \ "First name \", "[[\" email \ ": \" mailbox +hash@inbound.postmarkapp.com \ ", \" name \ ": \" first name \ "beforehand \ "}]")

This then appears even after commas within values.

Thanks everyone!

Comments