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'] ) && isset( $_POST['form_holiday_update_nonce'] ) ) {
if ( ! wp_verify_nonce( $_POST['form_holiday_update_nonce'], 'form_holiday_update_nonce' ) ) {
die();
}
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'] );
$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 = sanitize_text_field( $_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();
}
}
?>