PHP / MySQL Development

About this class

This course is aimed at anyone involved in web design and development who would like to learn how to build dynamic database driven websites using PHP and MySQL.

Who will the lesson benefit?

You should have a basic understanding of Dreamweaver before taking this course. Be able to create and manage pages and sites and be familiar with internet. A basic knowledge of HTML code is desirable but not essential.

Contents of this class

Introduction To MySQL

• Understanding Database Structure
• Creating a Database
• Basic SQL Commands

Introduction to PHP

• Language basics
• Data types in PHP
• Understanding and working with arrays, variables, data types
• Processing data using operators

Creating Dynamic Content

• Embedding PHP in Web Pages
• Using forms to capture user input
• Use of the date and time
• Using 'include' & 'require' to dynamically include code

Control Structures

• Decision making - if / else / else if
• Evaluation of expressions and "true" and "false"
• Multiple and nested conditions
• The "?" Operator
• Loops
• Terminating Code

Functions

• Built in Functions:
• Mathmatical
• Strings
• Random Numbers
• Custom functions:
• Syntax for defining functions
• Variable Scope
• Function parameters
• Return Values

PHP & MySQL - Working Together

• Connecting to the Database
• Displaying Database content using PHP
• Adding and deleting database data
• Updating database.