Re: preventing sql injections
| From: | Bogdan Stancescu | Date: | Wed, 18 Dec 2002 17:28:58 +0000 |
| Subject: | Re: preventing sql injections | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-128755@lists.php.net to get a copy of this message | ||
Also, please note that if you're using MySQL you don't have to bother at all security-wise - MySQL won't accept more than one query per mysql_query(). You do have to bother about regular errors though - if $f_namn or $email contain quotes (which $email might well contain) then you're going to end up with a database ERROR - but no harm done.
Bogdan
1lt John W. Holmes wrote:
sqladdslashes should be enough and put qoutes arround your strings in theMeaning that a query like this one is safe, as long as I first have $e_namn = addslashes($e_namn);? $query = "INSERT INTO addr (last_name, first_name, email) VALUES(\"$e_namn\",\"$f_namn\",\"$email\")";Yeah, as long as you do the same for $f_namn and $email. ---John Holmes...