stripslashes etc.

From: Date: Thu, 02 Mar 2006 20:17:28 +0000
Subject: stripslashes etc.
Groups: php.db 
Request: Send a blank email to php-db+get-41370@lists.php.net to get a copy of this message
Hello, all. I'm getting a bit confused figuring out the best way to insert data into a db via web forms and then pull it out again safely. I know there's lots of information out there, but I was hoping someone could suggest a current, [easy!] best practice. Specifically, I have the following surely common set of situations: 1. user submits info to db --how best to screen out html / escape special characters on insert 2. info is publicly displayed -- how best to unescape special characters for display 3. user edits their submission in form populated with their existing data --again, to screen, but not have the escape characters multiply crazily 4. user updates db --again, without additional of exciting new escape characters I'm getting a bit mixed up through all the stages, and if someone would take pity and walk me through this, I, um, would thank you sincerely. TIA, Andrew

« previous php.db (#41370) next »