ADE database interface
A PHP interface to manage course activities in a timetable database.
The project
The timetable of the IUT comes from a tool called ADE. We had to build a web interface to manage course activities on top of a copy of this database.
- A MySQL database with rooms, teachers and requests. Validations go through join tables.
- Pages to add, edit and validate activities and a supervision page. All queries use PDO prepared statements.
- MySQL triggers write every insert, update and delete into a journal table. You can see the data before and after each change.
