prefix . "ap_appointments"; $insert_appointment = "INSERT INTO $table_name ( `id` , `name` , `email` , `service_id` , `phone` , `start_time` , `end_time` , `date` , `note` , `appointment_key` , `status` , `appointment_by` ) VALUES (NULL , '$name', '$email', '$serviceid', '$phone', '$start_time', '$end_time', '$appointmentdate', '$note', '$appointment_key', '$status', '$appointment_by');"; if($wpdb->query($insert_appointment)) { $MangeAppointmentUrl = site_url().'/wp-admin/admin.php?page=manage-appointments'; $BlogUrl = site_url().'/wp-admin'; $BlogName = get_bloginfo(); $ServiceTable = $wpdb->prefix."ap_services"; $ServiceData = $wpdb->get_row("SELECT * FROM `$ServiceTable` WHERE `id` = '$serviceid'", OBJECT); $subject_to_recipent = "$BlogName: Your Appointment Confirmation Mail."; $body_for_recipent = "

Dear ".ucwords($name).".

Thank you for scheduling appointment with $BlogName.

Your Appointment Details As:

---

Appointment For: ".ucwords($ServiceData->name)."
Appointment Note: $note
Appointment Status: Pending
Appointment Date: $appointmentdate
Appointment Time: $start_time To $end_time
Appointment Key: $appointment_key

---

Your appointment will be appove by admin. And approval mail will be sent to you soon.

Thank You!!!

"; $AdminEmailDetails = unserialize(get_option('emaildetails')); $recipent_email = $email; //send notification & chech mail type if(get_option('emailtype') == 'wpmail') { $wpmail_body_for_recipent = " Dear ".ucwords($name).", Thank you for scheduling appointment with $BlogName. Your Appointment Details As: Appointment For: ".ucwords($ServiceData->name)." Appointment Note: $note Appointment Status: Pending Appointment Date: $appointmentdate Appointment Time: $start_time To $end_time Appointment Key: $appointment_key Your appointment will be appove by admin. And approval mail will be sent to you soon. Thank You!!! "; $admin_email = $AdminEmailDetails['wpemail']; $headers[] = "From: Admin <$admin_email>"; //recipent mail wp_mail( $recipent_email, $subject_to_recipent, $wpmail_body_for_recipent, $headers, $attachments = '' ); } if(get_option('emailtype') == 'phpmail') { $phpmail_body_for_recipent = " Dear ".ucwords($name).", Thank you for scheduling appointment with $BlogName. Your Appointment Details As: Appointment For: ".ucwords($ServiceData->name)." Appointment Note: $note Appointment Status: Pending Appointment Date: $appointmentdate Appointment Time: $start_time To $end_time Appointment Key: $appointment_key Your appointment will be appove by admin. And approval mail will be sent to you soon. Thank You!!! "; $admin_email = $AdminEmailDetails['phpemail']; $headers = "From: Admin <$admin_email>" . //client mail mail($recipent_email, $subject_to_recipent, $phpmail_body_for_recipent, $headers); } if(get_option('emailtype') == 'smtp') { $admin_email = $AdminEmailDetails['smtpemail']; include('notification/Email.php'); $admin_email = $AdminEmailDetails['smtpemail']; $hostname = $AdminEmailDetails['hostname']; $portno = $AdminEmailDetails['portno']; $smtpemail = $AdminEmailDetails['smtpemail']; $password = $AdminEmailDetails['password']; $recipent_email = $email; $Email = new Email; $Email->notifyclient($hostname, $portno, $smtpemail, $password, $admin_email, $recipent_email, $subject_to_recipent, $body_for_recipent, $BlogName); } } ?>