insert( $wpdb->prefix.'apt_category', array('name' => $category_name, 'icon' => $category_icon,)); } //fetch Category $ap_fetch_cat = $wpdb->get_results("select * from $wpdb->prefix"."apt_category"); if(isset($_REQUEST['cat_id'])) { $del = sanitize_text_field($_REQUEST['cat_id']); $wpdb->delete( $wpdb->prefix.'apt_category', array( 'id' => $del ) ); $wpdb->delete( $wpdb->prefix.'apt_services', array( 'category' => $del ) ); } $ap_staff_name=$wpdb->get_results("select * from $wpdb->prefix"."apt_staff"); $ap_fetch_service=$wpdb->get_results("select * from $wpdb->prefix"."apt_services"); //add service if(isset($_REQUEST['s_name'])) { $s_name=sanitize_text_field($_REQUEST['s_name']); $ap_service_icon=sanitize_text_field($_REQUEST['ap_service_icon']); $ap_ser_bg_color=sanitize_text_field($_REQUEST['ap_ser_bg_color']); $duration=sanitize_text_field($_REQUEST['duration']); $padding_before=sanitize_text_field($_REQUEST['padding_before']); $padding_after=sanitize_text_field($_REQUEST['padding_after']); $service_type="paid_service"; if($service_type=='free_service'){ $price_1 = "0.00"; } else { $price_1=sanitize_text_field($_REQUEST['price_1']); } $capacity_1=sanitize_text_field($_REQUEST['capacity_1']); $category_id=sanitize_text_field($_REQUEST['category_id']); $a_info=sanitize_text_field($_REQUEST['a_info']); $wpdb->insert( $wpdb->prefix.'apt_services', array('name' => $s_name,'icon' => $ap_service_icon,'color' => $ap_ser_bg_color,'duration' => $duration,'p_before' => $padding_before,'p_after' => $padding_after, 'service_type' => $service_type,'price' => $price_1,'capacity' => $capacity_1,'category' => $category_id,'info_message' => $a_info,) ); $wpdb->show_errors(); $wpdb->print_error(); } //update service if(isset($_REQUEST['u_s_name'])) { $service_id=sanitize_text_field($_REQUEST['service_id']); $u_s_name=sanitize_text_field($_REQUEST['u_s_name']); $update_icon_ser=sanitize_text_field($_REQUEST['update_icon_ser']); $u_cal_bg_color=sanitize_text_field($_REQUEST['u_cal_bg_color']); $u_s_duration=sanitize_text_field($_REQUEST['u_s_duration']); $u_padding_before=sanitize_text_field($_REQUEST['u_padding_before']); $u_padding_after=sanitize_text_field($_REQUEST['u_padding_after']); $u_service_type ="paid_service"; if($u_service_type=='free_service'){ $u_price = "0.00"; } else { $u_price=sanitize_text_field($_REQUEST['u_price']); } $u_capacity=sanitize_text_field($_REQUEST['u_capacity']); $u_category_id=sanitize_text_field($_REQUEST['u_category_id']); $u_a_info=sanitize_text_field($_REQUEST['u_a_info']); $wpdb->update( $wpdb->prefix.'apt_services', array('name' => $u_s_name,'icon' => $update_icon_ser,'color' => $u_cal_bg_color,'duration' => $u_s_duration,'p_before' => $u_padding_before,'p_after' => $u_padding_after,'service_type' => $u_service_type, 'price' => $u_price,'capacity' => $u_capacity,'category' => $u_category_id,'info_message' => $u_a_info),array('id'=>$service_id) ); $wpdb->show_errors(); $wpdb->print_error(); } // multi service delete if(isset($_REQUEST['service_delete'])) { $id_array = sanitize_text_field($_REQUEST['service_delete']); $arr = explode(',',$id_array); echo $id_count = count($arr); for($i=0;$i<=$id_count;$i++) { $del=$arr[$i]; $wpdb->delete( $wpdb->prefix.'apt_services', array( 'id' =>$del ) ); $wpdb->show_errors(); $wpdb->print_error(); } } if(isset($_REQUEST['u_category_name'])) { $category_name = sanitize_text_field($_REQUEST['u_category_name']); $category_icon = sanitize_text_field($_REQUEST['u_category_icon']); $update_cate_value = sanitize_text_field($_REQUEST['update_cate_value']); $wpdb->update( $wpdb->prefix.'apt_category', array('name' => $category_name, 'icon' => $category_icon,),array('id'=>$update_cate_value) ); } ?>
id; ?>