Press → key to advance.
Zoom in/out: Ctrl or Command + +/-
Having issues seeing the presentation? Read the disclaimer
Databases:
As mentioned last week, we try not to repeat information in databases
The goal is to split your information up into tables, and then look at all of the tables to build our information back up
We call this normalization
For a portfolio site, we'll have a Content Management Side that looks one way, and a presentation side that looks another, since typical visitors won't be adding any content
Technical requirements are somewhat already decided (since we are going to use PHP/MySQL)
Data requirements are going to be similar to a blog post in terms of what information we need to keep track of
Today, we will concentrate on displaying repeated information and choosing what to display using query URLs
Often, we'll be using forms to enter information into our databases
It is important to always remember to "clean" your data before entry
Otherwise, people can run database commands and mess up your stuff!