System Architecture
AR Digi-Lab is built on a Monolithic Modular Architecture. It utilizes a PHP backend with a MySQL relational database, leveraging Tailwind CSS for a high-performance, utility-first frontend.
Frontend
Tailwind CSS 3.4
Lucide Icons
JavaScript (ES6+)
Backend
PHP 8.x
Apache Server
.htaccess Routing
Database
MySQL 8.0
InnoDB Engine
Relational Mapping
Database Schema
| Table Name | Primary Key | Description |
|---|---|---|
person |
PersonID | Base table for all users (Admin, Student, Teacher). |
assessments |
AssessmentID | Stores metadata and PDF links for coordinate-based exams. |
video_interactions |
InteractionID | Links timestamps to pop-up questions in video lessons. |
Core Modules
Interactive Video Player
Utilizes HTML5 Video API combined with asynchronous JSON fetching to pause and render overlays at specified timestamps.
Coordinate Overlay System
Maps absolute pixel positions from the Teacher Creator to a responsive relative canvas on the Student Test Portal.
Security & Encryption
SSL/TLS Data Encryption
All communications between the client-side browser and the AR Digi-Lab server are encrypted using 256-bit AES encryption. This prevents Man-in-the-Middle (MITM) attacks during the submission of sensitive test answers.
Hierarchical Access Control
Access is governed by a strict RBAC model. Users are mapped to `UserRoleID`, ensuring that a Student cannot access the `grades_management` or `assessment_creator` modules through direct URL manipulation.
SQL Injection Prevention
The system utilizes PDO Prepared Statements for all database transactions. This ensures that user inputs from the login form and test overlays are treated as data, never as executable code.