session_start(); date_default_timezone_set('Asia/Kolkata'); $datemal = date_default_timezone_set('Asia/Kolkata'); $dt2=date('Y-m-d H:i:s'); $browsessionid=$_REQUEST['confirm_id']; $login_12 = "SELECT * from tbl_appointment WHERE order_id!= '' "; $resqry_12 = mysql_query($login_12) or die("ERROR:".mysql_error()); $numrows_12 = mysql_num_rows($resqry_12); $tot_order_id=($numrows_12+1); $login = "SELECT * from tbl_appointment WHERE session_id= '$browsessionid' "; $resqry = mysql_query($login) or die("ERROR:".mysql_error()); $numrows = mysql_num_rows($resqry); $Fetcorderid = mysql_fetch_array($resqry); $mailcopy=$Fetcorderid ['email_id']; $date=$rowsss['date']; $me_id=$Fetcorderid['mem_id']; $order_id=$Fetcorderid['id']; $ap_date= $Fetcorderid['appointment_date']; $consulting_for= $Fetcorderid['consulting_for']; $ap_hour= sprintf("%02d",$Fetcorderid['hour_date']); $ap_min= sprintf("%02d",$Fetcorderid['min_date']); $ap_sec= $Fetcorderid['am_date']; $amount= $Fetcorderid['amount']; $Query = "SELECT * from `tbl_member` where id='$me_id' "; $name = mysql_query($Query) or die("ERROR:".mysql_error()); $no=mysql_num_rows($name); $row = mysql_fetch_array($name); $firstname= $row['name']; $country= $row['country']; $mobss= $row['phone']; $language= $row['language']; $age= $row['dob']; $skypeid=$row['skypeid']; sprintf("%02d", $to_hour); $new_email=$row['email']; $Query_user = "SELECT * from `shop_user` where email='$new_email' "; $name_user = mysql_query($Query_user) or die("ERROR:".mysql_error()); $no_user=mysql_num_rows($name_user); $row_user = mysql_fetch_array($name_user); $user_address =$row_user['address']; $user_city=$row_user['city']; $user_state=$row_user['state']; $user_postcode=$row_user['postcode']; $user_country= $row_user['country']; //$Updatecart = mysql_query("UPDATE tbl_appointment SET `status`='1' WHERE `session_id`='$browsessionid' and status='0' "); if($numrows>0) { $Updatecart = mysql_query("UPDATE tbl_appointment SET `status`='1',`session_id`='',`added_date`='$dt2',`order_id`='$tot_order_id' WHERE `session_id`='$browsessionid' and status='0' "); /* -----------------------------------*/ $message = "Hi ".$firstname." your video consultation with Dr.ANBUGANAPATHI on ".$ap_date." at ".$ap_hour.":".$ap_min.":".$ap_sec." is booked. Call 9884382200 ten mins before your timing. ANBUDR"; //enter Your Message $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'; $Msg5 = '
|
|
Online Consultation Receipt | |||||||||||
ENERGY Foods #11,2nd Street, Radha Nagar Extn. Velachery,Chennai 600 042. State :Tamilnadu Code:33 Phone:044-2253 1316 Email : drganbuganapathi@gmail.com Website : www.drganbuganapathi.com |
GSTIN:33ACMPA1286A2Z7 PAN:ACMPA1286A Receipt No : OC-'.$tot_order_id.' Payment Mode-Payumoney |
Name:'.$firstname.' | Phone:'.$mobss.' | Age:'.$age.' | Date:'.$ap_date.' |
Consulting For:'.$consulting_for.' | Country:'.$country.' | Speak:'.$language.' | Time:'.$ap_hour.':'.$ap_min.''.$ap_sec.' |
Address: '.$user_address.' '.$user_city.' '.$user_state.'-'.$user_postcode.'.'.$user_country.' |
Fees:'.$amount.' |
Your appointment has been confirmed and be ready 5 mins prior to the appointment timing