How to insert special characters into a database?

php mysql database insert special-characters

$insert_data = mysql_real_escape_string($input_data);

Assuming that you have the data stored as $input_data

php mysql database insert special-characters

Are you escaping? Try the mysql_real_escape_string() function and it will handle the special characters.

php mysql database insert special-characters

You are most likely escaping the SQL string, similar to:

SELECT * FROM `table` WHERE `column` = 'Here's a syntax error!'

You need to escape quotes, like follows:

SELECT * FROM `table` WHERE `column` = 'Here\'s a syntax error!'

CodeHunter