PHP/MySQL Course

Topic outline

• 

  General

  • Read Me First - Orientation Page
  • Syllabus Page
  • Welcome Video URL
  • Common Resources
  • GJenkins Video Library (PHP/MySQL Class) URL
  • PHP language reference documentation URL
  • Installing the software for the course Page
  • Accessing your Web Server Page
  • W3Schools tutorials (excelent reference) URL
  • KillerPHP.com Video Library (great extra material) URL
  • Forums
  • News forum
  • Student forum - a place for students to talk to each other
  • Download a Copy of this Course File 16.8MB
• 

  Topic 1

  Topic 1: Web Technologies Review and Intro to PHP (Due 9/16)
  

  Goals for this Topic:
  

  • Learn/review some basic HTML and CSS
  • Learn about the client/server context that HTML and PHP
  • Create some simple PHP pages
  • Publish your first PHP applications using a FTP Client

  • Instructor comments on Chapter 1 Page
  • Base Level Learning Outcomes Survey ($$$) Assignment
  • Basic HTML ($$$) Lesson
  • CSS Lesson ($$$)
  • Assignment: Create and publish your first web file ($$$)
  • Using PHP program ($$$) Lesson
  • your base php page
  • Assignment: Publish your PHP program ($$$)
  • Assignment: create a new PHP program ($$$)
  • Topic 1 Quiz ($$$)
• 

  Topic 2

  Topic 2: PHP Programming language I (Due 9/30)
  
  

  Goals for Topic 2:
  

  • Start learning the language syntax
  • Variables and data types
  • expressions and operators
  • control flow (if, loops, switch)
    
  • functions
    

  • variables and data types ($$$) Lesson
  • Play KillerPHP.com video on creating variables URL
  • Play KillerPHP.com video on print and variable expansion URL
  • Assignment: Chapter 5 variables ($$$)
  • Assignment: variables activity ($$$)
  • Assignment: comparisons activity ($$$)
  • Flow Control ($$$) Lesson
  • Assignment: color table ($$$)
  • Assignment: Day of the Weeks ($$$)
  • functions ($$$) Lesson
  • Video on calling functions (step by step explained) URL
  • Assigment: createTable4 Assignment
  • Topic 2 Quiz ($$$)
• 

  Topic 3

  Topic 3: PHP Programming Language II (Due 10/14)
  
  

  Goals for topic 3
  Arrays
  Objects
  Strings, Dates, Time
  Working with Forms
  Sending Mail
  

  • Arrays ($$$) Lesson
  • Assignment: Deal Cards ($$$)
  • Objected Oriented PHP (OOP) Page
  • Video: Example of creating and using classes (Card Deck) URL
  • Assignment: Class Deck ($$$)
  • Strings,Dates, and Times ($$$) Lesson
  • PHP Forms ($$$) Lesson
  • Assignment: Guessing Game ($$$)
  • Assignment: Birthday ($$$)
  • Assignment: Chuck-a-luck ($$$)
  • Topic 3 Quiz ($$$)
  • ** Link to topic 3 videos URL
• 

  Topic 4

  Topic 4: Programming More Details (Due 10/29)
  
  

  Goals for topic 4
  

  • Uploading files
    
  • Working with cookies
    
  • Sessions
  • Working with the file system
  • Reading and writing files
  • Some fun with images
    

  • Play this video about file paths in PHP URL
  • Uploading Files ($$$) Lesson
  • Program to upload Picture ($$$) Assignment
  • About State and Stateless web pages
  • Cookies ($$$) Lesson
  • Sessions ($$$) Lesson
  • Assignment: Guessing Game 2 ($$$)
  • using files ($$$) Lesson
  • Assignment: Visitor count ($$$)
  • please read the from were you left off in the book to the end of page 259.
    We are skipping pages 260 to 165.
    
  • Assignment: Working with Images ($$$)
  • Topic 4 Quiz ($$$)
  • NOTE: how to set file/folder permissions Page
• 

  Topic 5

  Topic 5: MySQL and using it from PHP (Due 11/17)
  
  

  Goals for topic 5
  

  • Database design
    
  • Basic SQL
  • Transactions and stored procs
  • php code for MYSQL
  • Work with records (INSERT, SELECT, UPDATE, DELETE) : CRUD
    

  • Understanding Databases Page
  • MySQL Basic Data Types and CREATE TABLE ($$$) Lesson
  • Building a database from the command line (READ and VIEW) Page
  • Program: Build a DB using SSH ($$$) Assignment
  • Basic SQL Commands ($$$) Lesson
  • Optional: read Chapter 17 on transactions and stored procedures (pages 353-360).
  • Play this video introducing phpMyAdmin URL
  • Play this video on how to create a DB in phpMyAdmin and enter data URL
  • Program: Create a Database design Assignment
  • Project: Import two databases Assignment
  • Lab: Writing SQL statements Assignment
  • Program interface to MySQL from PHP ($$$) Lesson
  • CRUD basics Page
  • Program: Contacts Assignment
• 

  Topic 6

  Topic 6: Study of Applications (Due 12/16)
  
  

  Goals for topic 6 (Final Project)
  

  • Mailing List
  • Address Book
  • Discussion Forum
  • Store Front
  • Shopping Cart
  • Calendar
    

  • About your final project Page
  • Mailing List ($$$) Assignment
  • Address Book ($$$) Assignment
  • Discussion Forum ($$$) Assignment
  • Store Front / Shopping Cart ($$$) Assignment
  • Calendar ($$$) Assignment
  • Extra Credit Survey ($$$) Assignment
• 

  Topic 7

  Not available
• 

  Topic 8

  Not available
• 

  Topic 9

  Not available