Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 26 Minute(s)
Language
English
Taught by
Fatah Gabrial
Rating
Course Overview
Learn PHP and MySQL by building a CRUD-based Employee Management System using clean, beginner-friendly functional code.
Learn PHP and MySQL by Building a Real Project — the Smart, Simple Way
Hey there! If you've been trying to learn backend web development but find most tutorials confusing or filled with jargon — this course is for you.
This is a complete beginner-friendly PHP and MySQL course, focused on building one real, useful project: an Employee Management System.
You won’t just learn how PHP and MySQL work — you’ll use them together to build something meaningful, one step at a time.
--
Why This Course Is Different
Most PHP tutorials either throw you into object-oriented code too early or just give you syntax without showing how it all connects.
In this course, we take a functional programming approach that’s much easier for beginners. Everything is broken down clearly — no classes, no frameworks, just clean PHP logic, step-by-step.
You’ll learn how to:
Set up your local server and database using XAMPP or WAMP
Connect PHP to MySQL and run real SQL queries
Build the full CRUD flow (Create, Read, Update, Delete)
Add, update, and delete employee records through HTML forms
Sanitize user input and prevent common errors
Organize your PHP code into clean, reusable functions
Build a practical backend system without relying on CMS or frameworks
--
Learn by Doing — Build a Real PHP + MySQL Web App
By the end of this course, you'll have a fully working Employee Management System built with PHP and MySQL — and more importantly, you’ll understand how it works.
You’ll be able to:
Work confidently with databases and PHP
Build your own backend projects from scratch
Create dynamic, data-powered websites
Expand into advanced concepts like OOP, MVC, or full-stack dev — with a solid foundation in place
--
No need to learn everything at once.
Enroll now, and let’s build your first real backend project together — the smart way, the practical way.
Course Content
- 5 section(s)
- 44 lecture(s)
- Section 1 Introduction to PHP & MySQL
- Section 2 PHP Fundamentals
- Section 3 MySQL Fundamentals
- Section 4 EMS Web App (Project)
- Section 5 Conclusion
What You’ll Learn
- Learn how to build a complete Employee Management System using PHP and MySQL with functional programming and clean, modular structure.
- Understand how PHP works with HTML and forms to capture user input, process data, and interact with a MySQL database from scratch.
- Learn to perform all CRUD operations — Create, Read, Update, and Delete — using PHP and MySQL in a simple, beginner-friendly format.
- Set up a MySQL database with tables for employee records and connect it to your PHP project using procedural-style code.
- Use functions in PHP to structure your logic clearly — separating concerns like database handling, input validation, and output.
- Learn how to build HTML forms and use PHP to insert new employees, update records, delete entries, and view all data from MySQL.
- Secure your app with basic input validation and understand how to handle form submissions and sanitize data using built-in PHP functions.
- Understand the role of mysqli_connect(), SQL queries, and basic database connection logic to make PHP and MySQL work together.
- Create a reusable, functional structure for PHP pages — like add.php, update.php, delete.php — for scalable and organized code.
- Gain real project experience in PHP and MySQL so you can confidently build CRUD apps, small dashboards, or backend logic from scratch.
Skills covered in this course
Reviews
-
PPanagiotis
First of all I have to tell you that I have previous knowledge of PHP and other programming languages in general. I have seen several hours of course and I am pretty disappointed from this course for various reasons. First of all the main goal of the course is not achieved: The instructor does not explain how PHP works and barely scratches the surface. There are even parts that he just skips forward and the code is already written. So If I was a completely new guy, I wouldn't understand what I understand with my exprerience. Regarding the SQL part do not expect to learn what is SQL and how it works. It's just a step by step guide to how connect to PHP. Nothing more nothing less. Also how the code works on PHP to form the connection is not well explained too. Also, there are lessons that require you to hava an HTML/CSS structure which is not provided as an attached file. Neither you get the change to write it with the instructor because it is already there and not always visible. On the Project there are flaw too. He uses Bootstrap (which is a CSS framework) but he never shows us how to add it to the code. So this, in combination with the fact that you don't get to write the HTML/CSS or get that file from the instructor, leaves you starring at the screen with files you don't have while the instructor begins the PHP part.
-
MMeet Darji
he does not telling where is he getting the methods and he uses higher functions so I get lost. there is no resorce page where we get the code and there he does not write either. copy and pastes the important methods.
-
AAlan Lee
A lot of information packed into every video. Much pausing required to copy code and keep up!
-
SSam Santiago
Not quite for beginners with the way there's a lot of missing information. It did help me at least understand a couple things and gave me the terminology to look for things online.
