Dynamic Website Building Instruction and Practical Experience Group Study\Instructional Plan
From ThePlaz.com
Contents |
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
- 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
- Parameters
- Sessions
- Setting
- Modifying
- Security
Day 23
(Chap 10)
- Security!
- Validating
- Regex
Day 24
- Catch-up/Design
Day 25-On
SeniorQuoter!
- Accessing