Parkland College > Fine & Applied Arts > Graphic Design | Web Design >
Student Links > GDS 215 > Exercise #4b

GDS 215 WEB DESIGN III
Exercise #4b: Introduction to PHP (continued)
Instructor: Paul Young

Objective

To learn Dreamweaver's dynamic page functions and database tools by recreating these maintenance pages.

Procedure

prepping for the exercise

1. launch dreamweaver, open site "e4-rocky"
2. new folder "private"
3. new file "ok.html", open
4. copy text from example file into "ok.html"
5. link CSS style sheet
6. create links "appearances-edit.php", "appearances-delete.php"
7. save, save as "appearances-edit.php"

creating the insert form

1. window > bindings: + record set (query) (this is file specific)
   connection: ep
   table: jsmith
   filter: none
   sort: ID (ascending)
2. copy additional text from example file
3. create form1, create table (2 col x 4 rows, width=500, cell padding=5, vertical=top)
4. insert textfields: "date", "date_print", "text"
5. insert checkbox "visible": checked value=1
6. insert button "insert" (submit form)
7. insert button "reset" (reset form)
8. window > server behaviors: + insert record (fill out form)
9. save, upload (cmd+shift+U), preview (F12)
10. check results at: http://65.61.219.1/MyAdmin/indexsite.php
    user: paulananda2
    pw: _______________

creating the edit form

1. create form2, create table (2 col x 4 rows, width=500, cell padding=5, vertical=top)
2. insert textfields: "date2", "date_print2", "text2"; bind to dynamic source (drag appropriate binding into each textfield)
3. insert checkbox "visible2": bind to dynamic source (visible=1)
4. insert hidden field "ID": bind to "ID"
5. insert button "save" (submit form)
6. insert button "reset" (reset form)
7. window > server behaviors: + update record (fill out form)
8. select form: + repeat region (show all)
9. save, upload (cmd+shift+U), preview (F12)

creating the delete form

1. save as "appearances-delete.php"
2. delete uneeded server behaviors, forms, fields
3. insert dynamic fields: "date", "date_print", "text" (drag appropriate binding into each textfield)
4. insert hidden field "ID": bind to "ID"
5. insert button "delete" (submit form)
6. window > server behaviors: + delete record (fill out form: first check if "primary key value" is defined; primary key value=form variable "ID")
7. select form: + repeat region (show all)
8. save, upload (cmd+shift+U), preview (F12)
9. make links to your work from your projects page
10. test on a PC

Schedule

See Calendar.

______________________________

Last updated: 2/29/04 • Webmaster: Paul Young

Student
Exhibition

Influential
Designers

Internet
Resources

Tips, Tricks
& Handouts

Student
Links