PHP and MySQL portal for enrollment, guests, login, and dashboard.
Vanilla PHP stack for XAMPP and shared hosting.
Live Demo · Quick Start · Structure · License
- Overview
- Features
- Live Demo
- Quick Start (XAMPP)
- Project Structure
- Database Config
- Hosted Deployment
- License
- Course Note
PUP CEA-CpE Portal is a small course-to-production style web app for the PUP College of Engineering and Architecture, Computer Engineering program. It covers student enrollment, guest registration, session login, password recovery, and a logged-in home page using plain PHP and MySQL.
| Feature | Description |
|---|---|
| Student enrollment | Collects details and issues a student number |
| Guest registration | Separate guest accounts for limited access |
| Login | Session-based auth for students and guests |
| Forgot password | Reset via student number + email or username + email |
| Dashboard | Logged-in home view after auth |
Hosted instance:
https://pup-cea-cpe-portal.freedev.app/index.php
The hosted demo runs the same repository code against a real MySQL database.
cd C:\xampp\htdocs
git clone https://github.com/cikeyz/pup-cea-cpe-portal.git- Start Apache and MySQL in the XAMPP control panel.
- Import the schema:
C:\xampp\mysql\bin\mysql.exe -u root < database.sql- Open:
http://localhost/pup-cea-cpe-portal/index.php
Default XAMPP credentials work as-is (localhost, user root, empty password, database wms_activity08). For other setups, copy .env.example to .env and edit values.
- Open the login page.
- Enroll as a student (number format like
2026-02809-MN-0). - Log in with the credentials you set.
- Register a guest account and log in.
- Exercise forgot password with matching identifiers.
pup-cea-cpe-portal/
├── index.php
├── enroll.php
├── register-guest.php
├── forgot-password.php
├── home.php
├── logout.php
├── db_connect.php
├── database.sql
├── database-hosted.sql
├── .env.example
├── LICENSE
├── README.md
├── assets/
│ ├── cpe-logo.png
│ ├── favicon.svg
│ ├── pup-cea.jpg
│ └── pup-logo.png
├── css/
│ └── style.css
├── js/
│ ├── auth.js
│ └── enroll.js
└── uploads/
└── .gitkeep
db_connect.php reads optional .env values:
| Variable | Default |
|---|---|
DB_HOST |
localhost |
DB_PORT |
3306 |
DB_USER |
root |
DB_PASS |
(empty) |
DB_NAME |
wms_activity08 |
Use database-hosted.sql when the host already provides a database and you cannot run CREATE DATABASE. Point .env at host credentials and deploy the PHP tree over FTP or your host git deploy.
MIT. See LICENSE.
PUP names, logos, and related marks belong to the Polytechnic University of the Philippines. This project is for educational use.
Built for CMPE 364 (Web and Mobile Systems), Polytechnic University of the Philippines, under Engr. Arlene B. Canlas. Published here as a standalone project.