prefix . "ap_service_category"; $ServiceCategory = $wpdb->get_results("SELECT * FROM `$ServiceCategoryTable`"); foreach($ServiceCategory as $GroupName) { ?> prefix . "ap_services"; $ServiceDetails = $wpdb->get_results("SELECT * FROM `$ServiceTable` WHERE `category_id` = '$GroupName->id' "); foreach($ServiceDetails as $Service) { ?>

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

prefix . "ap_service_category"; $ServiceTable = $wpdb->prefix . "ap_services"; if(isset($_POST['CreateGruop'])) { if( !wp_verify_nonce($_POST['appointment_add_cat_nonce_check'],'appointment_add_cat_nonce_check') ){ echo ''; return false; } global $wpdb; $groupename = $_POST['gruopname']; $ServiceCategory = "INSERT INTO `$ServiceCategoryTable` ( `name` ) VALUES ('$groupename');"; $wpdb->query($ServiceCategory); echo ""; echo ""; } // update service category if(isset($_POST['editgruop'])) { $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 `$ServiceCategoryTable` 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']; $DeleteServiceCategorySQl = "DELETE FROM `$ServiceCategoryTable` WHERE `id` = '$DeleteId';"; $wpdb->query($DeleteServiceCategorySQl); //update all service category id $UpdateServiceSQL = "UPDATE `$ServiceTable` SET `category_id` = '1' WHERE `category_id` ='$DeleteId';"; $wpdb->query($UpdateServiceSQL); // update category echo ""; echo ""; } // Delete service if(isset($_GET['sid'])) { $DeleteId = $_GET['sid']; $DeleteServiceSQL = "DELETE FROM `$ServiceTable` WHERE `id` = '$DeleteId';"; $wpdb->query($DeleteServiceSQL); echo ""; echo ""; } ?>