Jump to course:

PHP & MySQL

Overview

PHP and MySQL have become the development platform of choice for many professional web designers. PHP is widely supported and hosted on commercial websites without the need for expensive licences. There is a wealth of free resources and support tools to help you fully exploit the language and take advantage of open source projects. The PHP language is intuitive to learn and supported on both Windows and Linux platforms. Users familiar with languages such as C, Java, Visual BASIC and JavaScript will find the transition to PHP intuitive. MySQL is a powerful and scalable database. It provides a real alternative to commercial databases such as Oracle and SQL Server at a fraction of the usual costs.

Learn To

Understand the PHP language
Manipulate web form data
Work with sessions
Understand how to use and exploit cookies
Build databases and work with MySQL
Build dynamic web pages
Populate web sites with data from MySQL
Access and work with open source resources

…and much more

Course Content

Language Fundamentals
Encapsulating PHP within XHTML
Using scalar variables
PHPs different operators
Control Structures
Arrays in PHP
Variable Scope
Using References
Manipulating Form Data
POST vs GET for form input
Retrieving data from forms
Hidden Fields
Validating Input
Returning results to the user
Calling pages from themselves using forms
Variables, Expressions & Functions
Functions
Identifiers and Data Types
Accessing Environment Variables
Cookies
Setting and retrieving Cookies
Drawbacks of Cookies
Security implications of using Cookies
An Introduction to MySQL
Relational databases
Different versions of MySQL
Basic MySQL Management
Database Interaction
Storing data to a database
File Management
Working with files.
Opening files. R
Using file contents to populate web page
Include/Require
Array, date/time, filesystem and directory, mail, string
Regular expressions functions
Session variables
Managing Sessions
Registering session variables
Putting sessions IDs in pages
Creating a login system
PHP sessions and databases
Hiding PHP
Encrypting Passwords

Objectives

To be able to build and manipulate dynamic web pages using PHP and MySQL. To be able to setup a web database and use it in the contruction of a dynamically built websites.

Audience

Existing web designers familiar with XHTML coding techniques. Introductory programming experience is assumed.

Duration

4 Days

Elaine McGlynn – Authentik