Library Attendance

Library attendance is a web login system created for Dublin Coffman High School.

Project Architecture

The back-end is written in PHP and interfaces with a MySQL database (LAMP Stack). The front-end is built with Bootstrap 3 and uses jQuery for AJAX requests to the back-end’s REST interface.

Student Login

Library attendance is designed to create an easy and fast way for students to login with their student ID. It uses a simple and intuitive design for fast and accurate data entry.

Administration

The program has a fully-featured administration system.

Administrators can login to the admin dashboard on a desktop or mobile device.

The administrator dashboard has a visits viewer that can be used to monitor activity. In addition it has several filters that can be used to search the database.

Administrator User Permission System

Every administrator has a username, password, and ID; which can be used to activate sessions. All passwords are stored with bcrypt salted-hashes.

The root user, with ID 1, is the only user that can add or remove other administrators with lower permission levels.

Database Exports

Administrators can export the visits database into various different formats: CSV, XML, and JSON. There is also the option to select either the date format in the configuration file or UNIX timestamps (as are used internally by the DB).