Deglecy Computer · Programming
PHP and MySQL Web Application Development
An intermediate-level, project-driven course that teaches server-side programming using PHP and MySQL. Students build real-world web applications covering database integration, user authentication, security, and CRUD op…
40lessons
Intermediatelevel
30 hoursto complete
2already enrolled
About this course
An intermediate-level, project-driven course that teaches server-side programming using PHP and MySQL. Students build real-world web applications covering database integration, user authentication, security, and CRUD operations.
What’s included
Free to joinCreate an account and enroll at no cost.
Final examFinish all lessons, then take the exam.
CertificatePass the exam to earn your certificate.
Course content
Module 1: Introduction to PHP and Server Setup5 lessons
Setting Up XAMPP/WAMP15 min
Understanding PHP Syntax20 min
Variables, Data Types, and Operators18 min
Working with Strings and Arrays22 min
Control Structures and Functions25 min
Module 2: MySQL Database Fundamentals5 lessons
Introduction to MySQL12 min
Creating Databases and Tables20 min
SQL INSERT, SELECT, UPDATE, DELETE25 min
Using WHERE, ORDER BY, and LIMIT18 min
Joining Multiple Tables22 min
Module 3: PHP and MySQL Integration5 lessons
Connecting PHP to MySQL20 min
Fetching Data with mysqli18 min
Inserting Data from Forms22 min
Updating and Deleting Records20 min
Handling Form Submissions Securely25 min
Module 4: Building a Registration System5 lessons
Designing Registration Forms15 min
Validating User Input20 min
Hashing Passwords with password_hash()18 min
Storing Users in the Database22 min
Preventing Duplicate Registrations12 min
Module 5: User Authentication and Sessions5 lessons
Creating Login Forms15 min
Verifying Credentials Securely20 min
Managing Sessions in PHP18 min
Protecting Pages with Sessions22 min
Implementing Logout Functionality10 min
Module 6: CRUD Operations and Dynamic Content5 lessons
Planning the CRUD Application12 min
Creating Records with Forms20 min
Reading and Displaying Data22 min
Editing Existing Records25 min
Deleting Records Safely18 min
Module 7: Security Best Practices5 lessons
Understanding Common Threats15 min
Preventing SQL Injection20 min
Sanitizing and Escaping Output18 min
Using Prepared Statements22 min
Implementing CSRF Tokens14 min
Module 8: Final Project: Build a Complete Web App5 lessons
Project Planning and Setup20 min
Building the Frontend UI25 min
Implementing Backend Logic22 min
Adding Admin Dashboard Features25 min
Deploying and Testing the App18 min