Dynamic Website Building Instruction and Practical Experience Group Study\Instructional Plan

Dynamic Website Building Instruction and Practical Experience Group Study Instructional Plan for the first half of the quarter.

See also Dynamic Website Building Instruction and Practical Experience Group Study\Senior Quoter Plan

Day 1

• Introduce Each Other
• Why Learn PHP/MySQL: $$: http://www.bls.gov/oco/ocos267.htm
• Publicity ok?
• 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!