Build dynamic web applications with PHP & MySQL

Introduction to the Web and PHP

• History of the Web
• Client / server principle
• Introduction and history of PHP
• How does PHP work ?
• PHP integration in an HTML web page
• The LAMP platform
• Discover the WAMP Server environment

PHP Basics

• Comments
• Print text on the screen
• Constants
• Variables
• Functions
• Arrays
• Superglobal variables
• Operators
• Control structures (loops and conditions)
• Cookies
• Sessions
• External files imports, libraries

Filesystem

• Open a text file
• Check if a file exists on the server
• Write contents in a text file
• Read a file's content

Databases

• Introduction to databases
• ACID principle
• Tables
• Fields
• Data types
• Primary keys
• Foreign keys and relations
• The SQL language (DDL, DML, DCL and TCL orders)
• Joins
• Transactions
• Access rights

MySQL 5

• Introduction to MySQL
• Storage engines
• Database creation
• Tables creation
• Add some relations between tables
• Insert initial data in the database
• Create a user with privileges
• PHPMyAdmin and MySQL Query Browser tools

MySQL and PHP

• Introduction to MySQLi
• Get connected to a MySQL database
• Execute SQL statements from PHP
• Request the database
• Run prepared statements

Advanced forms

• Data validation (regexp, empty fields...)
• Display in case of errors
• Data security
• HTML widgets manipulation

Image treatments

• Introduction to the GD library
• Files upload with forms
• Resizing a picture on the fly
• Filigran integration on a picture

Best webdevelopment practices

• Security : user's inputs validation and filtering
• Security : SQL injections protection
• Code refactoring
• Design : introduction to the MVC 1 pattern
• Coding conventions
• Working with an homemade framework
• Configuring Apache

Labs : e-commerce application

• Display a products list stored in the database
• Display a dedicated product page
• Generate a drop down list
• Create a functions library
• Create a products cart with cookies and sessions
• Create a form to suscribe to a newsletters
• Create an authentification form
• Create a securised products administration interface (list, create, edit and delete)
• Upload pictures with resizing and treatment