N342 Server-Side Web Development Distributed Lectures

Files that are marked in red are associated with others files. These files may not run properly by themselves.

Lecture	Video Segment	Link To Source Code	Length
Orientation
--	General Orientation	Orientation.ppt	34:56
Introduction
1a	Intro to Server-Side Programming		15:10
1b	Programming on the Web Server		32:13
1c	Activating your CS Account		38:47
1d	Installing Apache on Windows	install.html www.tightvnc.com	19:37
1e	Installing PHP in Windows		22:25
1f	Configuring PHP		10:46
1g	Installing an IDE	install.html www.php.net	25:31
Introducing PHP
(Unit zip files)
2a	Creating your 1st PHP Program	helloWorld.php helloWorld.php.src.html	25:41
2b	Preparing your Code	tip.php tip.php.src.html tips.txt	14:59
Using Variables and Input
(Unit zip files)
3a	Using Varialbes	story.html story.php.src.html story.php (called by story.html) hiJacob.php hiJacob.php.src.html hiJacobBad.php (illustrates syntax error) hiJacobBad.php.src.html	16:55
3b	Creating Complex String Variables	rowBoat.php rowBoat.php.src.html	06:34
3c	Responding to HTML Forms	hiUser.php (called by what'sName.html) hiUser.php.src.html linkDemo.html whatsName.html	17:34
3d	Responding to Complex Forms	borderMaker.html borderMaker.php (called by borderMaker.html) borderMaker.php.src.html	15:41
3e	Building an Ad-Lib	story.html story.php (called by story.html) story.php.src.html	03:23
Conditions and Functions
(Unit zip files)
4a	Creating Random Numbers	petals.php petals.php.src.html rollEm.php rollEm.php.src.html Bill Gates' Story	11:19
4b	Branching with the If Statement	ace.php ace.php.src.html aceOrNot.php aceOrNot.php.src.html	11:26
4c	Else If and Switch	binaryDice.php binaryDice.php.src.html switchDice.php switchDice.php.src.html	09:04
Conditions and Functions Continued
(Unit zip files)
5a	Functions	thisOldMan.php thisOldMan.php.src.html	07:08
5b	Function Parameters	param.php param.php.src.html	08:52
5c	Variable Scope	scope.php (error message is intentional) scope.php.src.html	10:30
5d	Persistence	persistence.php (deliberate notice in first iteration, disappears in subsequent runs) persistence.php.src.html	18:48
5e	Building "Petals Around the Rose"	petals.php petals.php.src.html petalHelp.html	16:02
Loops and Arrays
(Unit zip files)
6a	Introducing Poker Dice	pokerDice.php pokerDice.php.src.html	06:56
6b	For Loops	simpleFor.php simpleFor.php.src.html countingBackwards.php countingBackwards.php.src.html countByFive.php countByFive.php.src.html	10:50
6c	While Loops	while.php while.php.src.html badWhile.php (causes a deliberate endless loop) badWhile.php.src.html	12:10
6d	Basic Arrays	basicArray.php basicArray.php.src.html FancyOldMan.php FancyOldMan.php.src.html	16:42
6e	Responding to Checkboxes	checkDemo.html checkDemo.php.src.html checkDemo.php (called from checkDemo.html warnings are intentional )	07:58
6f	Programming Poker Dice	pokerDice.php pokerDice.php.src.html	27:14
6g	Programming Poker Dice Cont.	pokerDice.php pokerDice.php.src.html	18:05
More Arrays and String Manipulation
(Unit zip files)
7a	Introducing Word Puzzle	wordFind.php (called from wordFind.html) wordFind.php.src.html wordFind.html	03:50
7b	For Each Loops	foreach.php foreach.php.src.html	03:21
7c	Associative Arrays	assoc.php assoc.php.src.html	09:58
7d	Form Reader	formReader.php (called from any form! particularly sampleForm.html) formReader.php.src.html sampleForm.html	12:18
7e	Basic Multidimensional Arrays	basicMultiArray.php (called from basicMultiArray.html) basicMultiArray.php.src.html basicMultiArray.html	14:23
7f	Multi-Array	multiArray.php (called from multiArray.html) multiArray.php.src.html multiArray.html	07:35
7g	String Manipulation	pigify.php pigify.php.src.html	20:15
7h	Programming "Word Puzzle"	wordFind.php (called from wordFind.html) wordFind.php.src.html wordFind.html wordFindKey.php (called from wordFind.php) wordFindKey.php.src.html wordFind.xls	22:38
7i	Programming "Word Puzzle" cont.		28:07
Working with Files
(Unit zip files)
8a	Introducing the "Quiz Machine"	QuizMachine.php QuizMachine.php.src.html	09:10
8b	Saving and Loading Files	saveSonnet.php (no visible response) saveSonnet.php.src.html loadSonnet.php loadSonnet.php.src.html	12:45
8c	Reading a File in an Array	cartoonify.php cartoonify.php.src.html	08:50
8d	Mail Merge	mailMerge.php mailMerge.php.src.html maillist.dat	14:41
8e	Working with Files and Directories	imageIndex.php imageIndex.php.src.html	15:39
8f	Using Regular Expressions	regex.html	14:21
8g	Building the "Quiz System"	gradeQuiz.php (called by quiz machine) gradeQuiz.php.src.html showLog.php (called by quiz machine) showLog.php.src.html takeQuiz.php (called by quiz machine) takeQuiz.php.src.html writeQuiz.php (called by quiz machine) writeQuiz.php.src.html QuizMachine.php QuizMachine.php.src.html editQuiz.php (called by quiz machine) editQuiz.php.src.html quizFlow.png	19:21
Databases
(Unit zip files)
9a	Three Tier Development Model		13:54
9b	Introducing MySQL	MySQL 4.0 MySQL 5.0 PHP MyAdmin	19:01
9c	Building A Basic Table		15:37
9d	Queries	buildHero.sql	22:22
Connecting
(Unit zip files)
10a	Connecting to a Database within PHP	showHeroes.php showHeroes.php.src.html	18:46
Data Normalization
(Unit zip files)
11a	Examining Bad Data	buildSpyMySQL.sql badSpyData.html	09:45
11b	Examining Entities and Relationships	spyER.png buildSpy.sql DIA	15:27
11c	Basic Innerjoins	dataNorm.html buildSpy.sql agentsAndOps.sql	26:10
11d	Many to Many Joins	agent_specialty_join.sql spyER_II.png	15:30
Building a Three Tiered Data Application
(Unit zip files)
12a	Overview of Spy Database App	smallState.png fullState.png buildSpy.sql spyLib.php (called by spyMaster.php) spyLib.php.src.html viewQuery.php (called by spyMaster.php) viewQuery.php.src.html buildSpy.sql editTable.php (called by spyMaster.php) editTable.php.src.html deleteRecord.php (called by spyMaster.php) deleteRecord.php.src.html editRecord.php (called by spyMaster.php) editRecord.php.src.html addRecord.php (called by spyMaster.php) addRecord.php.src.html updateRecord.php (called by spyMaster.php) updateRecord.php.src.html processAdd.php (called by spyMaster.php) processAdd.php.src.html spyMaster.php spyMaster.php.src.html dbLib.zip	15:55
12b	Introducing Spy Library		24:26
12c	Building a Database		19:12
12d	SpyLib Initialization and Connect to Spy		10:17
12e	Creating the Edit Table		11:05
12f	Deleting Records		12:57
12g	Adding a Record		20:07
12h	Processing the Add		07:37
12i	FieldToList		17:55
12j	Wrapping Up the Spy Library		14:42

Computer Science N342
2005 Revision

Instructor: Andy Harris
Streaming Media Engineer: Kurtis Rush

�2005, Trustees of Indiana University/IUPUI Streaming Media Laboratory
Indiana University / Purdue University, Indianapolis
Homepage: http://wally.cs.iupui.edu

N342 Server-Side Web Development Distributed Lectures

Files that are marked in red are associated with others files. These files may not run properly by themselves.

Orientation

Introduction

Introducing PHP

Using Variables and Input

story.php(called by story.html)

hiJacobBad.php(illustrates syntax error)

hiUser.php(called by what'sName.html)

borderMaker.php(called by borderMaker.html)

story.php(called by story.html)

Conditions and Functions

Conditions and Functions Continued

scope.php(error message is intentional)

persistence.php (deliberate notice in first iteration, disappears in subsequent runs)

Loops and Arrays

badWhile.php (causes a deliberate endless loop)

checkDemo.php(called from checkDemo.html warnings are intentional )

More Arrays and String Manipulation

wordFind.php (called from wordFind.html)

formReader.php (called from any form!particularly sampleForm.html)

basicMultiArray.php (called from basicMultiArray.html)

multiArray.php (called from multiArray.html)

wordFind.php (called from wordFind.html)

wordFindKey.php (called from wordFind.php)

Working with Files

saveSonnet.php (no visible response)

gradeQuiz.php (called by quiz machine)

showLog.php (called by quiz machine)

takeQuiz.php (called by quiz machine)

writeQuiz.php (called by quiz machine)

editQuiz.php (called by quiz machine)

Databases

Connecting

Data Normalization

Building a Three Tiered Data Application

spyLib.php (called by spyMaster.php)

viewQuery.php (called by spyMaster.php)

editTable.php (called by spyMaster.php)

deleteRecord.php (called by spyMaster.php)

editRecord.php (called by spyMaster.php)

addRecord.php (called by spyMaster.php)

updateRecord.php (called by spyMaster.php)

processAdd.php (called by spyMaster.php)

Computer Science N342 2005 Revision Instructor: Andy Harris Streaming Media Engineer: Kurtis Rush �2005, Trustees of Indiana University/IUPUI Streaming Media Laboratory Indiana University / Purdue University, Indianapolis Homepage: http://wally.cs.iupui.edu

story.php
(called by story.html)

hiJacobBad.php
(illustrates syntax error)

hiUser.php
(called by what'sName.html)

borderMaker.php
(called by borderMaker.html)

story.php
(called by story.html)

scope.php
(error message is intentional)

persistence.php
(deliberate notice in first iteration,
disappears in subsequent runs)

badWhile.php
(causes a deliberate endless loop)

checkDemo.php
(called from checkDemo.html
warnings are intentional )

wordFind.php
(called from wordFind.html)

formReader.php
(called from any form!
particularly sampleForm.html)

basicMultiArray.php
(called from basicMultiArray.html)

multiArray.php
(called from multiArray.html)

wordFind.php
(called from wordFind.html)

wordFindKey.php
(called from wordFind.php)

saveSonnet.php
(no visible response)

gradeQuiz.php

(called by quiz machine)

showLog.php

(called by quiz machine)

takeQuiz.php

(called by quiz machine)

writeQuiz.php
(called by quiz machine)

editQuiz.php
(called by quiz machine)

spyLib.php

(called by spyMaster.php)

viewQuery.php

(called by spyMaster.php)

editTable.php

(called by spyMaster.php)

deleteRecord.php

(called by spyMaster.php)

editRecord.php

(called by spyMaster.php)

addRecord.php

(called by spyMaster.php)

updateRecord.php

(called by spyMaster.php)

processAdd.php

(called by spyMaster.php)

Computer Science N342
2005 Revision

Instructor: Andy Harris
Streaming Media Engineer: Kurtis Rush

�2005, Trustees of Indiana University/IUPUI Streaming Media Laboratory
Indiana University / Purdue University, Indianapolis
Homepage: http://wally.cs.iupui.edu