StefanRSA Posted April 30, 2009 Share Posted April 30, 2009 I have a textbox where people sometimes enter sentences with "" and ''... This come from a textbox. I want to enter this into my DB with the following code: mysql_query("INSERT INTO term (id, t_reg_no, cn_person, cn_number, terms, added) VALUES ('', '$reg', '$cn_person', '$cn_number', '$terms', NOW());"); $terms is the textbox, but if someone is using "" and '' in the same string, it breaks my code???? I was thinking that it might be because of magic_quotes_gpc settings in my php.ini but my server magic_quotes_gpc is on?! What am I misssing or how can i get around this problem???? Link to comment https://forums.phpfreaks.com/topic/156335-solved-double-quotes-or-the-single-quotes-in-string/ Share on other sites More sharing options...
9three Posted April 30, 2009 Share Posted April 30, 2009 mysql_real_escape_string Link to comment https://forums.phpfreaks.com/topic/156335-solved-double-quotes-or-the-single-quotes-in-string/#findComment-823136 Share on other sites More sharing options...
StefanRSA Posted April 30, 2009 Author Share Posted April 30, 2009 mysql_real_escape_string HUH? Link to comment https://forums.phpfreaks.com/topic/156335-solved-double-quotes-or-the-single-quotes-in-string/#findComment-823137 Share on other sites More sharing options...
9three Posted April 30, 2009 Share Posted April 30, 2009 go to php.net type in mysql_real_escape_string Link to comment https://forums.phpfreaks.com/topic/156335-solved-double-quotes-or-the-single-quotes-in-string/#findComment-823139 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.