> > > > > >    ">

prefix . "ap_appointments"; if(isset($_POST['filter'])) { $FilterData = sanitize_text_field( $_POST['filtername'] ); if($FilterData == 'today') { $FilterAppointments = date('Y-m-d'); $sql = "SELECT * FROM `$AppointmentsTable` WHERE `date` = '$FilterAppointments'"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $AllAppointments = $pager->paginate(); } else { $FilterAppointments =$FilterData; $sql = "SELECT * FROM `$AppointmentsTable` WHERE `status` = '$FilterAppointments'"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $AllAppointments = $pager->paginate(); } if($FilterData == 'All') { $sql = "SELECT * FROM `$AppointmentsTable`"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $AllAppointments = $pager->paginate(); } } else { // WordPress database user name and password $sql = "SELECT * FROM `$AppointmentsTable`"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $AllAppointments = $pager->paginate(); } ?>

							" >
	()			prefix . "ap_services"; $Service = $wpdb->get_row($wpdb->prepare("SELECT * FROM `$ServiceTable` WHERE `id` = %s",$AppId)); if(count($Service)) { echo ucfirst($Service->name); } ?>		" rel="tooltip">  " rel="tooltip">  " onclick="return confirm('')">	">
renderFullNav(); ?>							')">

prefix . "ap_appointments"; $wpdb->query($wpdb->prepare("DELETE FROM `$AppointmentTable` WHERE `id` = %s;",$DeleteId)); echo ""; echo ""; } } // delete all selected appointment with checkbox if(isset($_POST['deleteall'])) { if(isset($_POST['checkbox'])) { $AppointmentTable = $wpdb->prefix . "ap_appointments"; for($i=0; $i<=count($_POST['checkbox'])-1; $i++) { $DeleteId = intval( $_POST['checkbox'][$i] ); $wpdb->query($wpdb->prepare("DELETE FROM `$AppointmentTable` WHERE `id` = %s;",$DeleteId)); } echo ""; echo ""; } else { echo ""; } } ?>