1. Lời giới thiệu

Xây dựng các Website hướng dữ liệu sử dụng Dreamweaver MX cung cấp cho các học viên các kỹ năng về Dreamweaver và PHP để tích hợp cơ sở dữ liệu với Website

2. Đối tượng

Khóa học này rất phù hợp cho những người có liên quan đến các công việc như thiết lập, phát triển và bảo dưỡng một Website.

3. Yêu cầu trước khi tham gia khoá học

Để hoàn thành tốt khoá học, học viên cần phải:

• Có kiến thức về Marcomedia Dreamweaver

4. Các kỹ năng thu được

Sau khi hoàn thành khoá học, học viên có thể:

• Các học viên sẽ học được cách xây dựng Website hướng dữ liệu sử dụng Dreamwear MX, PHP và một cơ sở dữ liệu

5. Thời lượng: 30 giờ

Nội dung khóa học

Introduction

· Roles of server-side languages

· Choosing a server-side language

· Which server-side language is best?

· Overview of PHP and its requirements

· Goals of this class / Who is this class for?

Creating a Dreamweaver site

· Site creation - basic

· Site creation - advanced

Database connections

· Database basics

· Introduction to SQL

· Server behaviors

Querying the database

· Building a SQL query using the Simple view

· Building a SQL query using the Advanced view

· Adding fields from the resulting records to your page

Displaying and formatting query results

· Using Repeat Region to display multiple records

· Formatting results

Paging through records

· Schemes for recordset navigation

· Paging to first, last, previous, and next records

Show region if...

· Selectively displaying information based on a conditional

· Disabling the first and previous record links if the first page of results is displayed

· Disabling the last and next record links if the last page of results is displayed

Displaying the count of the number of records returned

Creating master-detail views

· Overview of the importance of master-detail views and how they convey information

· Creating a master-detail view

Advanced recordsets and multi-table queries

· Method 1 - Simple recordset with filter

· Method 2 - Advanced recordset

· Method 3 - Advanced recordset and multi-table Queries

Dynamically populating forms

· Populating text fields, text areas, and hidden fields

· Populating selection lists, radio button lists, and checkboxes

Building record insertion forms

· Building the insertion form by hand

· Allowing Dreamweaver to generate the record insertion form automatically

· Creating a page that confirms the record insertion

· Validating form entries using JavaScript behaviors

Understanding stored procedures

· How they are created in the database

· Advantages/disadvantages of stored procedures versus SQL

· Calling a stored procedure without passing parameters

· Passing input parameters to a stored procedure

· Retrieving parameters from a stored procedure

Updating records

· Manually constructing a form that allows the user to update a record

· Using Dreamweaver to automatically generate a form for updating the record

· Validating the edited information using JavaScript behaviors

· Building a confirmation page to display the result of updating the record

Deleting records

· Precautions to take to ensure that records are not inadvertently deleted

· Building an appropriate record deletion interface, complete with confirmation dialog

Implementing user login/logout with Dreamweaver MX 2004

· Overview of Web application security issues

· Preferred approach: configuring the Web server to manage security

· Alternative approach: having Dreamweaver automatically generate code for logging users in, authenticating them, and logging them out

· In-depth instruction on using Dreamweaver MX 2004 with PHP to implement user login/logout and page-by-page authentication

Conclusion