View Basket
Recover Basket
Dreamweaver Advanced Using PHP & MySQL-
2 days
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
Connecting to a MySQL database
Dreamweaver's connection folder
Displaying records
Creating Repeat Regions
Using Recordset Paging
Using Show Region
Displaying the current page
Using Live Data View
Filtering results with SQL
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