> > > > > >   ">

prefix . "ap_appointments"; $sql = "SELECT * FROM `$table_name` WHERE `date` ='$filterappointments'"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $all_appointments = $pager->paginate(); } else { $filterappointments =$filterdata; $table_name = $wpdb->prefix . "ap_appointments"; $sql = "SELECT * FROM `$table_name` WHERE `status` ='$filterappointments'"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $all_appointments = $pager->paginate(); } if($filterdata =='All') { $table_name = $wpdb->prefix . "ap_appointments"; $sql = "SELECT * FROM `$table_name`"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $all_appointments = $pager->paginate(); } } else { // wordpress database user name and password $table_name = $wpdb->prefix . "ap_appointments"; $sql = "SELECT * FROM `$table_name`"; $pager = new PS_Pagination($conn, $sql, 10); $pager->setDebug(true); $all_appointments = $pager->paginate(); } ?>

							" >
				prefix . "ap_services"; $servicedetails = $wpdb->get_row("SELECT * FROM $table_name WHERE `id` ='$apppid'"); if($servicedetails) { echo ucfirst($servicedetails->name);} ?>		" rel="tooltip">   " rel="tooltip">  " onclick="return confirm('')">	">
renderFullNav(); ?>							')">

prefix . "ap_appointments"; $delete_app_query = "DELETE FROM `$table_name` WHERE `id` = '$deleteid';"; $wpdb->query($delete_app_query); echo ""; } // delete all selected appointment with ckeckbox if(isset($_POST['deleteall'])) { $table_name = $wpdb->prefix . "ap_appointments"; for($i=0;$i<=count($_POST['checkbox'])-1;$i++) { $res=$_POST['checkbox'][$i]; $deleteid= $res; $delete_app_query="DELETE FROM `$table_name` WHERE `id` = '$deleteid';"; $wpdb->query($delete_app_query); echo ""; } } ?>