Single-file PHP academic information system with SQLite database.

• PHP 8.3 or higher
• SQLite extension (included in standard PHP installations)
• Docker (optional, for containerized deployment)

php -S localhost:8000 index.php

Open http://localhost:8000 and login with:

• Username: admin
• Password: admin123

docker compose up -d

App available at http://localhost:8080

• Program Studi (Prodi) -- Manage study programs (D3, D4, S1, S2)
• Mahasiswa -- Student management (NIM, personal data, program assignment)
• Dosen -- Lecturer management (NIDN, personal data, program assignment)
• Mata Kuliah -- Course catalog (course codes, credits, semester placement)
• Tahun Akademik -- Academic year/semester management with active period toggle
• Kelas -- Class offerings with lecturer assignment and schedules
• KRS -- View all course registrations
• Nilai -- Grade input and management
• Presensi -- Attendance tracking
• KHS -- View student transcripts
• Broadcast -- Send real-time notifications to all users or specific roles

• View assigned classes with enrollment counts
• View class schedules
• Input grades for enrolled students (A-E grading scale)
• Record daily attendance (hadir/sakit/izin/alpha)

• View personal information (NIM, program, cohort)
• Register for available classes (KRS)
• View weekly class schedule
• View semester transcripts (KHS) with GPA calculation

• Server-Sent Events for push notifications without external dependencies
• Toast notifications with auto-dismiss (5 seconds)
• Unread count badge in navigation bar
• Notification types:
  • Nilai published (when dosen submits grades)
  • KRS enrollment confirmation
  • Presensi alpha alerts
  • Admin broadcast messages
• Auto-cleanup of notifications older than 30 days

• Backend: PHP 8.3 (built-in functions only, no frameworks)
• Database: SQLite with PDO (WAL mode)
• Frontend: Custom CSS (editorial minimalist design), vanilla JavaScript
• Real-time: Server-Sent Events (SSE) for push notifications
• Authentication: PHP sessions with password_hash/password_verify
• Security: CSRF tokens, prepared statements, input sanitization
• Container: Docker with non-root user, named volumes

siakad/
├── index.php              # Application logic and routing
├── assets/
│   ├── css/
│   │   └── style.css      # Minimalist editorial stylesheet
│   └── js/
│       └── main.js        # Scroll reveal + SSE notification client
├── docker-compose.yml     # Container orchestration
├── Dockerfile             # Secure container build (non-root)
├── logs/                  # Application logs (gitignored)
├── siakad.db              # SQLite database (auto-created, gitignored)
├── .gitignore
└── README.md

The system auto-creates 12 tables on first run:

GPA (IPK) = (Sum of Grade Points x Credits) / Sum of Credits

• Default admin password (admin123) should be changed in production
• Docker container runs as non-root appuser (UID 1000)
• All database queries use prepared statements
• CSRF tokens protect form submissions
• User input is sanitized via htmlspecialchars
• Sessions regenerated on login to prevent fixation

Built as a demonstration project. Feel free to use and modify as needed.