prefix . "ap_service_category"; $ServiceCategory = $wpdb->get_results($wpdb->prepare("SELECT * FROM `$ServiceCategoryTable` where id > %d",null)); foreach($ServiceCategory as $GroupName) { ?> prefix . "ap_services"; $ServiceDetails = $wpdb->get_results($wpdb->prepare("SELECT * FROM `$ServiceTable` WHERE `category_id` = %s ",$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 = sanitize_text_field( $_POST['gruopname'] ); $wpdb->query($wpdb->prepare("INSERT INTO `$ServiceCategoryTable` ( `name` ) VALUES (%s);",$groupename)); echo ""; echo ""; } // update service category if(isset($_POST['editgruop'])) { $update_id = intval( $_POST['editgruop'] ); $update_name = sanitize_text_field( $_POST['editgruopname'] ); $tt = !is_numeric($update_name); if($update_name) { if(!is_numeric($update_name)) { $wpdb->query($wpdb->prepare("UPDATE `$ServiceCategoryTable` SET `name` = '$update_name' WHERE `id` =%s;",$update_id)); echo ""; } else { echo ""; } } else { echo ""; } } // Delete service category if(isset($_GET['gid'])) { $DeleteId = intval( $_GET['gid'] ); $wpdb->query($wpdb->prepare("DELETE FROM `$ServiceCategoryTable` WHERE `id` = %s;",$DeleteId)); //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 = intval( $_GET['sid'] ); $wpdb->query($wpdb->prepare("DELETE FROM `$ServiceTable` WHERE `id` = %s;",$DeleteId)); echo ""; echo ""; } ?>