Re: UPDATE and redirect

From: Date: Wed, 11 Apr 2007 20:42:24 +0000
Subject: Re: UPDATE and redirect
References: 1 2 3 4  Groups: php.general 
Request: Send a blank email to php-general+get-252629@lists.php.net to get a copy of this message
Marcelo Wolfgang wrote:
and what if $_GET['id'] is something like "1; DROP TABLE tb_emails;" ?? SQL injection just waits to happen
I think tha tit will be too much of a hacker effort just to kill a table of contact emails, and also he will have to guess ( is there other way ? ) the table name, but just to be on a safer side: - Is there a way to say that id can only be a number ? something like $id:Number = $_GET['id']? TIA
If your id should only have digits in it, use if (! ctype_digit($_GET['id'])) { print "invalid parameter error message or exit or whatever"; } This doesn't work with negative integers - it really checks to make sure that there are only digits, but it is very handy for validating GET or POST variables. There are other ctype functions as well... Lori

« previous php.general (#252629) next »