<?


include_once('connect.php');


$area_sql = mysql_query("SELECT * FROM `cats` WHERE `active` = '0' LIMIT 1");

if(!mysql_num_rows($area_sql)){echo 'done';die;}
while($area_row = mysql_fetch_array($area_sql)){

$mid=$area_row['cat_id'];
$mcat_name =$area_row['cat_name'];
$cat_name =strtolower($area_row['cat_name']);
$cat_name = str_replace(' ','-',$cat_name);

}
echo $mid; echo '<hr>';



 $proxy_proxy = '115.249.170.190:80';
 $url = 'http://www.scoot.co.uk/find/'.$cat_name.'-in-uk';
 echo  $url; echo "<hr>";
  $curl = curl_init(); 
  curl_setopt($curl, CURLOPT_URL, $url); 
  curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); 
  curl_setopt($curl, CURLOPT_TIMEOUT, 10); 
  curl_setopt($curl, CURLOPT_PROXY, $proxy_proxy); 
  curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.2) Gecko/20090729 Firefox/7 GTB5');
  $get = curl_exec($curl); // execute the curl command 
  curl_close($curl);

//echo $get; die;
if ($get) {

$regexp = "<a href=\"/find/(.*)\">(.*)</a>";
if(preg_match_all("#$regexp#siU", $get, $matches)) {


foreach($matches[2] as $keywords){
$keywords = str_replace(',','',$keywords);
echo "<br>$keywords";
mysql_query("INSERT INTO score SET result='{$keywords}', results_for='{$mcat_name}'");

}

} 
mysql_query("UPDATE cats SET active='1' WHERE cat_id='$mid'"); echo updates;
} else { echo 'unable to get'; die;}





?>
<meta http-equiv="refresh" content="0" />