>All Appointments >Pending Appointments >Apporved Appointments >Cancelled Appointments >Done Appointments >Today's Appointments  Filter Appointments

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(); } ?>

No.	Name	Date	Time	Service	Status	Action
				prefix . "ap_services"; $servicedetails= $wpdb->get_row("SELECT * FROM $table_name WHERE `id` ='$apppid'"); echo ucfirst($servicedetails->name); ?>
renderFullNav(); ?>							Delete
Sorry no appointments

prefix . "ap_appointments"; $delete_app_query="DELETE FROM `$table_name` WHERE `id` = '$deleteid';"; //$wpdb->query($delete_app_query); echo ""; } /********************Delete all 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); } } ?>