Available Service:
Select Service
prefix . "services"; $res=$wpdb->get_results("select * From $table_name"); if($res == NULL) { echo '
No services, Create service first !!!
'; } else { foreach($res as $r) { echo '
'.$r->service_name.'
'; } } ?>
Booking Date:
Available Time For On: prefix . "services"; $ser=$wpdb->get_row("select * From $table_name where service_name = '$service_name'"); $slots = $ser->service_durationvalue; $table_name = $wpdb->prefix . "calendar_setting"; $res=$wpdb->get_row("select * From $table_name where cs_id = '1'"); $st = $res->day_start_time; $st = $st.":00:00"; $et = $res->day_end_time; $et = $et.":00:00"; $slots = $slots." minute"; $t1 = strtotime($st); $t2 = strtotime($et); $timeslots = array(); $secondslot = "-".$slots; $t1 = strtotime($secondslot, $t1); while ($t1 < $t2) { $t1 = strtotime($slots, $t1); $timeslots[] = date('H:iA', $t1); } ?>
prefix . "booked_appointments"; $block = $wpdb->get_results("SELECT * FROM $table_name WHERE `bk_ap_stdate` LIKE '$today'"); $today_time_slots = array(); foreach($block as $blk) { $today_time_slots[] = $blk->bk_ap_sttime; } $t = count($timeslots); $t=$t-1; $i=1; foreach ( $timeslots as $slot ) { if($i<=$t) { $flag = 'false'; foreach($today_time_slots as $tts) { if($tts == $slot) { $flag = 'ture'; } } if($flag == 'ture') { ?>
"; ?>
"; ?>
Name:
E-mail:
Cell Number:
Description: