query($Query_delete);
//header("location:appointment_details.php?msg=sucess");
}
?>
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'];
$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'];
sprintf("%02d", $to_hour);
$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 Confirmation 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";
//$nsssss_m=mysql_num_rows($namesss_m);
//header("location:appointment_details.php?msg1=sucess");
}
?>
Success! Data Deleted Sucessfully.
query($Query);
$nsssss=mysql_num_rows($namesss);
$manssss='0';
$rowsss = mysql_fetch_array($namesss);
$date=$rowsss['date'];
$me_id=$rowsss['mem_id'];
$id_kum=$rowsss['id'];
$id_kum_1=$rowsss['order_id'];
$status=$rowsss['status'];
$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'];
sprintf("%02d", $to_hour);
$docname=$rowsss['document_name'];
$new_email=$row['email'];
$new_phone=$row['phone'];
$Query_user = "SELECT * from `shop_user` where phone='$new_phone' ";
$name_user=$DB->query($Query_user);
$no_user=mysql_num_rows($name_user);
$row_user = mysql_fetch_array($name_user);
?>