cgm225 Posted July 22, 2007 Share Posted July 22, 2007 How does one deal with comma's that are found within text submitted in a textarea.. input that will ultimately end up in a mysql database table row field or a flatfile? I have two different scripts that get input from a textarea and whenever there is a comma in the text being submitted, the submitted text is not stored.. Any ideas? Sincerely, cgm225 Link to comment https://forums.phpfreaks.com/topic/61184-how-to-deal-with-commas-in-textarea-submissions/ Share on other sites More sharing options...
ss32 Posted July 22, 2007 Share Posted July 22, 2007 commas dont affect mysql storage... if i were you i would be more worried about a single or double quote. mysql_escape_real_string() may help (= Link to comment https://forums.phpfreaks.com/topic/61184-how-to-deal-with-commas-in-textarea-submissions/#findComment-304476 Share on other sites More sharing options...
cgm225 Posted July 22, 2007 Author Share Posted July 22, 2007 so that will do what to single quotes? Link to comment https://forums.phpfreaks.com/topic/61184-how-to-deal-with-commas-in-textarea-submissions/#findComment-304477 Share on other sites More sharing options...
dbo Posted July 22, 2007 Share Posted July 22, 2007 escape them... check out the manual on php.net if your string was: can't it would be sent to mysql as can\'t essentially. Link to comment https://forums.phpfreaks.com/topic/61184-how-to-deal-with-commas-in-textarea-submissions/#findComment-304482 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.