Adobe Dreamweaver: Developing with PHP MySQL

Manchester (Greater)

Manchester (M4)

25/03/10

£

495

Manchester (M4)

13/05/10

£

495

Please click above and we will take care of the rest.

Please click above and we will be happy to discuss the benefits of onsite and bespoke courses with you.

If suitable dates or locations are not available, click this link and we will arrange one for you

Course Overview

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.

Audience

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.

Course Outline

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.