Dreamweaver, PHP & MySQL- 2 days

Look for available dates for this training course

This course is designed for those who are familiar with all basic Dreamweaver features such as site definition, the use of templates and the creation of websites using HTML and JavaScript. It focuses on the creation of dynamic web sites where web page content is linked to a database back-end. Although an overview of server side PHP coding is provided, this course does not involve any programming, rather it shows how to use Dreamweaver's built-in features to generate dynamic sites using PHP and MySQL.

PHP Essentials

Background to PHP
Installation and configuration
Embedding PHP tags
Adding comments
Using the Print function
Using variables
Dynamic variables
Data types

Connections

Databases and dynamic sites
Connecting to a MySQL database
Dreamweaver's connection folder

Displaying records

Adding dynamic content to pages
Creating Repeat Regions
Using Recordset Paging
Using Show Region
Displaying the current page
Using Live Data View

Filtering results with SQL

The use of variables
Setting default values
Setting run-time values
Naming variables
Creating the WHERE clause
Filtering numeric fields
Filtering text fields
Filtering date fields
Using wildcards

Editing database content

nsert Record
Naming form fields
Update Record
Repopulating the update form
Delete Record

Dynamic page elements

Making HTML attributes dynamic
Dynamic text
Dynamic images
Dynamic links
Dynamic drop-down menus
Dynamic radio buttons

User authentication

Creating a registration page
Check User Name
Creating a log in page
Log In User
Restrict Access to Page
Log Out User
Using levels in authentication

Back to top

Macresource Web Design and Web Development Training Courses
ActionScript training | Apache training |  ASP training | ASP.Net training
ColdFusion training |  Director Lingo training |  Dreamweaver training | Flash training
FrontPage training | GoLive training | HTML training | IIS training | JavaScript training
MySQL training | PHP training | Programming training | UltraDev training
Web Design training | XML training | Free Dreamweaver tutorials
London computer training room hire

© Copyright, Macresource 2011