David J. Malan, Instructor
malan@post.harvard.edu
http://www.cs.harvard.edu/malan/

Harvard Extension School

Today's websites are increasingly dynamic. Pages are no longer static HTML files but instead generated by scripts and database calls. User interfaces are more seamless, with technologies like Ajax replacing traditional page reloads. This course teaches students how to build dynamic websites with Ajax and with Linux, Apache, MySQL, and PHP (LAMP), one of today's most popular frameworks. Students learn how to set up domain names with DNS, how to structure pages with XHTML and CSS, how to program in JavaScript and PHP, how to configure Apache and MySQL, how to design and query databases with SQL, and how to use Ajax with both XML and JSON. The course discusses issues of security, scalability, and cross-browser support.

Loading...

These lectures were filmed in the Science Center and Harvard Hall.

If you have questions or would like to discuss the material with others, you may want to join the Google Group at right.

Lecture 0: DNS, HTTP, XHTML, and CSS ▶ play ▾ expand all
Lecture 1: PHP ▶ play ▾ expand all
Lecture 2: PHP, Continued ▶ play ▾ expand all
Lecture 3: SQL ▶ play ▾ expand all
Lecture 4: SQL, Continued ▶ play ▾ expand all
Lecture 5: JavaScript ▶ play ▾ expand all
Lecture 6: Ajax ▶ play ▾ expand all
Lecture 7: Mashups ▶ play ▾ expand all
Lecture 8: Security ▶ play ▾ expand all
Lecture 9: Scalability ▶ play ▾ expand all
Lecture 10: CSS ▶ play ▾ expand all
Lecture 11: Frameworks ▶ play ▾ expand all

Sections (otherwise known as "recitations" or "precepts" at other universities) supplement lectures. Led by Dan Armendariz and Keito Uchiyama '11, these sections were filmed at 1 Story Street.

Section 0: DNS, HTTP, XHTML, and CSS ▶ play ▾ expand all
Section 1: PHP ▶ play ▾ expand all
Section 2: PHP, Continued ▶ play ▾ expand all
Section 2, Part 2: PHP, Continued ▶ play ▾ expand all
Section 3: SQL ▶ play ▾ expand all
Section 4: SQL, Continued ▶ play ▾ expand all
Section 5: JavaScript ▶ play ▾ expand all
Section 6: Ajax ▶ play ▾ expand all
Section 7: Mashups ▶ play ▾ expand all
Section 8: Security ▶ play ▾ expand all
Section 9: CSS ▶ play ▾ expand all
Section 10: Frameworks ▶ play ▾ expand all

Below are projects (i.e., homework assignments). To simulate cs75.net on your own computer, we recommend that you download and install XAMPP, which will put Apache, MySQL, PHP, and phpMyAdmin on your own computer, where you can then implement Projects 1 through 3.

If you have questions or would like to discuss the material with others, you may want to join the Google Group at right.

Project 0: Setup
Project 1: PizzaML
Project 2: C$75 Finance
Project 3: Mashup