Course Outline
The PHP scripting language is predominantly used to add executable content to Web pages. This course will teach you the fundamentals of programming in PHP, as well as Web-related issues such as linking a series of forms together into a session, maintaining state if multiple users are on your site at the same time, cookies, and security. The course also covers PHP's interfacing to relational databases in some depth, with a particular study of MySQL.
If you do not require MySQL then we can reduce duration and cover only PHP content.
Course Content
Our hands-on PHP Web Development with MySQL Training course has been developed for real-world, commercial scenarios by our expert instructors. The course has a strong practical bias, with a a series of exercises building upon one another. By the end of the course you will have produced a PHP web application which uses a database to store, retrieve and edit restaurant menu items. We provide the initial HTML templates and you will transform them into a working application.
See below for detailed syllabus, or if you have a technical question, please email sales@jbinternational.co.uk
What you will learn
- Setting up PHP on a web server
- How to hand-code PHP applications
- Display, read and write to databases from your web pages
- Best practise - writing well-optimised, secure PHP code
PHP Web Development with MySQL Training Course
Introduction to PHP
Sourcing and installing PHP, Apache, MySQL (LAMP, WAMP, XAMP...)
PHP language & syntax basics
- Variables
- Data structures
- Conditional statements and loops - if, else, foreach, for, while
File structure
Key concepts - Operators, Arrays, Variables, Data Types
Variable notation
Sending email from PHP
Files
Reading, Writing, Deleting
Algorithms & Numbers
- Creating simple algorithms
- Converting algorithms into pseudo-code
Type Casting
Handling
Strings
Processing
Display
Formatting
Tokenising
Regular expressions
Arrays
Single
Multi dimensional
Hashes
Basic Web server architecture
Overview of Apache
Creating Dynamic PHP Pages & Forms
Handling form submission
Appropriate data checks
Introduction to the Standard PHP Library (SPL)
PHP Performance tips and Best Practises
Data sanitisation and security
Caching and code profiling / optimisation
Design tips to help you produce good, maintainable web applications
Using MySQL
SQL language basics
Building simple relational tables with MySQL
Reading & writing to MySQL from your PHP application
Deleting MySQL data / tables through PHP
Security considerations
