need short regex for form validation

[Bastien]

trying to validate some input that can be either numeric or alpha...am trying to figure out a short regex that i can use to pick up those values that may lead to sql injection attacks...

any ideas?

TIA

Bastien

cat, the other other white meat

 

[DRJ478]

Did you have a look at the PHP native functions?

http://us3.php.net/manual/en/function.mysql-escape-string.php

http://us3.php.net/manual/en/function.mysql-real-escape-string.php

 

[SPYDERIX]

Hi,

There are also these:

$var1 = $_POST["message"];
$search = array (&quot;'<'&quot;, &quot;'>'&quot;
$replace = array (&quot;<&quot;, &quot;>&quot;
$var2 = preg_replace ($search, $replace, $var1);

$message = addslashes($var2);

-----------------------------------------------

$var1 = nl2br(stripslashes($message));

Hope this helps!