How to store data which contains quotes in MySQL
Posted
by Nitz
on Stack Overflow
See other posts from Stack Overflow
or by Nitz
Published on 2010-04-27T11:59:33Z
Indexed on
2010/04/30
5:07 UTC
Read the original article
Hit count: 160
In one of my forms I use the rich text editor from Yahoo!. Now i want to store the data from that textarea in a MySQL database.
The user can enter anything in that textarea, e.g. many double or single quotes.
How can I store that data?
Normally we store by adding that data in one variable and then put that in sql, but the quotes cause problems.
© Stack Overflow or respective owner