Equip learners with the skills to build dynamic, data-driven web applications using PHP as the backend scripting language and MySQL as the database system.
Who Should Enroll:
- Aspiring web developers
- Undergraduates in IT, CS, SE or relevant
Prerequisites:
Basic knowledge of web development such as HTML and CSS
Trainer:
Rasan Samarasinghe (Profile)
Training Fee:
Rs. 30,000.00 per participant (Method of payment)
Delivery:
Online with live sessions or self-paced
Duration:
30 hours
Medium:
English
Certification:
Digital certification with the transcript upon completion
Course Modules & Structure:
1: Introduction to Web Application Development
- Understanding dynamic vs. static websites
- Overview of PHP and MySQL in web development
- Server setup: XAMPP/LAMP/MAMP
Activity: Set up a local development environment
2: PHP Basics
- Syntax, variables, and data types
- Conditional statements and loops
- Functions and arrays
- Working with forms and $_GET / $_POST
Hands-on: Build a calculator and feedback form
3: Working with MySQL Databases
- Introduction to relational databases
- Database design basics: tables, primary keys, relationships
- Using phpMyAdmin or MySQL CLI
- CRUD operations (Create, Read, Update, Delete)
Hands-on: Create a student database and test queries
4: Connecting PHP with MySQL
- Using
mysqliandPDOfor database connections - Executing queries and fetching results
- Error handling and best practices
Hands-on: Display data from MySQL on a web page
5: Forms, Validation, and User Input
- Handling user input securely
- Validating data on server side
- Sanitizing inputs to prevent attacks
Hands-on: Create a registration form with validation
6: Session Management and User Authentication
- Understanding sessions and cookies
- Building a login and logout system
- Password hashing and authentication best practices
Hands-on: Implement secure login for a member area
7: Building Dynamic Web Pages
- Page templates and includes
- Conditional content rendering
- Displaying lists and user-generated content
Hands-on: Build a blog or article listing page
8: Error Handling and Debugging
- Using
try-catch,die(), and error reporting - Logging errors
- Debugging tools and techniques
Hands-on: Add error handling to your application
9: Project – Build a Complete Web Application
- Plan the application structure and features
- Create database schema
- Develop backend functionality and UI
Capstone: Build and deploy a mini CMS, job board, or contact manager
Request this Training
We schedule our trainings based on the requests we receive. Whether you’re an individual or a team, fill out the form below to request this course. We’ll get back to you with available dates or a custom session – group or one-on-one. Learn more.