<?php
include_once("session.php");
include_once("settings.php");

foreach ($_REQUEST as $key => $value) {
    $$key = $value;
}

$brand_id = $_POST['brand_id'];
$state_id = $_POST['state_id'];
$city_id = $_POST['city_id'];
$location = $_POST['location'];
$store_code  =  $_POST['store_code'];   
$store_model = $_POST['store_model'];
$contact_person  =  $_POST['contact_person'];   
$mobile_no_1 = $_POST['mobile_no_1'];
$mobile_no_2  =  $_POST['mobile_no_2'];   
$address = $_POST['address'];
$pincode  =  $_POST['pincode'];   
$latitude = $_POST['latitude'];
$longitude  =  $_POST['longitude'];   
$status  =  $_POST['status'];


//           EDIT code
if ($_REQUEST['mode'] == "Edit") {  
  $sql = "update  tbl_store_locator set brand_id = '" .$brand_id . "'  , state_id = '" .$state_id . "',city_id = '" .$city_id. "' ,location = '" .$location. "',store_code = '" .$store_code. "',store_model = '".$store_model . "',contact_person = '" .$contact_person. "',mobile_no_1 = '" .$mobile_no_1. "',mobile_no_2 = '" .$mobile_no_2. "',address = '" .$address. "',pincode = '".$pincode. "',latitude = '" .$latitude . "',longitude = '" .$longitude. "',status = '" .$status. "'  where id = '" . $_POST['id'] . "'";

}   
else {

   
    $sql = "insert into  tbl_store_locator (brand_id,state_id,city_id,location,store_code,store_model,contact_person,mobile_no_1,mobile_no_2,address,pincode,latitude,longitude,status) VALUES 
	('$brand_id','$state_id','$city_id','$location','$store_code','$store_model','$contact_person','$mobile_no_1','$mobile_no_2','$address','$pincode','$latitude','$longitude','$status')";
     
}

$result = mysql_query($sql) or die(mysql_error());
?>

<script>
    document.location = "location_list.php?page=listlocation";
</script>