Skip to main content
MPCC
Back to Website
Enter your search query
You are currently using guest access (
Log in
)
PHP/MySQL Course
Home
Courses
Miscellaneous
MoodleShare Archive
MoodleShare Technology
PHP/MySQL
General
GJenkins Video Library (PHP/MySQL Class)
GJenkins Video Library (PHP/MySQL Class)
GJenkins Video Library
Click
http://web.me.com/gerryjenkins/php/index.html
link to open resource.
◄ Welcome Video
Jump to...
Jump to...
Read Me First - Orientation
Syllabus
Welcome Video
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)
News forum
Student forum - a place for students to talk to each other
Download a Copy of this Course
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 ($$$)
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 ($$$)
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
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 ($$$)
Assignment: Working with Images ($$$)
Topic 4 Quiz ($$$)
NOTE: how to set file/folder permissions
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 ($$$)
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
About your final project
Mailing List ($$$)
Address Book ($$$)
Discussion Forum ($$$)
Store Front / Shopping Cart ($$$)
Calendar ($$$)
Extra Credit Survey ($$$)
PHP language reference documentation ►