News Portal
A news site with a proper back office. Staff publish stories, readers comment, and nothing a reader writes goes live until it’s approved. I built it for my final-year project at Politeknik Kuching.
- 2022 – May 2023
- Database, back end, front end, testing
- PHP, MySQL, JavaScript, jQuery, Apache
Notes
Starting with the tables
Before any pages, I spent the first stretch on the database. Categories can sit inside other categories, posts can carry images and video, and every comment and view gets logged. Getting that into a clean, normalised MySQL schema made the rest of the build much easier.
The admin side
Staff log in to a dashboard with its own sessions. From there they can write and edit posts, search everything by keyword, and work through a queue of reader comments. Nothing a reader writes goes live until someone approves it, which keeps the spam out.
Testing
I worked in short Agile cycles, wrote unit tests as I went, and ran user acceptance testing before the final submission.
What came of it
I entered it in IVCCII 2023, an international competition for student innovation, and it won bronze in the higher-education category.