DAY/TIME/PLACE

Monday Evenings, 6:30-9:30pm, Starting February 27th

Instructor: Bruce Donald Campbell

Faculty, Continuing Education - RISD, Providence, RI
Director, Watersheds Project, Providence, RI

Email: bcampbel01@risd.edu

Prerequisites: HTML and/or Dreamweaver course

DESCRIPTION

This course provides students with an orientation and introduction to dynamic content generation using PHP. Dynamic content creation entails storing dynamic data in a back-end database and querying that data for presentation in XHTML. We use MySQL as a popular open-source relational database management system.

GRADING

Class participation - 20%
Homework exercises - 20%
Two class projects - 60%

RESOURCES

Book:

The recommended book for this class is the third edition of the book PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide, by Larry Ullman (December 2007).

Course Handouts and On-line Readings as identified below and in class

---

CLASS LINKS

• Course Book Companion Site.
• WAMP Server home page.
• MAMP home page.
• Building a LAMP tutorial

SYLLABUS

• Course Introduction & Policies
• Instructor and Student Introductions
• Opening Survey of Student Skills
• How PHP fits into the Big Picture of the Web
• Comparative Web Page Examples (PHP, HTML, XHTML, Flash)
• Syntax Review / Introduction
• Managing HTML and PHP a text files
• HTML Document Structure Review
  

Homework

Be sure to read the Welcome to Class page and integrate all we went over together in our first class into your approach for this class.

Look at our class book companion site at: http://www.dmcinsights.com/phpmysql3/.

Look at the four prior student projects that added functionality to websites with PHP:

• A server-side gallery on artstar.org
• A server-side slide gallery on www.cev.washington.edu
• An Ocean Picture of the Day service on theoceanproject.org
• A Trawl Data management service on savethebay.org

Then consider how we might use PHP to improve a data-intensive site this class:

• The Community Learning Partnership Community Organizing Digital Library

Goals:

• Master the syntax of simple PHP statements
• Learn about data types
• Learn about variables
• Try some mathematical statements

In-Class:

• In class examples are here.
• The Include and Require Statements
• PHP Simple Data Types
• Numbers (int and float)
• Text (char and string)
• Boolean
• Variables
• What is a variable?
• Variable Naming Conventions
• Assignment statements and Weak Typing (versus Strong Typing)
• Syntax for Mathematics and Precedence
• Mathematical Operators
• Mathematical Assignment and Output Statements
• Some Exercises that Demonstrate Skills Learned

Homework

• Read Chapter 1 of our book
• Get WAMP, MAMP, XAMP, or LAMP working on your development system

Goals:

• Consider how all websites can take advantage of the usability and rich features base of PHP and MySQL (or any back-end database)

In-class:

Lecture this week is via video:
1. PHP use in Stylesheets
2. PHP with XML (Scalable Vector Graphics)
3. PHP with X3D Integration
4. PHP use with External Web Services
5. Amazon ISBN External API
6. PHP with JavaScript
7. PHP with Regular Expressions

Homework

• Investigate the examples provided in the class videos

In-class examples are online here.

Goals:

• Discuss the Artist Gallery Page in preparation for Project 1
• Learn about comparison and logical operators
• Learn about the If/Else construction
• Master the syntax of block statements

In-class:

• Comparison Operators / Boolean Statements
• Logical Operators
• If / Else Blocks
• Basic For and While Blocks
• Some Exercises that Demonstrate Skills Learned
  

Homework

• Study the artist gallery PHP code diagramming example.
• Read Chapter 2 of our book

The on-line lecture associated with this class is on-line here.

In class:

• Learn about for, do-while and while loops
• Master the postfix increment and decrement operators
• Discover the difference between single and double quotes
• Introduction to the String library
• Review of the goals of all projects and skills required to fulfill them
• Review of the class development process and opportunity to substitute projects
  

Homework

• Diagram the OPOD Moderator Code at the bottom of this week's lecture and turn in via e-mail.
• Consider the syllabus for the remainder of our class and be ready to discuss issues you have with the approach we're taking and the project work assigned.
• Read Chapter 3 of our book

The on-line lecture associated with this class session is on-line here.

Goals:

• Learn about arrays in PHP
• Learn what a function is and what it does
• See how functions can be used in other statements

In-class:

• Introduction to Lists
• One-dimensional Arrays
• Dynamic Arrays (using the array() function)
• Static Arrays with Numeric Indices and the Array Access Operator
• Associative Arrays and the Arrow Operator
• Variables in Array Accesses
• Writing and Reading Files (download writefile.php and data.txt)
• Introduction to Pre-Defined Functions
• The count() function
• Introduction to Project 2
• Some Exercises that Demonstrate Skills Learned
  

Homework

• Explore the online PHP documentation
• Read Chapter 11 of our book
• Revisit the PHP with SVG video.
• Consider O'Reilly's take on Arrays
• Review the diagramming of the OPOD Moderator Page
  

The on-line lecture associated with this class session is on-line here.

Goals:

• Review HTML form creation
• Learn how to respond to a form in PHP (safely)
• Learn about predefined global variables in PHP
• Learn a little bit about type-casting

In-class:

• Introduction to Forms
• Review of HTML forms
• Creating Forms and Form Elements
• Actions and Submission Methods
• PHP's Pre-Defined Form Variables
• The import_request_variables() function
• Checking Input Values
• The isset() function
• Type-casting
• Using the null Comparison
• Overview of Cookies
• Setting and Retrieving Cookies in PHP
• Overview of Session Management
• Setting and Retrieving Session Variables
• Some Exercises that Demonstrate Skills Learned
  

Homework

• Attempt some simple form-processing pages
• Work on Project 1

The on-line lecture associated with this class session is on-line here.

Goals:

• Understand how an object-oriented scripting language works.
• Review examples of using classes to create objects with PHP.
• Investigation of the phpmyadmin interface in terms of classes and objects.

In-class:

• Discussion of class goals and preparation for two week hiatus.
• Some Exercises that Demonstrate Skills Learned
  

Homework

• Work on Project 1 which is due soon after we return from break.
  
• Take a look at Project 1 Submissions from last year's class
• Project 1 Due April 30th at 11:59pm

The on-line lecture associated with this class session is on-line here.

Goals:

• Learn what a database is, and why it works so well with PHP
• Learn how to create a database and some simple database tables in sqlYog

In-class:

• Database Overview
• Flat, Relational, Object, and Hybrid Databases
• Database Role in the Big Picture of the Web
• Database Tables as Columns and Rows
• Database Records and Field Data Types
• Structured Query Language and MySQL as one Implementation
• Structured Query Language (SQL) Syntax
• Preview of INSERT, UPDATE, and DELETE
• Some Exercises that Demonstrate Skills Learned

Homework

• Project 1 Due April 30th at 11:59pm
• Look at the Parts Tutorial.
• Begin to think about project 2.

The on-line lecture associated with this class session is on-line here.

Goals:

• Hear about the 4 most common SQL statements (SELECT, INSERT, UPDATE, and DELETE)
• We'll take a look at data for a social mediated Partner site available here.
• Study the SELECT statement in detail
• Connecting to a database in PHP

In-class:

• Let's all use SQL to build some tables again
• Take a look at MySQL Data Types
• Let's fill our tables with data
• Let's integrate our data needs with PHP
• Adding a Conditional WHERE Clause to Filter Data
• Integrating Databases with PHP Code
• The mysql_connect() function
• The mysql_query() function
• Result sets, mysql_fetchArray, and while loops
• Some Exercises that Demonstrate Skills Learned

Week 10's lecture notes are online.

Goal:

To feel comfortable with adding a back-end database into an existing website

In Class:

• Perform a Data Modeling example exercise.
• Review the code for the Ocean Picture Of the Day site.
• Solidify our understanding of using back-end databases in dynamic websites with more example queries using the OPOD data for a year.
• Take a look at Project 1 Submissions
• Look at Project 2 opportunities

Homework

• Parts database tutorial completion with considerations for OPOD site
• Work on Project 2
• Try using Amazon's ISBN Service (if you need reinforcement of skills)
  

• We'll take a look at data for a php-driven citizen science site: The data for the sites is available here.
• Advanced database queries
• Questions regarding our projects
• Design review for anyone who wants feedback from class peers
• Question and answers based on your e-mails and then questions in class

• We continued building our skill set at generating SQL queries for the in-class quiz responses and citizen science sites.

Turn in your project by 11:59pm on May 27th.

Goals:

• Consider how the additional features of PHP listed below could be used to your advantage in building attractive and useful websites

In-class:

• Getting Comfortable with Self-Guided Learning in PHP
• Review concepts from list below (with online support here)

The following is a brief listing of some of the topics from which students suggested topics for further investigation. One goal of this course is for you to feel comfortable diving in to any possible topic on your own - have you figured out your own personal process for that yet?

• Introduction to regular expressions
• Using regular expressions to extract data from text
• Filtering incoming values based on regular expressions
• Complex array handling
• Using nested arrays and nested associative arrays
• Array management functions (push, pop, split, merge, etc)
• Array sorting
• Complex variable usage
• Dynamic / run-time variable names
• Parsing variables from strings and arrays
• Type checking and manipulation (gettype function and type casts)
• Classes and objects in PHP
• Advanced database queries
• SQL JOINs and cross-referencing multiple tables in a single query
• Sub-queries
• Computed columns (and the GROUP BY clause)
• PHP outside HTML
• PHP in stylesheets
• Command-line / Stand-alone PHP applications
• Generating JavaScript with PHP
• PHP and dynamic HTML
• Creating re-usable DHTML chunks
• Browser detection and dynamic page adaptation on the server
• Implementing simple administrative areas
• Security considerations
• Managing users and permissions
• Logging changes
• Gathering website statistics (PHP's original use!)
• Page views
• Links and navigation paths
• Entry and exit pages
• Error handling in PHP
• User generated errors
• Custom error handling functions
• Stack trace functions
• Try-catch blocks
• Exceptions and exception classes
  
  

Homework

• Finish your Projects for your personal portfolio - due May 27th at 11:59pm