Storing Special Characters in mysql using php

[geoamins2]

Can you show me the way about storing the special characters into mysql database using php.

Actually,I'm working on such a website where user can upload text and programming codes into mysql.

Thank you in advance.

[vibhaJ]

For adding data in mysql:
html_entities(mysql_real_escape_string($variable));

For echoing:
html_entity_decode(stripslashes($variable));

[geoamins2]

vibhadevit

Thank you for replying on time. I have been solved my problem by getting help from your post. My other friends can also need the code so see the below

for displaying the data from mysql
$str=html_entity_decode(stripslashes($rows[4]));

for inserting the data with special characters into mysql
$var_name=htmlentities(mysql_real_escape_string($detail));

[geoamins2]

For demo
You people can see www.geoamins.com

[vibhaJ]

I am not sure if this point is still pending or not.
But why your logo is so big??Its taking soo long to load.
You can use resized image.