database concepts
Week 11
Course synopsis, what's next
Why you want to keep doing this
My quiz solution and why
Your projects
Week 10
Incorporate Membership into Forum
Advanced Searching/Advanced Filters/Dynamic Queries
Help with projects
Review Search
Week 9
Wdim cart finished
forum
Search week!
Take home quiz: due in week 11 unless your name ends with "Coulstring"
Week 8
Homework Answers
Pagination and the Limit tag
Wdim cart and its organization
Integration of membership system with anything.
Cron Backup
Unions
Project time
Week 7
Finish Membership system
Users online
Practice Queries
Project Help
Week 6
Midterm Answers
More on normalization
Time for our good old membership system
week 6 materials
Week 5
Go over ERD's
Midterm (take home)
Week 4
Here is a screencast for what we did in week 3: http://screencast-o-matic.com/watch/cIfYbbV0aK
Homework answer
Aggregates
Project steps...list, organize, diagram
Your projects/ERD help
Turning out gallery into a simple blog
Then a shopping cart
Week 3
Onto 2 table relational systems
The problem with BLOB Data
week 3 materials
Week 2
Extending our script from last week to include updates
Extending that further with more fields
<?php
//Insert Statement:
prepare("INSERT INTO table_name (column1,column2,column3) VALUES (value1,value2,value3)");
//Update Statement:
prepare("UPDATE table_name SET column1 = value1, column2 = value2 WHERE some_column = some_value");
//Select Statement - Selects everything in a specified table:
prepare("SELECT * FROM table_name");
//Select Statement - Selects specific columns from table where specified column = specified value:
prepare("SELECT column1, column2 FROM table_name WHERE some_column = some_value");
//Delete Statement:
prepare("DELETE FROM table_name WHERE some_column = some_value");
?>
Adding a photo
Password protect it
sql data types
Week 1
Class Expectations
Intro/class policy
Intro to phpMyAdmin
Some sql queries
What id pdo?
Terminology
Getting hooked up
A simple login script/Your first select statement
Our first relational db