I have previously created a website
Now i would like to link it to a database. Using mysql, php, xhtml.
First, i would like to create a mysql database for the student and tutor accounts. the information gathered from the existing form should flow into the 2 database. Everytime someone send information via the TUTOR and STUDENTS, he will also create an account using the email as user id which he can login on a separate occassion to adjust his details. Every time a new entry or an amendment comes into either database, it should also send the data by email as an excel sheet.
Next, it has to have an additional tab called COORDINATOR where coordinators can login to access the database on the TUTORS only. It should be able to search the database by latest data, nearest MRT. If possible I can adjust the search types.
Third, it should also has another additional separate staff login. A master login, where I am able to access both the STUDENT and TUTOR database online. I should be able to delete, amend STUDENTS, TUTORS and COOREDINATOR account details. I should be able to add Coordinator accounts. It should be able to search all the database by latest data, nearest MRT. If possible i can adjust the search details.
If you need more information. please pm me.
thx