Business Hours

prefix . "business_hours"; //MONDAY $M_st = $_POST['MSselect']; $M_et = $_POST['MEselect']; $M_tt_sec = ($M_et - $M_st); //MONDAY $monday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '1', 'Monday', '$M_st', '$M_et', '$M_tt_sec');"; $wpdb->query($monday_query); //TUESDAY $T_st = $_POST['TSselect']; $T_et = $_POST['TEselect']; $T_tt_sec = ($T_et - $T_st); $tuesday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '2', 'Tuesday', '$T_st', '$T_et', '$T_tt_sec');"; $wpdb->query($tuesday_query); //WEDNESDAY $W_st = $_POST['WSselect']; $W_et = $_POST['WEselect']; $W_tt_sec = ($W_et - $W_st); $wednesday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '3', 'Wednesday', '$W_st', '$W_et', '$W_tt_sec');"; $wpdb->query($wednesday_query); //THURSDAY $TH_st = $_POST['THSselect']; $TH_et = $_POST['THEselect']; $TH_tt_sec = ($TH_et - $TH_st); $thursday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '4', 'Thursday', '$TH_st', '$TH_et', '$TH_tt_sec');"; $wpdb->query($thursday_query); //FRIDAY $F_st = $_POST['FSselect']; $F_et = $_POST['FEselect']; $F_tt_sec = ($F_et - $F_st); $friday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '5', 'Friday', '$F_st', '$F_et', '$F_tt_sec');"; $wpdb->query($friday_query); //SATURDAY $SA_st = $_POST['SASselect']; $SA_et = $_POST['SAEselect']; $SA_tt_sec = ($SA_et - $SA_st); $saturday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '6', 'Saturday', '$SA_st', '$SA_et', '$SA_tt_sec');"; $wpdb->query($saturday_query); //SUNDAY $SU_st = $_POST['SUSselect']; $SU_et = $_POST['SUEselect']; $SU_tt_sec = ($SU_et - $SU_st); $sunday_query ="INSERT INTO $table_name ( `bh_id`, `bh_days` , `bh_start_time` , `bh_end_time` , `bh_totaltime_seconds` ) VALUES ( '7', 'Sunday', '$SU_st', '$SU_et', '$SU_tt_sec');"; $wpdb->query($sunday_query); } ?> prefix . "business_hours"; //MONDAY $M_st = $_POST['MSselect']; $M_et = $_POST['MEselect']; $M_tt_sec = ($M_et - $M_st); $monday_query ="UPDATE $table_name SET `bh_start_time` = '$M_st', `bh_end_time` = '$M_et', `bh_totaltime_seconds` = '$M_tt_sec ' WHERE `bh_days` = 'Monday';"; $wpdb->query($monday_query); //TUESDAY $T_st = $_POST['TSselect']; $T_et = $_POST['TEselect']; $T_tt_sec = ($T_et - $T_st); $tuesday_query ="UPDATE $table_name SET `bh_start_time` = '$T_st', `bh_end_time` = '$T_et', `bh_totaltime_seconds` = '$T_tt_sec ' WHERE `bh_days` = 'Tuesday';"; $wpdb->query($tuesday_query); //WEDNESDAY $W_st = $_POST['WSselect']; $W_et = $_POST['WEselect']; $W_tt_sec = ($W_et - $W_st); $wednesday_query ="UPDATE $table_name SET `bh_start_time` = '$W_st', `bh_end_time` = '$W_et', `bh_totaltime_seconds` = '$W_tt_sec ' WHERE `bh_days` = 'Wednesday';"; $wpdb->query($wednesday_query); //THURSDAY $TH_st = $_POST['THSselect']; $TH_et = $_POST['THEselect']; $TH_tt_sec = ($TH_et - $TH_st); $thursday_query ="UPDATE $table_name SET `bh_start_time` = '$TH_st', `bh_end_time` = '$TH_et', `bh_totaltime_seconds` = '$TH_tt_sec ' WHERE `bh_days` = 'Thursday';"; $wpdb->query($thursday_query); //FRIDAY $F_st = $_POST['FSselect']; $F_et = $_POST['FEselect']; $F_tt_sec = ($F_et - $F_st); $friday_query ="UPDATE $table_name SET `bh_start_time` = '$F_st', `bh_end_time` = '$F_et', `bh_totaltime_seconds` = '$F_tt_sec ' WHERE `bh_days` = 'Friday';"; $wpdb->query($friday_query); //SATURDAY $SA_st = $_POST['SASselect']; $SA_et = $_POST['SAEselect']; $SA_tt_sec = ($SA_et - $SA_st); $saturday_query ="UPDATE $table_name SET `bh_start_time` = '$SA_st', `bh_end_time` = '$SA_et', `bh_totaltime_seconds` = '$SA_tt_sec ' WHERE `bh_days` = 'Saturday';"; $wpdb->query($saturday_query); //SUNDAY $SU_st = $_POST['SUSselect']; $SU_et = $_POST['SUEselect']; $SU_tt_sec = ($SU_et - $SU_st); $sunday_query ="UPDATE $table_name SET `bh_start_time` = '$SU_st', `bh_end_time` = '$SU_et', `bh_totaltime_seconds` = '$SU_tt_sec ' WHERE `bh_days` = 'Sunday';"; $wpdb->query($sunday_query); } ?>
       
Days Start Time   End Time
Monday To
Tuesday To
Wednesday To
Thursday To
Friday To
Saturday To
Sunday To
       
   
prefix . "business_hours"; $bh_data = $wpdb->get_results("select * from $table_name order by bh_id ASC"); $sn = 1; foreach ( $bh_data as $bh_showdata ) { ?>
         
Days Start Time   End Time  
bh_days; ?> bh_start_time == "-1") echo "Closed";?> bh_start_time == "0") echo "12:00 am";?> bh_start_time == "1800") echo "12:30 am";?> bh_start_time == "3600") echo "1:00 am";?> bh_start_time == "5400") echo "1:30 am";?> bh_start_time == "7200") echo "2:00 am";?> bh_start_time == "9000") echo "2:30 am";?> bh_start_time == "10800") echo "3:00 am";?> bh_start_time == "12600") echo "3:30 am";?> bh_start_time == "14400") echo "4:00 am";?> bh_start_time == "16200") echo "4:30 am";?> bh_start_time == "18000") echo "5:00 am";?> bh_start_time == "19800") echo "5:30 am";?> bh_start_time == "21600") echo "6:00 am";?> bh_start_time == "23400") echo "6:30 am";?> bh_start_time == "25200") echo "7:00 am";?> bh_start_time == "27000") echo "7:30 am";?> bh_start_time == "28800") echo "8:00 am";?> bh_start_time == "30600") echo "8:30 am";?> bh_start_time == "32400") echo "9:00 am";?> bh_start_time == "34200") echo "9:30 am";?> bh_start_time == "36000") echo "10:00 am";?> bh_start_time == "37800") echo "10:30 am";?> bh_start_time == "39600") echo "11:00 am";?> bh_start_time == "41400") echo "11:30 am";?> bh_start_time == "43200") echo "12:00 pm";?> bh_start_time == "45000") echo "12:30 pm";?> bh_start_time == "46800") echo "1:00 pm";?> bh_start_time == "48600") echo "1:30 pm";?> bh_start_time == "50400") echo "2:00 pm";?> bh_start_time == "52200") echo "2:30 pm";?> bh_start_time == "54000") echo "3:00 pm";?> bh_start_time == "55800") echo "3:30 pm";?> bh_start_time == "57600") echo "4:00 pm";?> bh_start_time == "59400") echo "4:30 pm";?> bh_start_time == "61200") echo "5:00 pm";?> bh_start_time == "63000") echo "5:30 pm";?> bh_start_time == "64800") echo "6:00 pm";?> bh_start_time == "66600") echo "6:30 pm";?> bh_start_time == "68400") echo "7:00 pm";?> bh_start_time == "70200") echo "7:30 pm";?> bh_start_time == "72000") echo "8:00 pm";?> bh_start_time == "73800") echo "8:30 pm";?> bh_start_time == "75600") echo "9:00 pm";?> bh_start_time == "77400") echo "9:30 pm";?> bh_start_time == "79200") echo "10:00 pm";?> bh_start_time == "81000") echo "10:30 pm";?> bh_start_time == "82800") echo "11:00 pm";?> bh_start_time == "84600") echo "11:30 pm";?> To bh_end_time == "-1") echo "Closed";?> bh_end_time == "0") echo "12:00 am";?> bh_end_time == "1800") echo "12:30 am";?> bh_end_time == "3600") echo "1:00 am";?> bh_end_time == "5400") echo "1:30 am";?> bh_end_time == "7200") echo "2:00 am";?> bh_end_time == "9000") echo "2:30 am";?> bh_end_time == "10800") echo "3:00 am";?> bh_end_time == "12600") echo "3:30 am";?> bh_end_time == "14400") echo "4:00 am";?> bh_end_time == "16200") echo "4:30 am";?> bh_end_time == "18000") echo "5:00 am";?> bh_end_time == "19800") echo "5:30 am";?> bh_end_time == "21600") echo "6:00 am";?> bh_end_time == "23400") echo "6:30 am";?> bh_end_time == "25200") echo "7:00 am";?> bh_end_time == "27000") echo "7:30 am";?> bh_end_time == "28800") echo "8:00 am";?> bh_end_time == "30600") echo "8:30 am";?> bh_end_time == "32400") echo "9:00 am";?> bh_end_time == "34200") echo "9:30 am";?> bh_end_time == "36000") echo "10:00 am";?> bh_end_time == "37800") echo "10:30 am";?> bh_end_time == "39600") echo "11:00 am";?> bh_end_time == "41400") echo "11:30 am";?> bh_end_time == "43200") echo "12:00 pm";?> bh_end_time == "45000") echo "12:30 pm";?> bh_end_time == "46800") echo "1:00 pm";?> bh_end_time == "48600") echo "1:30 pm";?> bh_end_time == "50400") echo "2:00 pm";?> bh_end_time == "52200") echo "2:30 pm";?> bh_end_time == "54000") echo "3:00 pm";?> bh_end_time == "55800") echo "3:30 pm";?> bh_end_time == "57600") echo "4:00 pm";?> bh_end_time == "59400") echo "4:30 pm";?> bh_end_time == "61200") echo "5:00 pm";?> bh_end_time == "63000") echo "5:30 pm";?> bh_end_time == "64800") echo "6:00 pm";?> bh_end_time == "66600") echo "6:30 pm";?> bh_end_time == "68400") echo "7:00 pm";?> bh_end_time == "70200") echo "7:30 pm";?> bh_end_time == "72000") echo "8:00 pm";?> bh_end_time == "73800") echo "8:30 pm";?> bh_end_time == "75600") echo "9:00 pm";?> bh_end_time == "77400") echo "9:30 pm";?> bh_end_time == "79200") echo "10:00 pm";?> bh_end_time == "81000") echo "10:30 pm";?> bh_end_time == "82800") echo "11:00 pm";?> bh_end_time == "84600") echo "11:30 pm";?>

FIRST SET BUSINESS HOURS...

";?>		  
      prefix . "business_hours"; $bh_data = $wpdb->get_results("select * from $table_name"); if($bh_data == NULL) { ?>