You will need to implement a drop down that contain times and day of the week.
Drop down pull the data from MySQL database, I have a table called open_hour
See below for more technical detail...
## Deliverables
You will need to implement a drop down that contain times and day of the week.
Drop down pull the data from MySQL database, I have a table called open_hour
open_hours table data example:
| **id ** | **week_day ** | **open_time ** | **close_time** |
| 1 | 1 | 20:30:00 | 23:00:00 |
| 2 | 2 | 18:00:00 | 01:00:00 |
| 3 | 3 | 16:00:00 | 23:30:00 |
| 4 | 4 | 16:00:00 | 23:30:00 |
| 5 | 5 | 16:00:00 | 23:30:00 |
A drop down should show two or 3 days depending close time. For example if today is Monday (week_day = 1) and time now is 21:00, then drop down should show like this:
Mon - 21:00 - 21:15 PM
Mon - 21:15 - 21:30 PM
Mon - 21:30 - 21:45 PM
Mon - 21:45 - 22:00 PM
Mon - 22:00 - 22:15 PM
Mon - 22:15 - 22:30 PM
Mon - 22:30 - 22:45 PM
Mon - 22:45 - 23:00 PM
Tue - 18:00 - 18:15 PM
Tue - 18:15 - 18:30 PM
CONTINUTE UNTIL 1:00:00
Tue - 23:45 - 00:00 AM
Wed 00:00 - 00:15 AM
Wed 00:15 - 00:30 AM
Wed 00:30 - 00:45 AM
Wed 00:45 - 01:00 AM
in PHP, I should be able change the Minutes Increment, for example 15 to 10. And also change 24 hours clock to 12 format, example: Tue - 18:15 - 18:30 PM to Tue - 6:15 - 6:30 PM