$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'])) { $id = $_POST['get_id']; $date = date('Y-m-d', strtotime($_POST['from_date'])); $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); $Query="update tbl_appointment_office set appointment_date = '$date', hour_date='$appointment_time_1', min_date= '$appointment_time_2', aam_date='$appointment_time_3' where id='$id'"; $DB->query($Query); $flag="sucess"; header("location:appointment_details.php"); } ?>