MG Data

PHP Wildcard Match in an Array

I was working with a list of wildcard banned domain names (e.g. *.spamsite.com) stored in a database. I needed to compare a submitted domain (e.g. anything.spamsite.com) to the wildcard entries stored in the database.

Essentially then I need the function in_array to perform with a wildcard match with the wildcards being the array haystack not the needle.

In the above example, I need the script to detect that anything.spamsite.com is banned. Here’s what I did:

Code (php)
$bannedurl = false;</p>
//The function fnmatch is useful here but is not available on Windows systems, so it must be defined if it does not exist.
 
   if (!function_exists(‘fnmatch’)) {
       function fnmatch($pattern, $string) {
        return @preg_match(‘/^’ . strtr(addcslashes($pattern, ‘\\.+^$(){}=!<>|’), array(‘*’ => ‘.*’, ‘?’ => ‘.?’)) . ‘$/i’, $string);
       }
   }
 
//This function allows wildcards in the array to be searched
   function my_inArray($needle, $haystack) {
      foreach ($haystack as $value) {
       if (true === fnmatch($value, $needle)) {
        return true;
       }
      }
      return false;
   }
   foreach ($wild_urls as $value) {
    $wild_urls[] = ‘*’ . $value;
   }
 
//An Example
 
   $wild_urls = array(‘*.spamsite.com’);
   $domain = ‘anything.spamsite.com’;
 
//Test it, returns true if the Domain is banned.
 
   if (my_inArray($domain, $wild_urls)) $bannedurl = true;
 
//Note, for the domain spamsite.com, you can do a straight MySQL query such as " …… where domain like ‘%" . $domain . "’ and domain not like ‘%_." . $domain . "’ "

This entry was posted on Thursday, November 30th, 2006 at 1:33 am and is filed under MySQL, PHP Code Snippets. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

You must be logged in to post a comment.

PHP Wildcard Match in an Array

Leave a Reply