A simple content management system (CMS) built with PHP, MySQL, HTML, and CSS for a fictional big tech company named Techno1ogy.
This app was developed alongside the PHP with MySQL Essential Training: 1 The Basics and PHP with MySQL Essential Training: 2 Build a CMS courses on LinkedIn Learning, but not an exact reproduction. Most significantly, the UI/UX were adapted and extended.
- User authentication and session management
- Admin dashboard for managing content
- CRUD (Create, Read, Update, Delete) operations for subjects, pages, and admins
- Dynamic navigation menus based on database content
- Flash messaging for user feedback (success/error notifications)
- Form validation and error handling
- Responsive design with custom CSS
- Database-driven content using MySQL
- Secure database queries with input escaping
- Organized code structure with reusable PHP functions
-
Clone the repository
git clone https://github.com/Riku737/Content-Management-System.git
-
Move the project to your web server directory
- For XAMPP, move the folder to
C:\xampp\htdocs\.
- For XAMPP, move the folder to
-
Start Apache and MySQL
- Open the XAMPP Control Panel and start both Apache and MySQL modules.
-
Create and Import the Database
- Open phpMyAdmin at http://localhost/phpmyadmin.
- Create a new database (e.g.,
cms). - Import the provided example SQL file from the repository to set up tables and sample data.
- Note: An example admin user is set up in the sample SQL schema:
- Username:
QuantumDoe42 - Password:
4WDtxY_GXxi:hJ2
- Username:
-
Configure Database Credentials
- Edit the database configuration file (in
private/db_credentials.php). - Set your database name, username, and password:
define("DB_SERVER", "localhost"); define("DB_USER", "root"); define("DB_PASS", ""); define("DB_NAME", "cms_platform");
- Edit the database configuration file (in
-
Access the Application
- Go to http://localhost/Content-Management-System/public/ in your browser.
-
(Optional) Update environment variables or configuration as needed
- PHP 7.x or higher
- MySQL (included with XAMPP)
- XAMPP or similar local server environment
- Web browser
- This project is designed for use with XAMPP. It may work with other local server environments, but configuration steps (such as file locations and database setup) may differ.
- All project files must be inside the
htdocsfolder for XAMPP to serve them. - Make sure Apache and MySQL are running in XAMPP before accessing the site.
- You can manage your database using phpMyAdmin, which comes with XAMPP.
- PHP — Server-side scripting
- MySQL — Database
- HTML/CSS — Front-end structure and styling
This project was completed by following along with the LinkedIn Learning courses:
The code and structure closely reflect the instructional content provided in these courses, and the project was developed as part of a personal learning exercise.
