Basic concepts
• Components of a Database-driven Site
• Background to PHP
• Background to MYSQL
Phpmyadmin
• Create and drop databases
• Create, copy, drop, rename and alter tables
• Delete, edit and add fields
• Manage MySQL users and privileges
Set up the Dreamweaver environment
• Defining your site
• Set up a database connection
Working with Recordsets
• Creating Recordsets
• Displaying Records
• Paging Through Recordsets |
Creating Detail, Search, and Results Pages
• Creating Master-Detail Pages
• Creating Search and Results Pages
Dynamic Form and HTML Elements
• Creating Dynamic Form Elements
• Dynamic HTML Elements
Administering Database Records
• Inserting Records
• Editing Records
• Deleting Records
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 |
