calebato/edutrack-ghana

PHP and MySQL learning platform for Ghanaian junior high schools # EduTrack Ghana EduTrack is a PHP and MySQL learning platform for Ghanaian junior high schools. It provides separate student, teacher, and administrator workflows for curriculum delivery, quizzes, progress tracking, communication, and reporting. ## Requirements - PHP 8.1 or later with PDO MySQL - MySQL or MariaDB - Apache (XAMPP is used for local development) - Python 3.10 or later for offline model retraining; no third-party packages are required ## Local setup 1. Place the project at `C:\xampp\htdocs\edutrack`. 2. Create a database named `edutrack_ghana`. 3. Import `database/edutrack_ghana.sql`. 4. Review database settings in `config/db.php`. 5. Start Apache and MySQL, then open `localhost`. From the XAMPP shell, the database can be prepared with: ```powershell C:\xampp\mysql\bin\mysql.exe -u root -e "CREATE DATABASE edutrack_ghana CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci" C:\xampp\mysql\bin\mysql.exe -u root edutrack_ghana -e "source C:/xampp/htdocs/edutrack/database/edutrack_ghana.sql" ``` `database/edutrack_ghana.sql` is the single assessor-friendly database import. It includes the complete current schema and privacy-safe assessment data. The schema already includes the current migrations. When upgrading an older EduTrack database instead, apply the SQL files in `database/migrations/` in filename order. ### GitHub Codespaces Open the repository in Codespaces and wait for the development container to finish building. The included container configuration automatically: - starts PHP 8.2 with Apache; - starts MariaDB 10.11; - creates the `edutrack_ghana` database; - imports `database/edutrack_ghana.sql`; and - forwards the EduTrack website on port 80. If a Codespace was created before this configuration was added, run **Codespaces: Rebuild Container** from the Command Palette. To re-import a changed SQL file after MariaDB has already initialized its persistent volume, delete and recreate the Codespace. ## Evaluation credentia …