PHP - Identifying Web Crawlers / Spiders By Ip Address

Hy! Any help on this topic would be much appreciated.

Here is the deal. I need to redirect some countries to another URL. But I need to allow a free access for search engine's bots even if they come from those countries.

Here is what I did until now:

Used MaxMind PHP API and databases to establish redirect. And then tried to modify the code to redirect ONLY if user is from blocked country AND IS NOT allowed crawler... suprise suprise, it's not working as I imagined:)!

Here is the code so far:

#!/usr/bin/php -q
<?php

// This code demonstrates how to lookup the country by IP Address

include("geoip.inc");

// Uncomment if querying against GeoIP/Lite City.
// include("geoipcity.inc");

$gi = geoip_open("GeoIP.dat",GEOIP_STANDARD);
$country = geoip_country_code_by_addr($gi, $_SERVER['REMOTE_ADDR']);
geoip_close($gi);

$my_countries = array('de', 'se', 'no', 'ee', 'it', 'lv', 'cz', 'dk', 'sk', 'at', 'ch', 'lu', 'nl', 'es', 'hu', 'sg', 'gr', 'ua', 'fi', 'ru', 'cn', 'hk', 'my', 'id', 'us', 'ar', 'mx', 'ec', 'cr', 'py', 'br');
$allowed_spiders = array('Googlebot', 'Yammybot', 'Openbot', 'Yahoo', 'MSNbot', 'Ask Jeeves', 'Teoma', 'Architext spider', 'FAST-WebCrawler', 'Slurp', 'Yahoo Slurp', 'ia_archiver', 'Scooter', 'crawler@fast', 'Crawler', 'InfoSeek sidewinder', 'Lycos_Spider_(T-Rex)');
$agent_name = $_SERVER['HTTP_USER_AGENT'];


if (in_array(strtolower($country), $my_countries)) {
         foreach($allowed_spiders as $s){
                if(!strpos($s,$agent_name)){
                     header('Location: www.REDIRECT URL.com');
                }
        }
exit;
}


?>


How I imagined this code should work is: First check from where is user coming. Then compare GeoIP shortcode for country to shortcodes for banned countries. AND then if traffic is indeed from banned country also check if user agent name has anything in it from an array of allowed spider names (Googlebot can be Googlebot, or Googlebot/2.1 for an example). And if it's not allowed spider then redirect user to another address.

I tried many variations of this but nothing seems to work. Each time that I tried to fetch page as a googlebot in webmaster, I got 302 redirection. Any help or guidance here MUCH appreciated.

Thank you PHP JEDI in advance !!

I have a form with PHP validation and also a mysqli query checking for duplicates in the database for mailing address and email address in mysql.     It works fine but the customers are adding spaces in the mailing address for example  111 mailing address A V  E, 1 1 1 ma iling address A V  E etc.  and my sql query doesn't see that as an address that's a duplicate.    Their alslo adding email address like my@emailaddress.com and m.y@emailaddress.com, m.y.2@emailaddress.com etc to bypass that comparision also.    Is there anyway to stop this from happening?        

Can you help me with where im going wrong here in this code this with a search function
i am see the out put with pagination view however $id is not getting captured as the link id  any help would be appreciated 

<form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>">
  <table id="tic">    <tr>
      <td>Ticket No | Emp ID:</td><td><input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>"></td>
      <td><input type="submit" name="submit" value="Search"></td>
    </tr>
  </table>
</form>
<?
if($_GET["txtKeyword"] != "")
   {
   $objConnect = mysql_connect("localhost","root","") or die(mysql_error());
   $objDB = mysql_select_db("ticket");
   
   $result = "SELECT * FROM data WHERE (employee LIKE '%".$_GET["txtKeyword"]."%')";
   $objQuery = mysql_query($result) or die ("Error Query [".$result."]");
   $Num_Rows = mysql_num_rows($objQuery);


   $Per_Page = 5;   // Per Page

   $Page = $_GET["Page"];
   if(!$_GET["Page"])
   {
      $Page=1;
   }

   $Prev_Page = $Page-1;
   $Next_Page = $Page+1;

   $Page_Start = (($Per_Page*$Page)-$Per_Page);
   if($Num_Rows<=$Per_Page)
   {
      $Num_Pages =1;
   }
   else if(($Num_Rows % $Per_Page)==0)
   {
      $Num_Pages =($Num_Rows/$Per_Page) ;
   }
   else
   {
      $Num_Pages =($Num_Rows/$Per_Page)+1;
      $Num_Pages = (int)$Num_Pages;
   }


   $result .=" order  by stamp LIMIT $Page_Start , $Per_Page";
   $objQuery  = mysql_query($result);

   ?>
   <table id="ticket"     <tr>
      <th> <div align="center">Ticket No</div></th>
                <th> <div align="center">Date</div></th>
      <th> <div align="center">Issue Type</div></th>
      <th> <div align="center">Status</div></th>
      <th> <div align="center">view</div></th>
               
        </tr>
   <?
   while($row = mysql_fetch_array($objQuery))
   {
   ?>
     <tr>
      <td><div align="center"><?=$row["id"];?></div></td>
                <td><div align="center"><?=$row["stamp"];?></div></td>
      <td><div align="center"><?=$row["issue"];?></div></td>
      <td><div align="center"><?=$row["status"];?></div></td>
                <td><div align="center"><a href="edit.php?id='$row['id']'">Update</a></div></td>
      
      
      </tr>
   <?
   }
   ?>
   </table>
   <br>
   Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
   <?
   if($Prev_Page)
   {
      echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page&txtKeyword=$_GET[txtKeyword]'>Back</a> ";
   }

   for($i=1; $i<=$Num_Pages; $i++){
      if($i != $Page)
      {
         echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i&txtKeyword=$_GET[txtKeyword]'>$i</a> ]";
      }
      else
      {
         echo "<b> $i </b>";
      }
   }
   if($Page!=$Num_Pages)
   {
      echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page&txtKeyword=$_GET[txtKeyword]'>Next</a> ";
   }
   
   mysql_close($objConnect);

   }   
?>

Hi everyone,

I have this script that identify's the current page in the navigation

Code: [Select]
<?php $currentPage = basename($_SERVER['SCRIPT_NAME']); ?>
<ul id="nav"><!-- Open Nav -->
    <li><a href="index2.php" <?php if ($currentPage == 'index2.php') {echo 'class="selected"';} ?>>Home</a></li>
    <li><a href="salon-information.php" <?php if ($currentPage == 'salon-information.php') {echo 'class="selected"';} ?>>Salon Information</a></li>
    <li><a href="about-us.php" <?php if ($currentPage == 'about-us.php') {echo 'class="selected"';} ?>>About us</a></li>
    <li><a href="hair-care-advice.php" <?php if ($currentPage == 'hair-care-advice.php') {echo 'class="selected"';} ?>>Hair Care Advice</a></li>
</ul><!-- Close Nav -->


My problem is that hair-care-advice.php has a number of sub pages. How do I get it so the selected class remains selected for all the sub pages as well as the main page.

Any help would be greatly appreciated

Thank you

Barry

In my .htaccess, I have the following to enter a domain name then a store number such as www.domain.com/c111   The page storeNumber.php displays perfectly call the correct variables through the _GET.   The help I got and has been set up works for an Alpha and thre rest numbers.   What would be rewriterule be to use any random string of Alpha Numberic characters?  Such as C123, 12CF, cf15, C2f5...

RewriteOptions inherit
RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d

RewriteRule ^([a-z0-9-]+)$ /storeNumber.php?storeNumberID=$1 [NC,L]

Thanks for any help in advance, Mike