Press key to advance.

Zoom in/out: Ctrl or Command + +/-

Having issues seeing the presentation? Read the disclaimer

Intro

Databases

SVA

Databases:

  • Systems for storing information
  • For our purposes: Information is split into Tables, which are then split into rows and columns
  • Columns are named (kinda like array keys) and rows contain data

Intro

MySQL

SVA

  • Open Source Project
  • Owned by Oracle now
  • We will interact with it via phpMyAdmin

Database

Design

SVA

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

Database

Design

SVA

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

Database

Security

SVA

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!