prefix . "ap_service_category"; $service_category = $wpdb->get_results("SELECT * FROM `$table_name`"); foreach($service_category as $gruopname) {?> prefix . "ap_services"; $servicedetails= $wpdb->get_results("SELECT * FROM `$table_name` WHERE `category_id` = '$gruopname->id' "); foreach($servicedetails as $service) { ?>

name); ?>			id =='1') ?> "> id !='1') { ?> | ')" title="">
name); ?>	desc); ?>	duration. " ".ucfirst($service->unit); ?>	cost; ?>	availability); ?>	">   ')" title="" >
">

prefix . "ap_service_category"; $service_category = "INSERT INTO $table_name ( `name` ) VALUES ('$groupename');"; $wpdb->query($service_category); echo ""; echo ""; } // update service category if(isset($_POST['editgruop'])) { $table_name = $wpdb->prefix . "ap_service_category"; $update_id = $_POST['editgruop']; $update_name = $_POST['editgruopname']; $tt = !is_numeric($update_name); if($update_name) { if(!is_numeric($update_name)) { $update_app_query = "UPDATE $table_name SET `name` = '$update_name' WHERE `id` ='$update_id';"; $wpdb->query($update_app_query); echo ""; } else { echo ""; } } else { echo ""; } } // Delete service category if(isset($_GET['gid'])) { $deleteid= $_GET['gid']; $table_name = $wpdb->prefix . "ap_service_category"; $delete_app_query="DELETE FROM $table_name WHERE `id` = '$deleteid';"; $wpdb->query($delete_app_query); //update all service category id $table_name = $wpdb->prefix . "ap_services"; $update_app_query_service = "UPDATE $table_name SET `category_id` = '1' WHERE `category_id` ='$deleteid';"; $wpdb->query($update_app_query_service); // update category echo ""; echo ""; } // Delete service if(isset($_GET['sid'])) { $deletesid= $_GET['sid']; $table_name = $wpdb->prefix . "ap_services"; $delete_app_query="DELETE FROM $table_name WHERE `id` = '$deletesid';"; $wpdb->query($delete_app_query); echo ""; echo ""; }?>