blackwater dev wrote:
> I have a project now where we would like to properly remove unwanted data
> before it goes into the db such as ` and of course slashes.  The problem is
> I have tons of pages.  Is there an easy way to add in a clean up routine on
> the db side to clean it going in and coming out without having to touch each
> page that inserts it into the db and each page that presents it?
> 
> I'm using a MySQL db.
> 
> 
> Thanks!
> 

Just do a global search/replace on all of your files replacing
mysql_query with to mysafe_query.  Then in one of your always included
files create a mysafe_query() function to do the sanitizing that you
want.  There are lots of free tools to do this.  I use kfilereplace on
kubuntu.  I wrote a simple one for windows in C# which you can have.

If needed, you could also extend this to mysql_fetch_row() etc...

-Shawn

-- 
Thanks!
-Shawn
http://www.spidean.com

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to