Search an array 1

[mufka]

Is there a way to use something like in_array() to see if a variable is in a MySQL array?

Something like (incomplete for simplicity):

$ip = @$REMOTE_ADDR;
$result = mysql_query("SELECT ip_address from banned_ip");
if (in_array($ip,$result)) {
     echo 'UNAUTHORIZED ACCESS';
     exit();
}

I have it working using a while loop, but I'm hoping there is a simpler way to do it.

 

[feherke]

Hi

What is "a MySQL array" ?

Anyway, [tt]mysql_query()[/tt] returns a resource, not an array.

And anyway, that is not the way to test such thing.

$ip = @$REMOTE_ADDR;
$result = mysql_query("select 1 from banned_ip where ip_address='".mysql_real_escape_string($ip)."'");
if (mysql_num_rows($result)) {
     echo 'UNAUTHORIZED ACCESS';
     exit();
}

Feherke.

http://rootshell.be/~feherke/

 

[mufka]

Doh! I should have thought of that. Sometimes simple escapes me.