Here we are now entertain us

1

Introduction: Syllabus, What we are doing
Showcase: Work of Aaron Koblin, FutureMe.org, The World's Deepest Bin (thefuntheory.com)
Lecture: Introduction to PHP, php.net, PHP Cookbook (O'Reilly), HTML Forms, Passing data to PHP
In the News: Social Media’s True Impact on Haiti, China, and the World
Reading: PHP 6 and MySQL 5 for Dynamic Web Sites (chapter 1)

Nuts and bolts (and bits)

2

"The best thing about a boolean is even if you are wrong, you are only off by a bit"

Introduction: Lego experiment
Video: Alexis Ohanian: How to make a splash in social media
Lecture: Variables, Conditionals, Arrays, Loops, Functions
Notes: Download examples (e-mail form, arrays)
In the News: Google Expands Social Search Test
Reading: PHP 6 and Mysql 5 for Dynamic Web Sites (chapters 2 & 3)

Making it work

0

Lecture: Organizing your code, storing and retrieving data, implode/explode
Notes: Download Examples (functions, dates, random, text files)
In the News: First Internet, now bay window at space station
Studio: Work on 'Leave a Trace' assignment
Reading: PHP 6 and Mysql 5 for Dynamic Web Sites (chapter 4)

Open Lab

0

Studio: Work on 'Leaving a Trace' assignment

Select * from data

0

"All web applications only do four things... SELECT, INSERT, UPDATE and DELETE"

Lecture: Introduction to databases, Building a simple bookmarking application
Resources: Creating a database, Creating a table
Notes: Download example
Reading: PHP 6 and MySQL 5 for Dynamic Web Sites (chapter 4)

Building Rome in a day

0

Lecture: Application workflow, database normalization, Expanding our bookmarking application
Notes: Download example
In the News: People, Groups Flock to the Web After Chile Earthquake
Reading: PHP 6 and MySQL 5 for Dynamic Web Sites (chapter 5)

Normalization

0

Showcase: Gary Flake: is Pivot a turning point for web exploration?
In the news: Twitter Adds Location-Sharing
Lecture: Database normalization, joins and search
Notes: Integrating tags into our bookmark application (view source)
Studio: Open lab

{$templates}

0

Introduction: Student Presentations
Lecture: Smarty template engine, smarty.net, TinyMCE WYSIWYG editor
In the News: Facebook Pulls in More Web Traffic Than Google
Studio: Build simple blog (config.php, index.php, index.tpl, addpost.tpl)

Who are you? And what are you doing here?

0

Lecture: Sessions, registration, login
In the News: More Than 1,000 Communities Apply for Google Fiber Test
Studio: Building a wall (config.php, index.php, admin.php, index.tpl, register.tpl, signin.tpl, profile.tpl, admin.tpl)

Upload, resize and display

0

Lecture: File uploads, File errors, PEAR, Installing PEAR on shared servers, Image Transform, Plupload
Studio: Uploading, resizing and displaying profile images
Notes: Wall2, Simple Image Upload (view example), Simple File Upload (view example)

Calling out

1

Lecture: The Top 15 Web APIs For Your Site, CURL, SimpleXML (tutorial), JSON, textmarks, Yahoo PIPES, Searching and Filtering with XPath
In the News: 16-year-old sues mother for hacking Facebook account, Apple Vs Adobe: Steve Jobs Responds
Notes: News Feed, Search Twitter, Search YouTube, Search Delicious, Search Google News
Studio: Work on Final Project

Serving the client

0

Lecture: jQuery, ajax, json
Notes: Building a simple ajax contact form
Studio: Work on final project

Open Lab

0

Work on final projects