Hi,
I need some help with a php application. I want to write simple online scheduling/appointment application with PHP and MySQL. I am not sure how to begin.
Basically these are what the application would allow:
USERS :
- to log in as member
- choose the person (advisors) they want to make an appointment with
- pick a date and time from available time slot
For example, Feb 1, 2014, 8:00AM- 8:30AM
- Submit the date to advisor (email confirmation)
ADVISORS
- to log in as an admin
- set up their schedules (available date and time).
- there are several advisors, each has seperate schedule.
My questions are:
- What tools/frameworks should be used to display Calendar and time?
- What appropriate methods should I store advisors available date and time in MySQL?
- If i use jquery UI to display calendar, how can I make it interact with the database?
For example, GREEN is available time, RED is booked. Thanks for your input.