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.

Recommended Answers

All 4 Replies

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

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

commented: very easy way to store special characters in mysql using php +1

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));

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.