Sorry, there is a syntax error in my MySQL statement again! I'm pretty sure this is JSON, but I'm using This is my statement: << / code>, headers, Html_body, Mailbox_hash, Message_id, REPLY_TO, Send_date, theme, tag, text_body, 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: Yek values should be wrapped in quotes, such as: "," 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! mysqli_real_escape_string to avoid it, though this can not be enough?
>, 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 \": \ "\" }],
"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!)
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
Comments
Post a Comment