Product Overview

Build Your Own Database Driven Web Site Using PHP & MySQL, 4^th Edition

Corrections & Typos

Find a mistake not listed here? Contact us to let us know!

July 2009

• p. 161 code listings

  In the first code listing, lines 14 and 15 should be:

  $jokes[] = array('id' => $row['id'], 'text' => $row['joketext'],
      'name' => $row['name'], 'email' => $row['email']);

  The second code listing is an excerpt from the file chapter5/jokes/jokes.html.php, and not index.php as printed.

• p.12 Installing PHP

  Although this book provides download and installation instructions for PHP 5.2, the newly-released (at the time of this writing) PHP 5.3 includes some new download options that aren’t covered in the book.

  There are four different versions of PHP 5.3. for Windows: VC6 Non Thread Safe, VC6 Thread Safe, VC9 Non Thread Safe, and VC9 Thread Safe. Talk about confusing!

  First of all, you definitely want a Thread Safe version of PHP. The Non Thread Safe versions are not suitable for use as a plugin for Apache.

  Secondly, assuming you will install (or have already installed) a version of the Apache HTTP Server from httpd.apache.org (see page 13), you will need the VC6 version of PHP.

  In short, to follow the instructions in this book, you need the VC6 Thread Safe version of PHP 5.3 for Windows.

• p.138 2nd paragraph

  The first sentence should read "... by letting you insert special headers into the response sent to the browser."

• p.15 Step 2 As of PHP 5.3, the file you want to duplicate is called php.ini-development, not php.ini-dist.
• p.17 code block 3

  In PHP 5.3, the extension_dir line of php.ini-development is commented out by default, so you need to remove the semicolon from the beginning of the line when adding the directory information.

• p.206 code listing Halfway down the page, the variable $jokeId is created with $jokeId = $row[0];. On the next line (after the comment), this variable is incorrectly referenced in the SQL DELETE statement as $jokeid (lowercase 'i'). It should be $jokeId in both places.
• p.42 2nd code block

  As of PHP 5.3, the file you want to duplicate is called php.ini-development, not php.ini-dist. So the last line of code should be:

  cp php.ini-development php.ini

• p.49 code block

  As of PHP 5.3, the date function requires that a timezone be specified. Running the code as is will result in a warning to this effect. To fix this, edit the php.ini file and include a line like:

  date.timezone = America/New_York

  (a list of supported timezones can be found at http://php.net/manual/en/timezones.php)

• p.62 last paragraph DATA should be DATE
• p.92 paragraph 4

  On pages 95 and 96, the book refers to welcome6.html and welcome6.php, which we've never explicitly said to create. You can still find these files in the code archive to follow along with the book. welcome6.php differs from welcome5.php in that we're using the general-purpose $_REQUEST variable rather than $_POST.