User insert commas into text field deletes data from mysql

I'm having problems inserting commas (,) in my text fields in html. When I submit it to mysql, it d开发者_如何学Celetes the data. How do I work with this?

I've tried mysql_real_escape_string() but that still doesn't work. I have lots of data, and I don't want to use str_replace either. Is there another alternative?

escape your message before you send it to the server, so it's stored escaped, then unescape it when you print it in your html page.

so... msgTosend = escape(whateverText);

and then when you're printing msgToPrint = getFromDatabase(unescape(myText))

however, as the comment points out, you're obviously doing something dreadfully wrong altogether.

If you're storing strings (as it sounds) you need to be wrapping them in quotes before you store them. Once you do that no amount of commas can ruin anything. If you're not storing strings, but some other data type, then you should be breaking those out into individual variables on the server before storing anything. The potential for malice or just plain breakage is basically 100% with what it sounds like you're doing.