Difference between revisions of "Dynamic Website Building Instruction and Practical Experience Group Study\Instructional Plan"

Revision as of 03:06, 16 September 2007

Plan

SeniorQuoter will be started to be worked on Day 17

Day 1

• Introduce Each Other
• Explain Server Technology
  • Make diagram
  • QnA Acronyms

Day 2

• Hand out FTP + SQL info
• Describe programs we are using
  • HTML Kit
  • Web Dev Toolbar
  • Firefox
  • Subversion
• First example (outputting data)
• White Space
• Comments

Day 3

• Variables
• Strings
• Concat
• Numbers

HW: Write a tip calc script

Day 4

• Constants
• Single and Double Quotes

HW: Add a splitting the bill section

• Catch-up

Day 5

(Chap 2)

• HTML Form
  • Create
  • Handel
• Magic Quotes

HW: Make tip calc a form

Day 6

• Conditions and Operators
  • IF statements
• Form Security (Data Validation)

HW:Secure the Tip Calc

Day 7

• Arrays
  • Creating
• Accessing
  • Multi-Dimension
• Arrays and Strings
• Sorting

HW: Re-read section

Day 8

• For and While Loops
• Catch-up
• ??HTML/CSS

HW: Decorate Tip Calc

Day 9

(Chap 3)

• Including Files
• Header and Footer
• Form on 1 page
• Sticky Form

HW:Make Tip Calc Sticky

Day 10

• Functions
  • Creating
  • Using
  • Augments
  • Default Augments
  • Returning Values

HW: Re-read section

Day 11

• Variable Scope
• Date and Time
• Send Email

HW: Make Tip Calc Send Mail

Day 12

Make up and Design

Day 13

(Chap 4)

• MySQL Databases
  • Column Types
  • Data Formats
  • Normalized Form
• PHPmyAdmin (instead of text-based admin)

HW: Design a Database (give a situation)

Day 14

• INSERT
• SELECT
• WHERE
• SORT BY
• LIMIT

HW: ??Related to above db

Day 15

• SQL Functions
  • Text
  • Numbers
  • Date/Time

Catch-up

Day 16

(Chap 5)

• Joins
• Indexes
• Table Types
• Full Text Search

Design Day??

Day 17

(Chap 6)

• Error Handling
  • Common Problems
  • Search Website
  • Ending }
• HTML Validation
• ?? Email Error Handler

Day 18

(Chap 7)

• PHP + MySQL
  • DB Connection
• Write only Queries
• Read Queries into Array

Day 19

• Secure SQL
• Updating records
• Catch-up

Day 20

• GET requests
• Hidden Forms
• Edit Records
• Pagination
• Sortable Displays

Day 21

• HTML Headers
  • Read
  • Modify
• Cookies and Sessions
  • Setting
  • Reading

Day 22

• • Parameters
    • Expire Date
  • Deleting
• Sessions
  • Setting
  • Modifying
• Security

Day 23

(Chap 10)

• Security!
  • Validating
  • Regex

Day 24

• Catch-up/Design

Day 25-On

SeniorQuoter!

• • Accessing