Title: PHP/MySQL Course

Category: Tertiary (ages 18+) — Prizewinners in this category:

1st - Janina Dewitz with eLearning and Moodle Essentials +++Lite+++
2nd - Martina Majorová with Úvod do štatistiky
Joint 3rd - Maryel Mendiola with Desarrollo Humano and Gerry Jenkins with PHP/MySQL Course

Role: Student — Students generally have fewer privileges within a course.

Section 1
  Read Me First - Orientation
  Syllabus
  Welcome Video
  Common Resources
  GJenkins Video Library (PHP/MySQL Class)
  PHP language reference documentation
  Installing the software for the course
  Accessing your Web Server
  W3Schools tutorials (excelent reference)
  KillerPHP.com Video Library (great extra material)
  Forums
  News forum
  Student forum - a place for students to talk to each other
Section 2
  Instructor comments on Chapter 1
  Base Level Learning Outcomes Survey ($$$)
  Basic HTML ($$$)
  CSS Lesson ($$$)
  Assignment: Create and publish your first web file ($$$)
  Using PHP program ($$$)
  your base php page
  Assignment: Publish your PHP program ($$$)
  Assignment: create a new PHP program ($$$)
  Topic 1 Quiz ($$$)
Section 3
  variables and data types ($$$)
  Play KillerPHP.com video on creating variables
  Play KillerPHP.com video on print and variable expansion
  Assignment: Chapter 5 variables ($$$)
  Assignment: variables activity ($$$)
  Assignment: comparisons activity ($$$)
  Flow Control ($$$)
  Assignment: color table ($$$)
  Assignment: Day of the Weeks ($$$)
  functions ($$$)
  Video on calling functions (step by step explained)
  Assigment: createTable4
  Topic 2 Quiz ($$$)
Section 4
  Arrays ($$$)
  Assignment: Deal Cards ($$$)
  Objected Oriented PHP (OOP)
  Video: Example of creating and using classes (Card Deck)
  Assignment: Class Deck ($$$)
  Strings,Dates, and Times ($$$)
  PHP Forms ($$$)
  Assignment: Guessing Game ($$$)
  Assignment: Birthday ($$$)
  Assignment: Chuck-a-luck ($$$)
  Topic 3 Quiz ($$$)
  ** Link to topic 3 videos
Section 5
  Play this video about file paths in PHP
  Uploading Files ($$$)
  Program to upload Picture ($$$)
  About State and Stateless web pages
  Cookies ($$$)
  Sessions ($$$)
  Assignment: Guessing Game 2 ($$$)
  using files ($$$)
  Assignment: Visitor count ($$$)
  please read the from were you left off in the book...
  Assignment: Working with Images ($$$)
  Topic 4 Quiz ($$$)
  NOTE: how to set file/folder permissions
Section 6
  Understanding Databases
  MySQL Basic Data Types and CREATE TABLE ($$$)
  Building a database from the command line (READ and VIEW)
  Program: Build a DB using SSH ($$$)
  Basic SQL Commands ($$$)
  Optional: read Chapter 17 on transactions and stor...
  Play this video introducing phpMyAdmin
  Play this video on how to create a DB in phpMyAdmin and enter data
  Program: Create a Database design
  Project: Import two databases
  Lab: Writing SQL statements
  Program interface to MySQL from PHP ($$$)
  CRUD basics
  Program: Contacts
Section 7
  About your final project
  Mailing List ($$$)
  Address Book ($$$)
  Discussion Forum ($$$)
  Store Front / Shopping Cart ($$$)
  Calendar ($$$)
  Extra Credit Survey ($$$)
Section 8
Section 9
Section 10
Section 11
Section 12
Section 13