query($Query); //$ids=$_REQUEST['ids']; header("location:appointment_details.php"); //$cour="courier_status".$v_id_order.""; //header("location:view_order.php?ids=15"); } ?> query($Query); $date_ss = date('Y-m-d H:i:s ', time()); //$ids=$_REQUEST['ids']; header("location:appointment_details.php"); //$cour="courier_status".$v_id_order.""; //header("location:view_order.php?ids=15"); } ?> query($Query); $Query_m = "SELECT * from tbl_appointment where id='".$_REQUEST['id']."' "; $namesss_m=$DB->query($Query_m); $rowsss_m = mysql_fetch_array($namesss_m); $email_id=$rowsss_m['email_id']; $mailcopy=$rowsss_m['email_id']; $date=$rowsss['date']; $me_id=$rowsss_m['mem_id']; $order_id=$rowsss_m['id']; $ap_date= $rowsss_m['appointment_date']; $ap_hour= sprintf("%02d",$rowsss_m['hour_date']); $ap_min= sprintf("%02d",$rowsss_m['min_date']); $ap_sec= $rowsss_m['am_date']; $Query_m_a = "SELECT * from `tbl_member` where id='$me_id' "; $namesss_m_a=$DB->query($Query_m_a); $no_m_a=mysql_num_rows($namesss_m_a); $row_m_a = mysql_fetch_array($namesss_m_a); $firstname= $row_m_a['name']; $skypeid=$row_m_a['skypeid']; $mobss= $row_m_a['phone']; sprintf("%02d", $to_hour); /* -----------------------------------*/ $message = "Hi ".$firstname." your appointment with Dr. G.ANBUGANAPATHI on ".$ap_date." ".$ap_hour.":".$ap_min.":".$ap_sec." is Cancelled.Sorry For the inconvenience."; //enter Your Message $curl = curl_init(); $message = urlencode($message); $curl = curl_init(); curl_setopt_array($curl, array( CURLOPT_URL => 'http://sms.dial4sms.com/api/v2/SendSMS?SenderId=DRANBU&Message='.$message.'&MobileNumbers='.$mobss.'&ApiKey=eYfIWFmiAMhbL6JDTfOb3kzGzQr+eimy6prshuD8qLo=&ClientId=b45d4e3d-cb26-4856-8cbf-93a02a7b9eeb', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', )); $response = curl_exec($curl); curl_close($curl); //$mobilenumbers1='$res_owner_mobile'; $Msg1 = '
Dr. G.ANBUGANAPATHI
Cancelled Appointment Details
Hi '.$firstname.' your appointment with Dr. G.ANBUGANAPATHI on '.$ap_date.' '.$ap_hour.':'.$ap_min.':'.$ap_sec.'(Indian Standard Time (IST)) is Cancelled.Sorry For the inconvenience.
* Consultation fees will be refunded with in 3-4 bank working days.
Thanks & Regards
Dr. G.ANBUGANAPATHI
Copyright © 2020 - dranbuganapathi.com, All Rights Reserved.
'; $job_name14357="Appointment Cancellation in Dr. G.ANBUGANAPATHI"; $Subjectnew123 = "$job_name14357-$order_id"; $Subject1="Appointment Cancellation in Dr. G.ANBUGANAPATHI"; //echo $mailformat; //$mailheaders = "Content-type: text/html; charset=iso-8859-1\r\n"; $useremail="drganbuganapathi@gmail.com"; $headers1 = "From: dranbuganapathi.com\r\n"."Content-Type: text/html; charset=iso-8859-1\r\n"; $Msg1; //@mail($useremail,$Subjectnew123,$Msg1,$headers1); @mail($mailcopy,$Subject1,$Msg1,$headers1); //$Delete_Question = "DELETE FROM tbl_appointment WHERE `id`='$id'"; //$Result_Question = mysql_query($Delete_Question); ////$Query_delete = "DELETE from tbl_appointment where id='$id'"; //$name_delete=$DB->query($Query_delete); header("location:appointment_details.php?msg=sucess"); } ?>

Doctor Availability

  1. Doctor Availability
  2. Appointment Details
Success! Data Deleted Sucessfully.
= CURDATE() order by appointment_date asc "; $Query = "SELECT * from tbl_appointment where status='1' and appointment_date >= CURDATE() order by appointment_date asc "; $namesss=$DB->query($Query); $nsssss=mysql_num_rows($namesss); $manssss='0'; while ($rowsss = mysql_fetch_array($namesss)) { $pundai_order_id=$rowsss['id']; $date=$rowsss['date']; $me_id=$rowsss['mem_id']; $status=$rowsss['status']; $des=$rowsss['des']; $docname=$rowsss['document_name']; $document_name=$rowsss['document_name']; $Query = "SELECT * from `tbl_member` where id='$me_id' "; $name=$DB->query($Query); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $skypeid=$row['skypeid']; $men_country=$row['country']; sprintf("%02d", $to_hour); $docname=$rowsss['document_name']; $new_email=$row['phone']; $Query_user = "SELECT * from `shop_user` where phone='$new_email' "; $name_user=$DB->query($Query_user); $no_user=mysql_num_rows($name_user); $row_user = mysql_fetch_array($name_user); $cur_1_dt2=date('Y-m-d'); $new_appointment_date=$rowsss['appointment_date']; $country=$row_user['country']; $Query_c= "SELECT * from `shop_country` where name='$country' "; $name_c=$DB->query($Query_c); $row_c = mysql_fetch_array($name_c); $veh=$rowsss['vehicle']; $aaaaaaaa=$rowsss['amount']; ?> style=" color:#0000FF;" > = '2021-12-17' order by appointment_date,hour_date,min_date asc "); //$Query_job_move_free_job = mysql_query("SELECT * from shop_product where stock_status_id='0' order by product_id desc "); $nsssss=mysql_num_rows($Query_job_move_free_job); $qty=1; $si=0; while($row_job_move_free_job = mysql_fetch_array($Query_job_move_free_job)) { $pundai_order_id=$row_job_move_free_job['id']; $pun_id=$row_job_move_free_job['mem_id']; $cur_1_dt2_man=date('Y-m-d'); $new_appointment_date_man=$row_job_move_free_job['appointment_date']; $Query_pu = mysql_query("SELECT * from tbl_staff where 1=1 and id='$pun_id' "); $row_pu = mysql_fetch_array($Query_pu); $num_padded = sprintf("%02d", $day); $nnnn_year=$row_job_move_free_job['appointment_date']; $tod_day = $nnnn_year; $n_t_d=strtotime($tod_day); $from_hour=$row_job_move_free_job['hour_date']; $from_hour_1 = sprintf("%02d", $from_hour); $from_min=$row_job_move_free_job['min_date']; $from_min_1 = sprintf("%02d", $from_min); $from_sta=$row_job_move_free_job['am_date']; $new_time_ma = ''.$from_hour_1.':'.$from_min_1.' '.$from_sta.''; $new_time_ma_1=strtotime($new_time_ma); $id=$new_time_ma_1; $m_id=$n_t_d; $veh=$row_job_move_free_job['razid']; ?> style=" color:#0000FF;" >
S.No Receipt No Name Booked Date Mobile No Appointment Date City Problem Reports Details Status
OC- ( ) ( ) () : USA Rs3500
Direct ( ) () :
10GB of 250GB Free.
Copyright dranbuganapathi.com © 2019-2020