[SOLVED] Any help on how to store texts in quotation

[fekaduw]

hello everyone,

 

i have a mysql database and i wanted to store texts under quotation. i used the addslashes() function so that the quotations will also be stored. But this function adds too many slashes before the text (eg. \\\\\\\"Agriculture and Development\\\\\\\"). When i try to display the text that is stored in the db, it creates disorder on my page. 

 

is there any way out to handle this situation?

 

with best regards

[obsidian]

The principle I like to follow is to do as little modification to the script as possible when you insert into your database. Then, when you display the text, you can do your additional parsing. First suggestion I would make is to try using the mysql_real_escape_string() on your text instead of addslashes(). Then, when you pull it out of your database, run stripslashes() on it if you care to, but more importantly, I like to run my strings through htmlentities() with the ENT_QUOTES set to properly display all quotes without fear of messing with any surrounding HTML entities.

 

Hope this helps.

[jitesh]

You can refer

 

adslashes

stripslashes

[fekaduw]

thank you very much!

it works