escape apostrophe in data string

[richcleverley]

Hi,

I am developing a site which as part of it stores user text input in a mysql database. This data is place names and various ones have an apostrophe in them. This data is used to dynamically populate drop down boxes and if a place has an apostrphe in it it causes the dropdown to stop working.

Is there a way to escape (\) the apostrophe before it is written to the database so the drop downs work properly?

eg, user input's Cap D'agde in the town field, I want Cap D\'agde to be written to the database.

Thanks,

Richard

 

[Vragabond]

What you need is addslashes().

 

[richcleverley]

Hmm, yep thought so after reading up on it after posting here.

Thanks

Richard

 

[sleipnir214]

Something better than addslashes(), particularly when you're going to be adding the data to MySQL, is probably mysql_real_escape_string() (

http://www.php.net/manual/en/function.mysql-real-escape-string.php).

mysql_real_escape_string() is purpose-built for MySQL.



Want the best answers? Ask the best questions! TANSTAAFL!

 

[richcleverley]

Thanks again sleepnir, I will definitely look into this one.

Richard