Pattern matching with preg_match and arrays

shurrupak

Previous post solved, here goes another dilema:

My code snippet:

$workst=gethostbyaddr($_SERVER['REMOTE_ADDR']);
$getuid=mysql_query("SELECT * FROM users");
if($fetch=mysql_fetch_array($getuid)==NULL){ echo "No registered users found"; exit;} else
if(!preg_match("/\b$fetch['user']\b/i", $workst))  { echo "Not Found";} else echo "Found";

The last line doesn't work - I'm getting the following error "Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING" since I'm trying to read off an array.
The function works if I try to match a singe value but this is not what I want 😕

A little background:
I'm getting the remote user's computer name and check the local database against a username that matches the computer name. Since the database will contain several user names I want to somehow compare that array with preg_match as in my code snippet.

Any help is highly appreciated since I can't find the answer myself :o

NogDog

I'd recommend the following, both to solve the parse error plus to make sure the user input does not mess up your regex:

if(!preg_match('/\b' . preg_quote($fetch['user']) . '\b/i', $workst))  {

(PHP does not like array elements with quoted indexes within a double-quoted string. You either need to surround the entire variable with curly braces ("test{$array['index']}test") or use concatenation, instead.)

shurrupak

Arrrghhh, now the function returns "Found" even if the database doesn't contain the username :mad:
I'm sure I'm missing something for I became rusty...:xbones:

shurrupak

Thanks, that worked after fiddling with my code:

$getuid=mysql_query("SELECT * FROM users");
$fetch=mysql_fetch_array($getuid);
if(!preg_match('/\b' . preg_quote($fetch['user']) . '\b/i', $workst))  { header("HTTP/1.1 403 Forbidden"); exit;}

This works with an exception; If the script encounters an invalid username in the array even if a valid username is present it will return false. It's like it always reads the last item in that array.
Is there a method to read all elements at once?