Tue March 4

I've posted a "backend project" assignment.

Discuss SQL databases : what they are & how to use them.

• wikipedia: database model
• wikibooks: sql exercises - the warehouse
• sqlite syntax
• php + sqlite3 example
• Jim short examples

We'll work through some examples of creating a database and working with it from the command line and from php on shannon.

Your mission : incorporate this stuff into the backend project, including designing a (simple) sqlite database.

coming : passwords, cookies, sessions

• passwords - salt
• cookies | php cookies

(php has a built-in "session" thingy ... but you may well want to manage your own with explicit cookies.)

coming : security

• sql injection
  • xkcd
  • php sql injection
  • prepared statements