query($Query_delete); header("location:view_doctor_visit.php?msg=sucess"); } if($_REQUEST['idss']!='') { $ids1=$_REQUEST['status']; if($ids1==0) { $ids_m_k=1; } else { $ids_m_k=0; } "UPDATE tbl_doctor_visit SET status='". $ids_m_k."' WHERE `id`='".$_REQUEST['idss']."'"; $Query="UPDATE tbl_doctor_visit SET status='". $ids_m_k."' WHERE `id`='".$_REQUEST['idss']."'"; $DB->query($Query); header("location:view_doctor_visit.php?msg1=sucess"); } if($_REQUEST['cancel_id']!='') { $id=$_REQUEST['cancel_id']; //$Delete_Question = "DELETE FROM tbl_appointment WHERE `id`='$id'"; //$Result_Question = mysql_query($Delete_Question); $Query_delete = "UPDATE tbl_doctor_visit SET status='1' WHERE `id`='".$_REQUEST['cancel_id']."'"; $name_delete=$DB->query($Query_delete); header("location:view_doctor_visit.php?msg=sucess"); } ?>
Success! Data Deleted Sucessfully.
Success! Data Updated Sucessfully.
query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; while ($rowsss = mysql_fetch_array($namesss)) { $from_hour=$rowsss['time_am']; $from_min=$rowsss['time_am_1']; $to_hour=$rowsss['time_pm']; $to_min=$rowsss['time_pm_1']; $from_hour=sprintf("%02d", $from_hour); $to_hour=sprintf("%02d", $to_hour); $from_min=sprintf("%02d", $from_min); $to_min=sprintf("%02d", $to_min); $date=$rowsss['visit_date']; $place=$rowsss['place']; $address=$rowsss['address']; $status=$rowsss['status']; /*$Query = "SELECT * from `tbl_job_email` where id='$invoice_id' "; $name=$DB->query($Query); $no=mysql_num_rows($name); $row = mysql_fetch_array($name);*/ ?>
S.No Date Place Address From To Status Edit
: : In Active Active