Booking Managment

"; global $wpdb; $table_name = $wpdb->prefix . "booked_appointments"; $event = $wpdb->get_results("select * from $table_name"); $row=1; ?>
bk_ap_status == $status ) { ?>
No. Name Description Email Cell-Phone Service Start-Time End-Time Date Status Edit  
bk_ap_name; ?> bk_ap_desc; ?> bk_ap_email; ?> bk_ap_cellno; ?> bk_ap_service; ?> bk_ap_sttime; ?> bk_ap_edtime; ?> bk_ap_stdate; ?> bk_ap_status; ?> bk_ap_id;;?> Edit
bk_ap_name; ?> bk_ap_desc; ?> bk_ap_email; ?> bk_ap_cellno; ?> bk_ap_service; ?> bk_ap_sttime; ?> bk_ap_edtime; ?> bk_ap_stdate; ?> bk_ap_status; ?>
bk_ap_name; ?> bk_ap_desc; ?> bk_ap_email; ?> bk_ap_cellno; ?> bk_ap_service; ?> bk_ap_sttime; ?> bk_ap_edtime; ?> bk_ap_stdate; ?> bk_ap_status; ?> bk_ap_id;;?> Edit
                 
prefix . "booked_appointments"; $data = $wpdb->get_row("select * from $table_name where bk_ap_id = '$grab_id'"); ?> prefix . "services"; $ser = $wpdb->get_results("select * from $table_name"); ?>
Fields   Values
Name :
Email :
Sevice :
Cell Number :
Start Time : bk_ap_sttime; ?>
End Time : bk_ap_edtime; ?>
Date :
Descritpion :
Status :
   
prefix . "booked_appointments"; $count = count($_POST['ap_id']); for($i=0;$i<$count;$i++) { $update_id = $_POST['ap_id'][$i]; //$delete_query = "Update FROM $table_name WHERE bk_ap_id='$dele_id'"; $update_app_query = "UPDATE $table_name SET `bk_ap_status` = 'cancelled' WHERE `bk_ap_id` ='$update_id';"; $wpdb->query($update_app_query); } $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']; echo ''; } // Approved Booking List if($_POST['approve_app']) { global $wpdb; $table_name = $wpdb->prefix . "booked_appointments"; $count = count($_POST['ap_id']); for($i=0;$i<$count;$i++) { $update_id = $_POST['ap_id'][$i]; //$delete_query = "Update FROM $table_name WHERE bk_ap_id='$dele_id'"; $update_app_query = "UPDATE $table_name SET `bk_ap_status` = 'approved' WHERE `bk_ap_id` ='$update_id';"; $wpdb->query($update_app_query); } $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']; echo ''; } // Delete Cancel Appointment if($_POST['delete_app']) { global $wpdb; $table_name = $wpdb->prefix . "booked_appointments"; $count = count($_POST['ap_id']); for($i=0;$i<$count;$i++) { $delete_id = $_POST['ap_id'][$i]; //$delete_query = "Update FROM $table_name WHERE bk_ap_id='$dele_id'"; $delete_app_query = "DELETE FROM $table_name WHERE `bk_ap_id` = '$delete_id'"; $wpdb->query($delete_app_query); } $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']; echo ''; } // Update Booking List if(isset($_POST['update_booking'])) { print_r($_POST); $up_id = $_POST['up_id']; $bk_ap_name = $_POST['pname']; $bk_ap_email = $_POST['pemail']; $bk_ap_service = $_POST['pservice']; $bk_ap_cellno = $_POST['pcellno']; $bk_ap_sttime = $_POST['pst']; $bk_ap_edtime = $_POST['pet']; $bk_ap_stdate = $_POST['pdate']; $bk_ap_eddate = $_POST['pdate']; $bk_ap_desc = $_POST['pdesc']; $bk_ap_status = $_POST['pstatus']; global $wpdb; $table_name = $wpdb->prefix . "booked_appointments"; $update_app_query = "UPDATE $table_name SET `bk_ap_name` = '$bk_ap_name', `bk_ap_email` = '$bk_ap_email', `bk_ap_cellno` = '$bk_ap_cellno', `bk_ap_service` = '$bk_ap_service', `bk_ap_sttime` = '$bk_ap_sttime', `bk_ap_edtime` = '$bk_ap_edtime', `bk_ap_stdate` = '$bk_ap_stdate', `bk_ap_eddate` = '$bk_ap_eddate', `bk_ap_desc` = '$bk_ap_desc', `bk_ap_status` = '$bk_ap_status' WHERE `bk_ap_id` ='$up_id'"; $wpdb->query($update_app_query); $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']."&edit_appointment=NULL"; echo ''; } if($_POST['Cancel_app']) { $c_url = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI']."&edit_appointment=NULL"; echo ''; } ?>