Week 3
Picking up where we left off
- Start with last week's code
Intro to MySQL
- SQL Basics
- Hello world.sql
- SELECT
- LIMIT
- WHERE
- OR
- AND
- ORDER BY
- INSERT
- UPDATE
- DELETE
- CREATE DATABASE
- DROP DATABASE
- CREATE TABLE
- DROP TABLE
- CREATE USER
- GRANT
- Connect to MySQL with PHP
- mysqli
- Security warning: SQL injections
- phpMyAdmin
- MySQL Basics
- Column types
- Keys and indexes
- Collation (just use
utf8_unicode_ci) - Storage engines (just use
InnoDB)
- Create table for Cattitude84 product data
- Relational Database Design Basics
- One to one
- One to many
- Many to many
- Create additional tables for Cattitude84 database
- Make index.php data driven
Further Reading
- SQL for Beginners
- SQL Injections
- Related Chapters in the Book: 25-30
Lab Time
- Design database for your personal project
- Connect to MySQL database with PHP