fekaduw Posted March 23, 2007 Share Posted March 23, 2007 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 Quote Link to comment Share on other sites More sharing options...
obsidian Posted March 23, 2007 Share Posted March 23, 2007 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. Quote Link to comment Share on other sites More sharing options...
jitesh Posted March 23, 2007 Share Posted March 23, 2007 You can refer adslashes stripslashes Quote Link to comment Share on other sites More sharing options...
fekaduw Posted March 23, 2007 Author Share Posted March 23, 2007 thank you very much! it works Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.