$caller="active"; $caller1="open"; $appoint="active"; require_once '../template/superadmin/action_connection.php' ; include("../settings/adminsession.php"); session_start(); ?> if($_REQUEST['id']!='') { $update_option =1; } ?> if(isset($_POST['Submit'])) { $ses_ma_id=$_SESSION["userid"]; date_default_timezone_set('Asia/Kolkata'); $date = date('Y-m-d H:i:s ', time()); $mobile=trim(addslashes($_POST['mobile'])); $name=trim(addslashes($_POST['name'])); $location=trim(addslashes($_POST['location'])); $consulting=trim(addslashes($_POST['consulting'])); $amount=trim(addslashes($_POST['age'])); $prodid=$_POST['from_date']; $mas=date('Y-m-d', strtotime($_REQUEST["from_date"])); $id=$_REQUEST['id']; $m_id=$n_t_d; $dob=date('Y-m-d', strtotime($dob)); $time_id=trim(addslashes($_POST['time_id'])); $time_id_1=strtotime($time_id); $date_id=trim(addslashes($_POST['date_id'])); $date_id_1=strtotime($date_id); $appointment_time=date('h:i a', $time_id_1); $appointment_date=date('Y-m-d', $date_id_1); $appointment_time_1=date('h', $time_id_1); $appointment_time_2=date('i', $time_id_1); $appointment_time_3=date('a', $time_id_1); //$time_t=date('h:i a', $time_id); //$date_t=date('Y-m-d', $date_id); $app_id=$_REQUEST['app_id']; $Query="INSERT INTO tbl_appointment_office VALUES (NULL,'6','".$mas."','".$date."','$appointment_time_1','$appointment_time_2','$appointment_time_3','$consulting','','$mobile','','$name','$location','2021-11-02 18:49:38','$amount','','def','1','0','')"; $DB->query($Query); $mysql_insert_id= mysql_insert_id(); $flag="sucess"; // header("location:appointment-confirmation.php?id=".$id ."&m_id=".$m_id); } ?>