David J. Malan, Instructor
dmalan@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, how to use Ajax with both XML and JSON, and how to build mashups. The course explores issues of security, scalability, and cross-browser support and also discusses enterprise-level deployments of websites, including third-party hosting, virtualization, colocation in data centers, firewalling, and load-balancing.

Loading...

These lectures were filmed in 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: HTTP ▶ play ▾ expand all
Lecture 1: PHP ▶ play ▾ expand all
Lecture 2: PHP, Continued ▶ play ▾ expand all
Lecture 3: XML ▶ play ▾ expand all
Lecture 4: XML, Continued ▶ play ▾ expand all
Lecture 5: SQL ▶ play ▾ expand all
Lecture 6: SQL, Continued ▶ play ▾ expand all
Lecture 7: JavaScript ▶ play ▾ expand all
Lecture 8: JavaScript, Continued ▶ play ▾ expand all
Lecture 9: Ajax ▶ play ▾ expand all
Lecture 10: Ajax, Continued ▶ play ▾ expand all
Lecture 11: Security ▶ play ▾ expand all
Lecture 12: Scalability ▶ play ▾ expand all

Sections (otherwise known as "recitations" or "precepts" at other universities) supplement lectures. Led by Siddarth Chandrasekaran '11, these sections were filmed in Harvard Hall.

Section 1: HTTP, PHP ▶ play ▾ expand all
Section 2: PHP, Continued ▶ play ▾ expand all
Section 3: XML ▶ play ▾ expand all
Section 4: XML, Continued ▶ play ▾ expand all
Section 5: SQL ▶ play ▾ expand all
Section 6: SQL, Continued ▶ play ▾ expand all
Section 7: JavaScript ▶ play ▾ expand all
Section 8: JavaScript, Continued ▶ play ▾ expand all
Section 9: Ajax ▶ play ▾ expand all
Section 10: Ajax, Continued ▶ 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