Calendar enhancement (PHP)

PHP/MYSQL application We have a calendar service, that is used by 200 people doing approx 7000 bookings a month. We need a small PHP application that can be used when our customers are doing minor things, from their mobile phones for instance. The formatting / layout is minimal. The user will be able to: * Log on (password verification) * Select which calender and which date they want to display * Schedule a visit ## Deliverables PHP/MYSQL application We have a calendar service, that is used by 200 people doing approx 7000 bookings a month. We need a small PHP application that can be used when our customers are doing minor things. The formatting / layout is minimal. The user will be able to: * Log on (password verification) * Select which calender and which date they want to display * Schedule a visit The main use for this application is using our normal calendar on webbrowsers in mobile phones like windows mobile and iphone. ------- database name clinicbuddy login root password XXX -------- All these steps have HTML examples. ---- STEP 1. ---- Login screen: Username: ____ Password: ____ [X] Keep me logged in until i log out SUBMIT ---- Username and password are input textboxes, the keep logged in is a checkbox. Submit is the submit button If Keep logged in is checked, the person will be logged in next time he accesses this page, otherwise he will be asked to log in again once session has ended (a timeout). ---- STEP 2.? ---- When pressing submit check database table "personnel" for "name" and "password". Store from same table persons "company" (integer, number) as cookie or global varible. If "name" doesnt match "password" or if name doesnt exist, go back to step 1 - login screeen. ---- STEP 3. ---- Show the "personnel" of the "company" that was retrieved in step 2. All are selectable. ---- STEP 4. ---- When a "personnel" was selected, double check that that personnel has the same company (number) as the first one stored in step 2. Show screen of dateselector Once a date is selected go to step 5. ---- STEP 5. ---- Show the "personnel_reservations" for this person, sorted by time. If there is a gap in the schedule, a link with the number of minutes should be there. if the link is pressed go to step 6 with the start time pre entered (not the end time). Ability to schedule a time If booking, go to step 6 ---- STEP 6. ---- Show form for scheduling. Once stored -? Go back to step 5. The tables in the database: personnel --------- id unique ID number for the personnel name login name of the personnel password the password company which company they belong to (a number) personnel_reservations ---------------------- id unique ID number of the reservation personnel which personnel does the reservation belong to timefrom start time timeto end time date date of reservation comment text field of whats been booked Please see attached zipfile, with all the forms as HTML example.