' /> ' /> ' /> ' /> ' />

Time Off

prefix."ap_events"; $FindAllevents = "SELECT * FROM `$EeventTable`"; $AllEvents = $wpdb->get_results($FindAllevents, OBJECT); $no = 1; if($AllEvents) { foreach($AllEvents as $Event) { ?>
No. Name Date Time Total Day(s) Status Action
name; ?> start_date))." To ".date("jS M. Y", strtotime($Event->end_date)); ?> start_time." To ".$Event->end_time; ?> end_date) - strtotime($Event->start_date) ) /60/60/24; if($diff > 0) { echo ($diff)." Days(s) Event"; } else { echo "1 Day(s) Event"; } ?> end_date") < strtotime(date('Y-m-d'))) { echo "Gone"; } else { $diff = ( strtotime($Event->end_date) - strtotime($Event->start_date) ) /60/60/24; if($diff == 0) { echo "Running"; } else if($diff > 0) { echo "Up-Comming"; } } ?>  
         
prefix."ap_events"; $eventinsert_sql = "INSERT INTO `$EeventTable` ( `id` , `name` , `allday` , `start_time` , `end_time` , `repeat` , `start_date` , `end_date` , `note` , `status` ) VALUES ( NULL , '$name', '$allday', '$start_time', '$end_time', '$repeat', '$start_date', '$end_date', '$note', '$status');"; if($wpdb->query($eventinsert_sql)) echo ""; else echo ""; } ?> prefix."ap_events"; $del_id = $_GET['delete_timeoff']; $timeoffdelete_sql = "delete from `$EeventTable` where `id` = '$del_id'"; if($wpdb->query($timeoffdelete_sql)) echo ""; else echo ""; } ?>