$product="active"; $caller1="open"; $dealer_det="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); session_start(); ?> if($_REQUEST['id']!='') { $update_option =1; } if(isset($_POST['sumbit'])) { date_default_timezone_set('Asia/Kolkata'); $date_ss = date('Y-m-d H:i:s ', time()); $tablename = "`tbl_dealer`"; $name=$_REQUEST['dealer_name']; $address = $_REQUEST['dealer_location']; $phone = $_REQUEST['dealer_phone']; if ($_REQUEST["form_action"] == "Update") { $Query="UPDATE `tbl_dealer` SET `name`='" .$name. "', `address`= '$address', `phone`= '$phone' WHERE `id`='".$_REQUEST['id']."'"; $DB->query($Query); header("location: view_dealer.php"); } if ($_REQUEST["form_action"] == "Insert") { $Query_last_invoice = "SELECT name from tbl_dealer where (name='".$name."' ) "; $name_last_invoice=$DB->query($Query_last_invoice); $noo=mysql_num_rows($name_last_invoice); if($DB->query($Query_last_invoice)) { $Query = "insert into $tablename (`name`, `address`, `phone`)values('". $name . "','". $address . "', '". $phone . "')"; $DB->query($Query); $flag="sucess"; } else { $flag="failure"; } } } date_default_timezone_set("Asia/Kolkata"); $tablename='tbl_job_details'; if ($update_option == 1) { $id=$_REQUEST['id']; $Query_last_data = "SELECT * from tbl_dealer where id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $dealer_name=$row_12_123['name']; $dealer_location=$row_12_123['address']; $dealer_phone=$row_12_123['phone']; } ?>