PHP & MySQL Course — Build Dynamic Web Applications in 8 Weeks

Write maintainable, professional PHP using object-oriented programming — the foundation of every modern PHP framework including Laravel and Symfony.

• Classes and objects: properties, methods, constructors, __destruct
• Access modifiers: public, protected, private; late static binding
• Inheritance: extends, parent::, method overriding, final classes
• Interfaces: implements, interface constants, multiple interface implementation
• Traits: using traits for code reuse; conflict resolution
• PHP 8 property promotion: constructor property syntax; enums (PHP 8.1)
• HTML forms: GET vs POST, form validation, htmlspecialchars() for XSS prevention
• File uploads: $_FILES, move_uploaded_file(), MIME validation, size limits

Design and query relational databases that scale — the MySQL skills that determine whether your backend performs well in production.

• Relational model: tables, rows, columns, primary keys, foreign keys
• Database normalisation: 1NF, 2NF, 3NF; avoiding data redundancy
• DDL: CREATE TABLE, ALTER TABLE, DROP; data types (INT, VARCHAR, TEXT, DATE, ENUM)
• DML: SELECT, INSERT, UPDATE, DELETE; WHERE, ORDER BY, LIMIT, OFFSET
• JOINs: INNER JOIN, LEFT JOIN, RIGHT JOIN, self JOIN
• Aggregate functions: COUNT, SUM, AVG, MIN, MAX; GROUP BY, HAVING
• Subqueries, views, and stored procedures
• Indexes: B-TREE index, covering index, EXPLAIN plan; transactions (COMMIT/ROLLBACK)

Connect PHP to MySQL securely using PDO — the only database access method that a professional PHP developer should use.

• PDO vs MySQLi: why PDO is preferred; DSN, connection, error handling (ERRMODE_EXCEPTION)
• Prepared statements: bindParam, bindValue, execute; preventing SQL injection completely
• CRUD operations with PDO: SELECT into arrays, INSERT/UPDATE/DELETE with row counts
• PDO fetch modes: FETCH_ASSOC, FETCH_OBJ, fetchAll
• Transactions in PDO: beginTransaction, commit, rollBack
• Password security: password_hash() with PASSWORD_BCRYPT; password_verify()
• CSRF tokens: generating and validating tokens on every form submission
• Input validation and sanitisation: filter_var, FILTER_VALIDATE_EMAIL, FILTER_SANITIZE_STRING

Build a complete, secure user authentication system and a JSON REST API — two essential capabilities in every PHP backend application.

• Sessions: session_start, $_SESSION, session fixation and hijacking prevention
• Remember Me: secure cookie-based persistent login with rotating tokens
• Login, logout, registration with email verification flow
• Role-based access: admin vs user guards, middleware-style route protection
• REST API in PHP: JSON headers, HTTP methods (GET/POST/PUT/DELETE), status codes
• Consuming an API from PHP: file_get_contents with stream context, curl, json_decode
• AJAX with vanilla JS: fetch() calling your PHP API, dynamic page updates
• JWT basics: structure, signing, verification with php-jwt library

Get hands-on with Laravel — the most popular PHP framework worldwide — and build your capstone project using MVC architecture.

• Laravel setup: Composer, artisan serve, directory structure, .env
• Routing: web.php, Route::get/post/put/delete, named routes, middleware
• Controllers: artisan make:controller, CRUD resource controllers
• Blade templates: layout files, @extends, @yield, @section, components
• Eloquent ORM: make:model, migrations, fillable, find, create, update, delete
• Form validation: $request->validate, error display in Blade
• Laravel Breeze: built-in authentication scaffolding (login, register, password reset)
• API routes: api.php, resource API controllers, returning JSON responses