query($Query); header("location:appointment_view_detail.php?msg=sucess"); //$flag="sucess"; } if ($_REQUEST["form_action"] == "Insert") { $Query_last_invoice = "SELECT date from tbl_doctor_appointment where (date='".$date."' ) "; $name_last_invoice=$DB->query($Query_last_invoice); $noo=mysql_num_rows($name_last_invoice); if($noo==0) { $Query = "insert into $tablename values( NULL,'". $date . "','". $reason_from_hour . "','". $reason_from_min . "','". $reason_from_am . "','". $reason_to_hour . "','" . $reason_to_min . "','" . $reason_to_am."', '".$date_ss ."')"; $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_doctor_appointment where id='$id' "; $name_last_data=$DB->query($Query_last_data); $row_12_123=mysql_fetch_array($name_last_data); $datea=$row_12_123['date']; $from_hour=$row_12_123['from_hour']; $from_min=$row_12_123['from_min']; $from_sta=$row_12_123['from_sta']; $to_hour=$row_12_123['to_hour']; $to_min=$row_12_123['to_min']; $to_sta=$row_12_123['to_sta']; $app_date = date("m/d/Y", strtotime($datea)); } ?>
Success! Data Added Sucessfully.
Danger! Already Exists.

Add Doctor Appointment Time

- -
- -
'; echo''; echo''; } else { echo''; echo''; } ?>
' . $js_code . ''; } echo $js_code; } ?>