Appointment Calendar
.'/appointment-calendar/tooltip/help.png'; ?> "View and Create booking. Drag over calendar to create booking/event.")
prefix . "calendar_event";
if($event_add_flag =="true")
{
$insert_event = "INSERT INTO $table_name (
`ev_id` ,
`ev_title` ,
`ev_start_time` ,
`ev_end_time` ,
`ev_start_date` ,
`ev_end_date` ,
`ev_desc`
)
VALUES (
'', '$ev_title', '$ev_st', '$ev_et', '$ev_start_date', '$ev_end_date', '$ev_desc'
);
";
$wpdb->query($insert_event);
}
}
?>
prefix . "booked_appointments";
if($app_add_flag == "true")
{
$insert_booking = "INSERT INTO $table_name (
`bk_ap_id` ,
`bk_ap_name` ,
`bk_ap_email` ,
`bk_ap_service` ,
`bk_ap_cellno` ,
`bk_ap_sttime` ,
`bk_ap_edtime` ,
`bk_ap_stdate` ,
`bk_ap_eddate` ,
`bk_ap_desc`
)
VALUES (
NULL , '$name', '$email', '$service', '$cellno', '$sttm', '$edtm', '$stdt', '$eddt', '$desc'
);";
//echo "here";
$wpdb->query($insert_booking);
}
}
?>
prefix . "calendar_event";
$x = $wpdb->get_results("select * from $table_name");
foreach( $x as $xx)
{
$xtitle[] = $xx->ev_title;
$xst[] = $xx->ev_start_time;
$xet[] = $xx->ev_end_time;
}
?>