Build a Digital Agency Service CMS using PHP & MySQL

Name: Build a Digital Agency Service CMS using PHP & MySQL
Rating: 5.0 (4 reviews)

Building a Digital Agency Service CMS using the PHP, PDO & MySQL from scartch.

Hot & New

New

Created byMd Morshedul Arefin

Last updated 5/2026

English

What you'll learn

Complete project using php, pdo and mysql
Full admin panel authentication system from scratch
Sending email using phpmailer
Complete CRUD system
PHP session
Forget and Reset Password System for admin panel
Connecting database with php, pdo
Form validation technique
Toast message notification
Pricing Package Management
Manage Subscribers and Verify
Subscriber export as CSV
PHP Fundamentals
MySQL Fundamentals
Writing Query using PHP and MySQL
Security in PHP
Custom Pagination using PHP

Course content

28 sections • 144 lectures • 29h 7m total length

Introduction7:28

Installing XAMPP (Windows OS)4:32
Shift between php versions in XAMPP (Windows OS)9:08
Installing Laragon (Windows OS)9:42
Shift between php versions in Laragon (Windows OS)3:57
Install PHP 8.2 in Laragon (Windows OS)3:44
Installing XAMPP (MAC OS)4:30
Installing MAMP (MAC OS)7:27
Shift between php versions in MAMP (MAC OS)7:09
Download & Install Composer (Windows OS)10:44
Download & Install Composer (MAC OS)2:43
Code Editors1:47

Syntax5:59
Create a .php file in a local server folder, run it on localhost, and use PHP blocks and echo to output html or text to the browser.
Comment4:09
Variable5:20
Variable Scope11:22
Echo and Print5:34
Data Type16:21
Type Casting6:36
String - Part 15:24
String - Part 225:33
String - Part 312:10
Number6:06
Math10:18
Constant7:01
Operator - Part 122:59
Operator - Part 214:45
Operator - Part 311:23
Conditional Statement10:59
Switch4:52
Loop - Part 122:09
Loop - Part 29:56
Nested Loop - Part 123:40
Nested Loop - Part 211:33
Array - Part 113:57
Array - Part 25:04
Array - Part 313:17
Array Function19:07
Function10:43
Superglobal2:56
Form, Get, Post, Request24:45
Cookie - Part 110:01
Cookie - Part 225:52
Session16:52
Include and Require7:46
File Upload and Validation - Part 132:16
File Upload and Validation - Part 215:10
File IO15:36
Form Validation29:06
Sending Email13:44
Regular Expression - Part 119:46
Regular Expression - Part 214:02

What is MySQL16:31
Connect MySQL with PHP9:10
Learn to connect PHP with MySQL using MySQLi and PDO, avoid the deprecated MySQL extension, compare procedural and object-oriented styles, and use prepared statements to prevent SQL injection.
Create Database and Table10:31
Inserting Data6:57
Prepared Statement8:11
Use prepared statements with PDO in PHP to securely insert data into MySQL, protecting against SQL injection. Employ named parameters or unnamed placeholders, bind values and execute for performance.
Select Data24:57
Where Clause18:30
Update Data2:32
Learn to update database data with SQL: use update queries, set column values, and apply where conditions to modify one or more fields for specific rows.
Delete Data4:03
Order By Clause3:23
Limit Clause5:25
Join Clause31:16
Union Clause7:26
Alter Table5:29
Group By and Having9:38

Requirements

Basic knowledge in HTML
Basic knowledge in CSS
Basic knowledge in Jquery
Basic knowledge in Bootstrap
Basic knowledge in Code Editor like VS Code or any other

Description

In this course, I am going to teach students how to build a nice and user-friendly content management system for a digital agency service website from scratch using PHP and MySQL. The course will cover all the core aspects of web application development, including authentication systems, email verification, template mastering etc.

I will develop a real-world digital agency service website where an administrator can easily change all the text and photos of that application and use it in real world for any digital agency type websites that contains a content management system or cms. This project will be built using the latest version of PHP at the time of recording, ensuring students learn modern and up-to-date practices.

This course is designed especially for beginners who have little or no experience with PHP, but even advanced learners will find it useful as I implemented many advanced features.

Admin Panel Features:

Admin can change logo, favicon etc.
Admin can change top bar and footer information.
Admin can control the home page information.
Admin can create, edit and delete blog categories.
Admin can create, edit and delete blog posts.
Admin can manage post comments.
Admin can manage post replies.
Admin can create, edit and delete services.
Admin can create, edit and delete projects.
Admin can create, edit and delete team members.
Admin can create, edit and delete FAQ items.
Admin can create, edit and delete pricing plan items.
Admin can create, edit and delete testimonials.
Admin can create, edit and delete photo gallery items.
Admin can see subscriber list and export all as CSV.
Admin can change his own photo, information and password
Admin can manage pages.
Admin can manage theme color change.
Admin can manage RTL or LTR from the back end.

Who this course is for:

Persons who want to learn php from scratch
Persons who want to learn mysql from scratch
Persons who are looking for a good job in web development sector
Persons who want to have a remote job in php
Persons who want to start his freelancing career using php

Build a Digital Agency Service CMS using PHP & MySQL

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 7min

Local Server Setup & Preparing Environment11 lectures • 1hr 5min

PHP Fundamentals40 lectures • 9hr 4min

MySQL Database15 lectures • 2hr 44min

Security in PHP4 lectures • 1hr 7min

Pagination1 lecture • 37min

Admin Panel - Template Mastering11 lectures • 2hr 18min

Front End Template Mastering8 lectures • 1hr 25min

Slider Section3 lectures • 46min

About Section2 lectures • 38min

Requirements

Description

Who this course is for: