← Back to training
Training plan · Development · Intermediate
PHP & MySQL Development
Intensive 3-day training to learn backend development: PHP, forms, sessions, MySQL CRUD, MVC architecture and deployment.
Duration
3 jours (21h)
Format
On-site
Prerequisites
Basic HTML and CSS (Frontend module or equivalent)
Audience
Junior web developers, IT interns
1
Day 1 — PHP: Fundamentals
1j- PHP intro: server-side, XAMPP/WAMP, phpinfo()
- Syntax: <?php ?> tags, echo, comments, semicolons
- Variables: declaration, types, scope
- Constants: define(), const, magic constants
- Operators: arithmetic, concatenation, comparison, logical
- Conditions: if/else, elseif, switch, match (PHP 8)
- Arrays: indexed, associative, multidimensional, foreach
- Functions: declaration, parameters, return, variable scope
- Built-in functions: strlen, str_replace, explode, implode, date, rand
- Intensive lab 1: create a PHP form processing script with validation and data display
2
Day 1 — PHP: Forms & Sessions
- HTTP methods: GET vs POST, $_GET, $_POST, $_REQUEST
- Validation: required, email, number, length, regex (preg_match)
- Security: htmlspecialchars, strip_tags, trim, server-side validation
- Files: $_FILES, move_uploaded_file, allowed types, size
- Sessions: session_start(), $_SESSION, login management
- Cookies: setcookie(), $_COOKIE, expiration, path
- File inclusion: include, require, include_once, require_once
- Intensive lab 2: create a user login system with session and file upload
3
Day 2 — PHP & MySQL: Complete CRUD
1j- MySQL connection: mysqli_connect, PDO, error handling
- SQL queries in PHP: mysqli_query, SELECT, INSERT, UPDATE, DELETE
- Prepared statements: bind_param, SQL injection protection
- Data display: while, fetch_assoc, HTML tables
- CRUD creation: Create, Read, Update, Delete — complete application
- Pagination: LIMIT, OFFSET, page calculation, navigation
- Search: LIKE, %keyword%, search form
- Intensive lab 3: create a complete article management CRUD (add, list, edit, delete, search, pagination)
4
Day 2 — MVC Architecture & Templates
- MVC architecture: Model, View, Controller — principles and benefits
- File separation: /models, /views, /controllers, /config
- Simple router: index.php as entry point, URL rewriting
- Templates: HTML/PHP separation, header.php, footer.php, layout
- Reusable components: helper functions, classes
- Namespaces and autoloading: spl_autoload_register, Composer (intro)
- Best practices: naming conventions, structure, comments
- Intensive lab 4: refactor the CRUD into clean MVC architecture
5
Day 3 — Project: Complete Web Application
1j- Requirements analysis: specifications, features, users
- DB design: conceptual model, tables, relationships, indexes
- Frontend development: responsive HTML/CSS, pages
- Backend development: PHP, CRUD, sessions, validation
- JSON API: create a simple REST API in PHP (json_encode, headers)
- Security: SQL injection, XSS, CSRF, passwords (password_hash)
- Intensive lab 5: develop a web management app (contacts, tasks, or blog) with MVC, CRUD and API
6
Day 3 — Deployment & Best Practices
- Hosting: shared vs VPS, cPanel, FileZilla, PHP settings
- Database: phpMyAdmin export/import, SQL migration
- Environment: development vs production, .env variables
- Versioning: Git init, add, commit, push, GitHub, .gitignore
- Deployment: go live, testing, bug fixing
- Maintenance: logs, DB backup, updates
- Project presentation and certification
This plan is customizable
Ideal for web developers moving from static to dynamic. Final project adaptable to your need (blog, contact management, e-commerce).