$product="active"; $caller1="open"; $member_detil="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_company`"; $address=trim(addslashes($_REQUEST['address'])); $gst=trim(addslashes($_REQUEST['gst'])); $name=trim(addslashes($_REQUEST['name'])); $email=trim(addslashes($_REQUEST['email'])); $phone=trim(addslashes($_REQUEST['phone'])); $dob=trim(addslashes($_REQUEST['dob'])); $state=trim(addslashes($_REQUEST['state'])); $postcode=trim(addslashes($_REQUEST['postcode'])); $city=trim(addslashes($_REQUEST['city'])); if ($_REQUEST["form_action"] == "Update") { $Query="UPDATE `shop_user` SET `address`='" .$address. "',`gst`='" .$gst. "',`name`='" .$name. "',`email`='" .$email. "',`phone`='" .$phone. "',`dob`='" .$dob. "', `state`='" .$state. "',`postcode`='" .$postcode. "',`city`='" .$city. "' WHERE `user_id`='".$_REQUEST['id']."'"; $DB->query($Query); header("location:dealer_details.php?sucess=sucess"); } } date_default_timezone_set("Asia/Kolkata"); $tablename='tbl_job_details'; if ($update_option == 1) { $id=$_REQUEST['id']; $Query_last_data = "SELECT * from shop_user where user_id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $address=$row_12_123['address']; $name=$row_12_123['name']; $email=$row_12_123['email']; $phone=$row_12_123['phone']; $dob=$row_12_123['dob']; $state=$row_12_123['state']; $postcode=$row_12_123['postcode']; $city=$row_12_123['city']; } ?>