I am going to develope a sports center booking system.
I plan to have a web page that display a table contains a schedule that have date as column and (day- Monday-Sunday) as row..
I want to store default value as false for each date and day.When user place booking, the value will change to true indicate the slot been booked. Now I have question of how should I store the date correspond to each availibility booking slot? Shall I use current system date and predict the date for each date .. if that is the case , how to handle the date if change from month to month?
How shall I store those value in MySQL so that I can display the previous and future date to display to user?User can always view the date that is whether booked by somebody or available for booking before he/she place booking.
Anyone can advice me?