insert($wpdb->prefix.'apt_holidays',array('all_off' => $allday,'name' =>$name,'start_time' => $start_time,'end_time' => $end_time,'holiday_date' => $event_date,'repeat_value' => $repeat,'repeat_days' => $re_days,'repeat_weeks' => $re_weeks,'repeat_bi_weeks' => $re_biweeks,'repeat_month' => $re_months,'start_date' => $start_date,'end_date' => $end_date,'notes' =>$note,));
}
if(isset($_REQUEST['name_update'])) {
if(isset($_REQUEST['allday_update'])) {$allday_update=sanitize_text_field($_REQUEST['allday_update']); } else { $allday_update="0"; }
$update_holiday_value=sanitize_text_field($_REQUEST['update_holiday_value']);
//$allday_update=sanitize_text_field($_REQUEST['allday_update']);
$name_update=sanitize_text_field($_REQUEST['name_update']);
$start_time_update=sanitize_text_field($_REQUEST['start_time_update']);
$end_time_update=sanitize_text_field($_REQUEST['end_time_update']);
$event_date_update=sanitize_text_field($_REQUEST['event_date_update']);
$repeat_update=sanitize_text_field($_REQUEST['repeat_update']);
$re_days_update=sanitize_text_field($_REQUEST['re_days_update']);
$re_weeks_update=sanitize_text_field($_REQUEST['re_weeks_update']);
$re_biweeks_update=sanitize_text_field($_REQUEST['re_biweeks_update']);
$re_months_update=sanitize_text_field($_REQUEST['re_months_update']);
$start_date_update=sanitize_text_field($_REQUEST['start_date_update']);
$end_date_update=sanitize_text_field($_REQUEST['end_date_update']);
$note_update=sanitize_text_field($_REQUEST['note_update']);
$wpdb->update($wpdb->prefix.'apt_holidays',array('all_off' => $allday_update,'name' =>$name_update,'start_time' => $start_time_update,'end_time' => $end_time_update,'holiday_date' => $event_date_update,'repeat_value' => $repeat_update,'repeat_days' => $re_days_update,'repeat_weeks' => $re_weeks_update,'repeat_bi_weeks' => $re_biweeks_update,'repeat_month' => $re_months_update,'start_date' => $start_date_update,'end_date' => $end_date_update,'notes' =>$note_update,),array('id'=>$update_holiday_value));
$wpdb->show_errors();
$wpdb->print_error();
}
//single delete
if(isset($_REQUEST['holiday_id'])) {
$del=$_REQUEST['holiday_id'];
$wpdb->delete( $wpdb->prefix.'apt_holidays', array( 'id' => $del ));
}
// multi delete
if(isset($_REQUEST['id'])) {
$id_array =sanitize_text_field($_REQUEST['id']);
$arr=explode(',',$id_array);
echo $id_count = count($arr);
for($i=0;$i<=$id_count;$i++) {
$del=$arr[$i];
$wpdb->delete( $wpdb->prefix.'apt_holidays', array( 'id' =>$del ) );
$wpdb->show_errors();
$wpdb->print_error();
}
}
?>