Chinese Drama Catalogue
Overview
This is the final project for the PHP/MySQL course at NAIT. This project is aiming to create a simple PHP/MySQL application that catalogues a collection of similar items.
Some of requirements for this project:
1. Admin Section which allow users to insert a new item, upload an image, edit an existing item, delete an item.
2. Public Section has the homepage with summary of the project, display design properly, filtering options, search feature, single view, rating and review
Skills and Techniques
- HTML
- Bootstrap
- PHP
- MySQL
Working Process
Planning
In order to obtain this project, I have to come up with the proper plan to make the process smooth. First of all, I select the topic of Chinese Drama Collection and built fully in PHP and store the data information in the database through phpMyAdmin. Each drama entry includes the drama title, realease year, number of episodes, categories, original network, director of the drama, main cast, brief description, user review and rating.
Add-on Challenge for this Project
- 1. Custom challenges: create the rating and review function
- 2. Highligh Funfacts on the homepage related to different drama and display randomly.
- 3. Profile Photo for User
Page Directory Structure
The page directory structure is divided into two sections: public and private. The private section stores processes and admin functions to protect files from public access. This section includes functions that users can access within the application, such as adding forms, editing forms, form validation, login processes, rating processes, and secure database connections using prepared statements. Also, the admin panel which allows register using the function of add item, edit item, delete and hashed password.
The public section contains files for each page that users can access, styled using Bootstrap for a cohesive look. It also includes functions that allow users to filter and search data. This project is fully responsive.
Database Structure
This is the database structure used to insert data into phpMyAdmin. Each data table includes a primary key and, where necessary, a foreign key to establish relationships between tables. This setup allows for efficient retrieval of user reviews and ratings by connecting relevant tables.
To design the table structure, I first needed to identify the types of information I wanted to display and store in the database to meet the project requirements. Three main tables are essential: the Drama Catalogue table, which organizes details about each drama; the Catalogue Admin table, which stores registered user information; and the User Rating table, which captures user-submitted ratings and reviews.
Final Thought
This project has been rewarding experience that strengthened my skills in full-stack web development. Understand deepen the knowledge of building a structured database, designing user-friendly forms, and implementing secure access control. This project not only demontrates my ability to design and develop a responsive and interactive application but also highlights my understanding in PHP, MySQL, and database management.