1#@!#!123s

��JFIF�� 1#@!#!123s
: / home4 / mcspunei / MCS_Backup / shubha27Aug /
Filename : lat_long.php
back
<?php    
/*start zipcode */
session_start();
$userid=isset($_SESSION['matses_userid'])?$_SESSION['matses_userid']:'';
if($userid !=""){
	$getcity=mysql_fetch_array(mysql_query("select pincode from memberregister where id='$userid'"));
	$user_zip=$getcity['pincode'];
}
if($user_zip ==""){
	$temp_ip = $_SERVER['REMOTE_ADDR'];
	$temp_details = json_decode(file_get_contents("http://ipinfo.io/{$temp_ip}"));
	$user_zip = isset($temp_details->postal)?$temp_details->postal:'600028';	
}
/*end zipcode */

function GetCityList($latt,$long){
 $xy=array();
 $geocode=file_get_contents('http://maps.googleapis.com/maps/api/geocode/json?latlng='.$latt.','.$long.'&sensor=false');
 $output= json_decode($geocode);
 
 //print_r($geocode);
 
 //$city= $output->results[0]->address_components[4]->long_name;
 
 
 for($j=0;$j<count(@$output->results[0]->address_components);$j++){
    $cn=array($output->results[0]->address_components[$j]->types[0]);
    if(in_array("administrative_area_level_2", $cn)){
     $city = @$output->results[0]->address_components[$j]->long_name;
    }
 }
 /*add 11 km*/
 //$xy[]=$city;
/* for($i=1;$i<=10;$i++){
      
      $lat=substr(strrchr($latt, '.'), 1);
      $lat=substr($lat,1) + 1;
      $latt=$latt+$lat;
      
      $lng=substr(strrchr($long, '.'), 1);
      $lat=substr($lng,1) + 1;
      $long=$long+$lng;
      
   //   GetCityList($latt,$long);
 }
 */
 
  return isset($city)?$city:"sea";
}
 $zipcode=$user_zip;
 $url = "http://maps.googleapis.com/maps/api/geocode/json?address=".$zipcode."&sensor=false";
 $details=file_get_contents($url);
 $result = json_decode($details,true);
 $ApiState2=$result['results'][0]['address_components'][2]['long_name'];
 $ApiState3=$result['results'][0]['address_components'][3]['long_name'];
 $latt=$result['results'][0]['geometry']['location']['lat'];
 $long=$result['results'][0]['geometry']['location']['lng'];

 $latt = substr($latt,0,6);
 $long = substr($long,0,6);
 
 $step = 6;
 $km = 0.3; //30km
 $location = array(GetCityList($latt,$long));
 
//zone-1 
$temp=$latt;
for($i=0;$i<$step;$i++){	
	$temp+=$km;
	array_push($location,GetCityList($temp,$long));
}
//zone-2 
$temp1=$latt;
$temp2=$long;
for($i=0;$i<$step;$i++){	
	$temp1+=$km;
	$temp2+=$km;
	array_push($location,GetCityList($temp1,$temp2));
}
//zone-3
$temp = $long;
for($i=0;$i<$step;$i++){
	$temp+=$km;
	array_push($location,GetCityList($latt,$temp));
}
//zone-4
$temp1=$latt;
$temp2=$long;
for($i=0;$i<$step;$i++){	
	$temp1-=$km;
	$temp2+=$km;
	array_push($location,GetCityList($temp1,$temp2));
}
//zone-5
$temp=$latt;
for($i=0;$i<$step;$i++){
	$temp-=$km;
	array_push($location,GetCityList($temp,$long));
}
//zone-6
$temp1=$latt;
$temp2=$long;
for($i=0;$i<$step;$i++){
	$temp1-=$km;
	$temp2-=$km;
	array_push($location,GetCityList($temp1,$temp2));
}
//zone-7
$temp=$long;
for($i=0;$i<$step;$i++){
	$temp-=$km;
	array_push($location,GetCityList($latt,$temp));
}
//zone-8
$temp1=$latt;
$temp2=$long;
for($i=0;$i<$step;$i++){
	$temp1+=$km;
	$temp2-=$km;
	array_push($location,GetCityList($temp1,$temp2));
}
$user_circle = array_unique($location);
$citys=implode(",",$user_circle);
$citys=strtolower($citys);

$getstatecode=mysql_fetch_array(mysql_query("select Admin1_str_code from skadate_location_state where Admin1_str_name !='' and find_in_set(Admin1_str_name,'$ApiState2')"));
$apistate=$getstatecode['Admin1_str_code'];
if($apistate==""){
$getstatecode=mysql_fetch_array(mysql_query("select Admin1_str_code from skadate_location_state where Admin1_str_name !='' and find_in_set(Admin1_str_name,'$ApiState3')"));
$apistate=$getstatecode['Admin1_str_code'];
}
$citys_sql="and memberregister.state='$apistate' and find_in_set(memberregister.city,'$citys')";
//echo $citys_sql="and find_in_set(memberregister.city,'$citys')";
//echo "test".$citys_sql;
?>