Audio for CIS159/CIT32 - PHP and MySQL

Category Information - Frequently you will find that the audio goes well with the Smartboard
Audio/Lectures - Spring 2017
First day, review of HTML, introPHP (1/24/17) Accompanying Smartboard presentations
PHP - intro Group One (1/26/17) Accompanying Smartboard presentations
Group Two PHP (1/31/17) Accompanying Smartboard presentations
Group Three PHP and Group Three Plus PHP (2/2/17) Accompanying Smartboard presentations
Boston Tea Party and More IFs (2/7/17) Accompanying Smartboard presentations
Loops (2/14/17) Accompanying Smartboard presentations
SQL with MySQL in Putty (2/16/17) Accompanying Smartboard presentations
More SQL (2/28/17) Accompanying Smartboard presentations
Continuing SQL (3/2/17) Accompanying Smartboard presentations
Keys and multiple tables in SQL (3/7/17) Accompanying Smartboard presentations
Connect to MySQL from PHP (3/9/17) Accompanying Smartboard presentations
Continuing connect to MySQL from PHP (3/23/17) Accompanying Smartboard presentations
Maintain and intro arrays (3/28/17) Accompanying Smartboard presentations
Functions (4/4/17) Accompanying Smartboard presentations
Updates (4/6/17) Accompanying Smartboard presentations
Arrays (4/11/17) Accompanying Smartboard presentations
More Arrays (4/13/17) Accompanying Smartboard presentations
Images and databases (4/18/17) Accompanying Smartboard presentations
Email, images, databases (4/25/17) Accompanying Smartboard presentations
Alumni questions and answers, cookies (5/2/17) Accompanying Smartboard presentations
Sessions (5/4/17) Accompanying Smartboard presentations
Audio/Lectures - Spring 2016
First day, review of HTML, introPHP (1/21/16) Accompanying Smartboard presentations
Second day - more intro PHP (1/26/16) Accompanying Smartboard presentations
The audio for Feb 2, 2016 is missing. Spring 2015 has PHP ThirdGroup IF that was recorded 2/3/15. I suggest you listen to that and look at the accompany Smartboard.
PHP IF statements & Boston Tea (2/4/16) Accompanying Smartboard presentations
I was sick and out the 9th, 11th and 16th so there are no recordings or notes. I suggest you look for the topics in the Spring 2015 or before. Since this is a hybrid class, there was information and assignments posted.
MySQL/MariaDB login and SQL (2/23/16) Accompanying Smartboard presentations
SQL continued (2/25/16) Accompanying Smartboard presentations
SQL keys, multiple tables and subqueries (3/1/16) Accompanying Smartboard presentations
SQL subqueries & inclass work(3/1/16) Accompanying Smartboard presentations
Connect PHP/database (3/8/16) Accompanying Smartboard presentations
Connect continued (3/10/16) Accompanying Smartboard presentations
Connect and maintain (3/22/16) Accompanying Smartboard presentations
Intro arrays (3/24/16) Accompanying Smartboard presentations
Continuing arrays (4/5/16) Accompanying Smartboard presentations
More arrays (4/7/16) Accompanying Smartboard presentations
Arrays and intro images (4/12/16) Accompanying Smartboard presentations
Arrays, images, database tables (4/14/16) Accompanying Smartboard presentations
Builtin functions and email (4/19/16) Accompanying Smartboard presentations
Functions (4/26/16) Accompanying Smartboard presentations
Sessions and cookies (4/28/16) Accompanying Smartboard presentations
Audio/Lectures - Spring 2015
First day and review of HTML (1/22/15) Accompanying Smartboard presentations
PHP FirstGroup and SecondGroup (1/29/15) Accompanying Smartboard presentations
PHP ThirdGroup IF (2/3/15) Accompanying Smartboard presentations
PHP ThirdGroup Plus and Boston Tea Party (2/5/15) Accompanying Smartboard presentations
Tuesday was online day.
Fourth Group and intro MySQL (2/12/15) Accompanying Smartboard presentations
Continuing MySQL (2/17/15) Accompanying Smartboard presentations
More MySQL (2/24/15) Accompanying Smartboard presentations
Still More MySQL (2/26/15) Accompanying Smartboard presentations
Relational Database (3/3/15) Accompanying Smartboard presentations
Working with connections (3/10/15) Accompanying Smartboard presentations
Connect examples (3/12/15) Accompanying Smartboard presentations
Maintaining DB table (3/24/15) Accompanying Smartboard presentations
Continue maintain and intro arrays (3/26/15) Accompanying Smartboard presentations
Arrays (3/31/15) Accompanying Smartboard presentations
More Arrays (4/2/15) Accompanying Smartboard presentations
The week of April 6th was online.
Continuing Arrays (4/14/15) Accompanying Smartboard presentations
Images (4/16/15) Accompanying Smartboard presentations
Functions (4/21/15) Accompanying Smartboard presentations
Email (4/23/15) Accompanying Smartboard presentations
Email and sessions (4/30/15) Accompanying Smartboard presentations
Guess with sessions (5/5/15) Accompanying Smartboard presentations
Audio/Lectures - Spring 2014
First day and review of HTML (1/23/14) Accompanying Smartboard presentations
Alternate: First day and review of HTML (1/23/14) Accompanying Smartboard presentations
Login and intro PHP (1/28/14) Accompanying Smartboard presentations
Basic PHP (1/30/14) Accompanying Smartboard presentations
PHP Decisions - First part of lecture (2/4/14) Accompanying Smartboard presentations
PHP Decisions - Recording problem so I did at home (2/4/14) Accompanying Smartboard presentations
PHP Decisions and intro Loops (2/6/14) Accompanying Smartboard presentations
PHP Loops (2/11/14) Accompanying Smartboard presentations
If, alternate structures, putty (2/13/14) Accompanying Smartboard presentations
MySQL (2/18/14) Accompanying Smartboard presentations
Continuing MySQL (2/18/14) Accompanying Smartboard presentations
Using SQL (2/25/14) Accompanying Smartboard presentations
Functions, subqueries etc in SQL (2/27/14) Accompanying Smartboard presentations
Multitables and connecting thru PHP (3/4/14) Accompanying Smartboard presentations
SQL in PHP (3/6/14) Accompanying Smartboard presentations
Presentation by Meditech
Relational databases (3/25/14) Accompanying Smartboard presentations
Maintenance on tables (3/27/14) Accompanying Smartboard presentations
More maintenance and intro to arrays (4/1/14) Accompanying Smartboard presentations
Continuing arrays (4/3/14) Accompanying Smartboard presentations
Associative arrays (4/10/14) Accompanying Smartboard presentations
Functions (4/15/14) Accompanying Smartboard presentations
More Functions and Intro Images (4/17/14) Accompanying Smartboard presentations
Images from tables and intro email (4/24/14) Accompanying Smartboard presentations
Continuing email (4/29/14) Accompanying Smartboard presentations
Cookies and sessions (5/1/14) Accompanying Smartboard presentations
Audio/Lectures - Spring 2013
First day and review of HTML (1/24/13) Accompanying Smartboard presentations
Intro to PHP and logging to cisweb (1/29/13) Accompanying Smartboard presentations
More PHP intro (1/31/13) Accompanying Smartboard presentations
PHP and decisions (2/5/13) Accompanying Smartboard presentations
Loops in PHP (2/7/13) Accompanying Smartboard presentation
Loops and login to MySQL (2/12/13) Accompanying Smartboard presentations
Intro MySQL (2/14/13) Accompanying Smartboard presentations
Continuing SQL in MySQL (2/19/13) Accompanying Smartboard presentations
Questions and relational database in MySQL (2/26/13) Accompanying Smartboard presentations
Relational database and multiple tables and keys in MySQL (2/28/13) Accompanying Smartboard presentations
Subqueries in MySQL (first part) (3/5/13) Accompanying Smartboard presentations
Class work in MySQL (second part) (3/5/13) Accompanying Smartboard presentations
PHP connections to MySQL (3/7/13) Accompanying Smartboard presentations
SQL in MySQL (3/12/13) Accompanying Smartboard presentations
Maintaining tables (3/26/13) Accompanying Smartboard presentations
Intro arrays (3/28/13) Accompanying Smartboard presentations
More arrays (4/2/13) Accompanying Smartboard presentations
Working with arrays (4/4/13) Accompanying Smartboard presentations
Arrays and intro functions (4/9/13) Accompanying Smartboard presentations
Functions (4/11/13) Accompanying Smartboard presentations
Images (4/16/13) Accompanying Smartboard presentations
Binhex functions and then email (4/18/13) Accompanying Smartboard presentations
Email and database (4/25/13) Accompanying Smartboard presentations
Data manipulation thru functions (4/30/13) Accompanying Smartboard presentations
Cookies and sessions (5/2/13) Accompanying Smartboard presentations
Audio/Lectures - Spring 2012
First day and review of HTML (1/24/12) Accompanying Smartboard presentations
Intro PHP and using server (1/26/12) Accompanying Smartboard presentations
Collecting and passing data to PHP (1/31/12)Accompanying Smartboard presentation
Print/echo, quotes, if (2/7/12) Accompanying Smartboard presentations
Decisions (2/9/12)Accompanying Smartboard presentation
Loops in PHP (2/14/12)Accompanying Smartboard presentation
Loops in PHP and login to putty for databases (2/16/12)Accompanying Smartboard presentation
mySQL and SQL and problems with Smartboard (2/23/12)No accompanying Smartboard presentation
mySQL and SQL continued (2/28/12)Accompanying Smartboard presentation
More SQL and relational database (3/1/12)Accompanying Smartboard presentation
Database with multiple tables (3/6/12)Accompanying Smartboard presentation
SQL subroutines and functions (3/8/12)Accompanying Smartboard presentation
PHP and MySQL intro (3/20/12)Accompanying Smartboard presentation
Connecting cont and intro array (3/22/12)Accompanying Smartboard presentation
Tuesday, March 27th was an open lab day.
Arrays (3/29/12)Accompanying Smartboard presentation
Query Database and SQL (4/3/12)Accompanying Smartboard presentation
Updating Database (4/5/12)Accompanying Smartboard presentation
Functions (4/10/12)Accompanying Smartboard presentation
Functions, PHP and images (4/12/12)Accompanying Smartboard presentation
Images (arrays and files) (4/17/12)Accompanying Smartboard presentation
email (4/24/12)Accompanying Smartboard presentation
email and datbases (4/26/12)Accompanying Smartboard presentation
functions and misc. (5/1/12)Accompanying Smartboard presentation
Sessions and cookies etc (5/3/12)Accompanying Smartboard presentation
Audio/Lectures - Spring 2011
First day and review of HTML (1/25/11) Accompanying Smartboard presentations
Intro PHP and using server (2/1/11) Accompanying Smartboard presentations
PHP basic examples (2/3/11) Accompanying Smartboard presentations
PHP decisions and print/echo (2/8/11) Accompanying Smartboard presentations
PHP decisions and debugging (2/10/11) Accompanying Smartboard presentations
Starting Putty (2/15/11) Accompanying Smartboard presentations
More Putty and SQL (2/17/11) Accompanying Smartboard presentations
SQL(2/24/11) Accompanying Smartboard presentations
More SQL(3/1/11) Accompanying Smartboard presentations
Connection (3/8/11) Accompanying Smartboard presentations
PHP loops (3/10/11) Accompanying Smartboard presentations
PHP arrays and functions (3/22/11) Accompanying Smartboard presentations
More arrays and functions (3/24/11) Accompanying Smartboard presentations
Connecting and SQL (3/29/11) Accompanying Smartboard presentations
Arrays, connecting and SQL (3/31/11) Accompanying Smartboard presentations
Maintaining the database from PHP (4/5/11) Accompanying Smartboard presentations
Images in PHP (4/12/11) Accompanying Smartboard presentations
Email in PHP (4/19/11) Accompanying Smartboard presentations
Email & database (4/26/11 end missing) Accompanying Smartboard presentations
Email & database (4/26/11 looks complete) Accompanying Smartboard presentations
Functions (4/28/11) Accompanying Smartboard presentations
Sessions (5/3/11) Accompanying Smartboard presentations
Audio/Lectures - Spring 2010 Intro to HTML (1/25/10)Accompanying Smartboard presentation
HTML and PHP intro (1/27/10)Accompanying Smartboard presentation
PHP basics (2/1/10)Accompanying Smartboard presentation
PHP inclass project (2/3/10)Accompanying Smartboard presentation
PHP if statements (2/8/10)Accompanying Smartboard presentation
PHP if and loops (2/15/10)Incomplete (recorder issues) Accompanying Smartboard presentation
I am going to try and get another copy from a student so you can check back.
PHP if and loops provided by Russell (2/15/10)Accompanying Smartboard presentation
PHP loops and intro to Putty (2/17/10)Accompanying Smartboard presentation
Intro to Putty and SQL (2/22/10)Accompanying Smartboard presentation
More SQL (2/24/10)Accompanying Smartboard presentation
Relational DB and multiple tables (3/1/10)Accompanying Smartboard presentation
Subqueries, indexes etc (3/3/10)Accompanying Smartboard presentation
Introduction to arrays (3/8/10)Accompanying Smartboard presentation
Arrays - focus on practice sheet (3/10/10)Accompanying Smartboard presentation
Arrays and functions (3/29/10)Accompanying Smartboard presentation
Connecting to databases, lab (3/31/10)Accompanying Smartboard presentation
Connecting and querying (4/5/10)Accompanying Smartboard presentation
More connecting and querying (4/7/10 (partial))Accompanying Smartboard presentation
Updating and images (4/12/10)Accompanying Smartboard presentation
Intro inclass project images (4/14/10)Accompanying Smartboard presentation
Email through PHP (4/21/10 problem so summary)Accompanying Smartboard presentation
Email and databases (4/26/10)Accompanying Smartboard presentation
Functions (4/28/10)Accompanying Smartboard presentation
Cookies (5/3/10)Accompanying Smartboard presentation
Sessions and problem(5/5/10)Accompanying Smartboard presentation
More Sessions (5/10/10)Accompanying Smartboard presentation
Audio/Lectures - Spring 2009 Intro to HTML (1/20/09)Accompanying Smartboard presentation
More HTML/XHTML from CIS44 site (1/22/09)Accompanying Smartboard presentation
Logging in to cisweb and intro PHP (1/23/09)Accompanying Smartboard presentation
Intro PHP - variables and passing (1/27/09)Accompanying Smartboard presentation
Print, echo and more PHP with sentence code (1/29/09)Accompanying Smartboard presentation
If structures (1/30/09)Accompanying Smartboard presentation
Boston Tea Party and more if structures (2/3/09)Accompanying Smartboard presentation
Loops (2/5/09)Accompanying Smartboard presentation
Finishing Basic Loops (2/6/09)Accompanying Smartboard presentation
Using putty and MySQL (2/10/09)Accompanying Smartboard presentation
SQL and MySQL (2/12/09)Accompanying Smartboard presentation
More SQL and MySQL (2/13/09)Accompanying Smartboard presentation
Multiple tables (2/19/09)Accompanying Smartboard presentation
Design of relational DB (2/20/09)Accompanying Smartboard presentation
SQL index, keys, subqueries and PHP introduction to functions (2/24/09)Accompanying Smartboard presentation
Functions and Binary Game to convert to hex (2/26/09)Accompanying Smartboard presentation
Introduction to Arrays (3/3/09)Accompanying Smartboard presentation
I was out sick on Thursday.
More Arrays (handout in week of) (3/6/09)Accompanying Smartboard presentation
Connecting PHP and MySQL (3/12/09)Accompanying Smartboard presentation
Connecting continued (3/13/09)Accompanying Smartboard presentation - problem - see handouts on week of
Connecting queries and create (3/24/09)Accompanying Smartboard presentation
Connecting queries and create cont (3/26/09)Accompanying Smartboard presentation
Updating database through PHP (3/31/09)Accompanying Smartboard presentation
Images and databases (4/2/09)Accompanying Smartboard presentation
Starting email with PHP (4/7/09)Accompanying Smartboard presentation
The audio for 4/9/09 was a problem.
More email with PHP (4/10/09)Accompanying Smartboard presentation
PHP functions (4/14/09)Accompanying Smartboard presentation
PHP functions cont (4/16/09)Accompanying Smartboard presentation
Images on file example (4/17/09)Accompanying Smartboard presentation
Cookies (4/21/09)Accompanying Smartboard presentation
Quiz assignment and sessions (4/24/09)Accompanying Smartboard presentation
Continue sessions and student projects (4/30/09) Accompanying Smartboard presentations
Audio/Lectures - Spring 2008 Intro to HTML (1/22/08)Accompanying Smartboard presentation
More HTML (1/24/08)Accompanying Smartboard presentation
Intro to PHP and WinSCP3 (1/25/08)Accompanying Smartboard presentation
PHP basics (1/29/08)Accompanying Smartboard presentation
Forms and Passing (1/31/08)Accompanying Smartboard presentation
Boston Tea Party and Conditions (2/1/08)Accompanying Smartboard presentation
Intro to MySQL (2/5/08)Accompanying Smartboard presentation
The two classes below were very interactive so there are gaps on the audio:
SQL and putty (2/7/08)Accompanying Smartboard presentation
Working on SQL assignment (2/8/08)Accompanying Smartboard presentation
Loops (2/12/08)Accompanying Smartboard presentation
Relating links and functions (2/14/08)Accompanying Smartboard presentation
Functions (2/15/08)Accompanying Smartboard presentation
MySQL and relational DB (2/21/08)Accompanying Smartboard presentation
No class on 2/22/2008.
Relational DB and functions (2/26/08)Accompanying Smartboard presentation
Binhex program (2/28/08)Accompanying Smartboard presentation
No class on 2/29/2008.
Arrays (3/4/08)Accompanying Smartboard presentation
Arrays assignment (3/6/08)Accompanying Smartboard presentation
More Arrays (3/7/08)Accompanying Smartboard presentation
Connect DB (3/11/08)Accompanying Smartboard presentation
Open lab 3/13/2008.
Connect DB cont (inc problems) (3/14/08)Accompanying Smartboard presentation
More connect DB (inc problems) (3/25/08)Accompanying Smartboard presentation
I was out sick on 3/27/2008.
Last Connect examples (3/28/08)Accompanying Smartboard presentation
Maintain DB (4/1/08)Accompanying Smartboard presentation
Maintain DB cont (4/3/08)Accompanying Smartboard presentation
Open class on 4/4/2008.
Image arrays & DB (4/8/08)Accompanying Smartboard presentation
Images & DB (4/10/08)Accompanying Smartboard presentation
Kuss School and Service Learning (4/11/2008). Intro email (4/15/08)Accompanying Smartboard presentation
Email & DB (4/17/08)Accompanying Smartboard presentation
More email (4/18/08)Accompanying Smartboard presentation
Form check & cookies (4/22/08)Accompanying Smartboard presentation
No Thursday class on 4/24/2008.
Debugging (4/25/08)Accompanying Smartboard presentation
Sessions (4/29/08)Accompanying Smartboard presentation
All day open lab on 5/1/2008.
Worked on menu on CIT32, audio was too lab oriented to be helpful - see smartboard for 5/2/2008.
Debug and password (5/6/08)Accompanying Smartboard presentation
Audio/Lectures - Spring 2007 Intro to HTML (1/23/07)Accompanying Smartboard presentation
Intro to HTML cont. (1/25/07)Accompanying Smartboard presentation
CSS and WinSCP3 (1/26/07)Accompanying Smartboard presentation
PHP and WinSCP3 (1/30/07)Accompanying Smartboard presentation
PHP and WinSCP3 cont (2/1/07)Accompanying Smartboard presentation
Putty and MySQL (2/6/07)Accompanying Smartboard presentation
Putty and MySQL cont(2/8/07)Accompanying Smartboard presentation
Putty and MySQL cont(2/9/07)Accompanying Smartboard presentation
Relational databases (2/13/07)Accompanying Smartboard presentation
Multiple tables in MySQL (2/15/07)Accompanying Smartboard presentation
PHP, forms, passing (2/16/07)Accompanying Smartboard presentation
PHPdecisions (2/22/07)Accompanying Smartboard presentation
PHP Boston Tea (2/23/07)Accompanying Smartboard presentation
Loops (2/27/07)Accompanying Smartboard presentation
Loops, decisions, functions (3/1/07)Accompanying Smartboard presentation
Binary/hex code (3/2/07)Accompanying Smartboard presentation
Arrays (3/6/07)Accompanying Smartboard presentation
Connecting (3/9/07)Accompanying Smartboard presentation
SQL groups and PHP Guessing Game (3/20/07)Accompanying Smartboard presentation
PHP Guessing Game cont. (3/22/07)Accompanying Smartboard presentation
Game menu & email (3/27/07)Accompanying Smartboard presentation
Email cont.(3/29/07)Accompanying Smartboard presentation
Connection to MySQL (3/30/07)Accompanying Smartboard presentation
Connection to MySQL (4/3/07)Accompanying Smartboard presentation
Connection to MySQL and email (4/6/07)Accompanying Smartboard presentation
Images (only last part of class) (4/10/07)Accompanying Smartboard presentation
Images & normalization (4/12/07)Accompanying Smartboard presentation
Relational databases (4/17/07)Accompanying Smartboard presentation
Quiz (4/19/07)Accompanying Smartboard presentation
Update (4/20/07)Accompanying Smartboard presentation
Sessions (4/24/07)Accompanying Smartboard presentation
Audio/lectures Spring 2006 Best use is with the accompanying Smartboard presentation.
SQL Intro (2/2/06) Use with PowerPoint Introduction to SQL under SQL
Continuing SQL Intro (2/3/06) Accompanying Smartboard presentation
SQL Functions (2/7/06) Accompanying Smartboard presentation
SQL relating multiple files (2/9/06) Accompanying Smartboard presentation
Designing relational database (2/10/06) Accompanying Smartboard but mainly accompanies PowerPoint presentations under relational/normalize)
Introduction to PHP (2/14/06) Accompanying Smartboard presentation
Introduction to PHP contined (2/16/06) Accompanying Smartboard presentation
Boston Tea Party in PHP (2/21/06) Accompanying Smartboard presentation
Quiz and if statements (2/23/06) Accompanying Smartboard presentation
For and while loops (2/28/06) Accompanying Smartboard presentation
Analysis of binhex.php (3/3/06) Accompanying Smarthboard presentation
Arrays (3/9/06) Accompanying Smartboard presentation
Connecting to a database (3/23/06) Accompanying Smartboard presentation
Database and maintenance (3/30/06) Accompanying Smartboard presentation
Setting up class web site (4/4/06) Accompanying Smartboard presentation
Program calling itself - guess game discussion (4/13/06) Accompanying Smartboard presentation
Program on math facts (4/20/06) Accompanying Smartboard presentation
Notes from Jim Armstrong on using commerce, security etc (4/27/06) Accompanying Smartboard presentation
Notes from Jim Armstrong on using commerce, security etc continued (4/28/06) Accompanying Smartboard presentation

Send e-mail to Mrs. Grocer: pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page