Errata

Code comment incorrectly refers to "user_name" when it should refer to "comment"

The line ending "...where it was referenced as user_admin.css" is incorrect.
The name of the style sheet used in the previous example was example.css

Change the line on page 10 to read:
Although we included the CSS in the file in this example, it could come from a separate file as it did in Example 1-1, where it was referenced as example.css.

It reads:
(Instead of <b>bold<i>italic</i></b>, you should close the code like this: </b></i>.)

This is contradicted by the last sentence:
So, if you open a bold and then italic, you should close the italic before you close the bold.

So the correct manner would be: <b>bold<i>italic</i></b>

Page 11 should read:
It?s also good practice (and it?s required by XHTML) that your tags nest cleanly to produce elements with clear boundaries. Always use end tags when you reach the end of an element, and avoid having pairs of tags that overlap. (Instead of <b>bold<i>italic</b></i>, you should close the code like this: </i></b>.) In other words, you should open and close items at the same level. So if you open a bold and then italic, you should close the italic before you close the bold.

Figure 2-14 shows the ?Chose Items to Install? dialog. If you changed the base install directory, you may also need to change it here. If you?re installing PHP 5.2.6 or later, expand the extensions section and mark MySQL for installation. You may also install the MySQLi extension, which supports the latest MySQL features. Click Next.

Note: If you selected to install MySQLi then use extension=php_mysqli.dll instead of extension=php_mysql.php.

Modify a sentence of Step 8 on page 33 from:
You should now see a section with the heading MySQL in the middle of the page.
To:
You should now see a section with the heading of MySQL or MySQLi in the middle of the page.

The second bullet on page 72 should read:

? : (shorthand for an if statement)

{expression} ? return_when_expression_true : return_when_expression_false;
with:
(expression) ? return_when_expression_true : return_when_expression_false;

..."Of course, there may be times when you don?t want to just skip"..

should read as:

..."Of course, there may be times when you want to just skip"..

currently reads:

$str{0} = strtoupper($str{0}); //$str{0] accesses the first character in the string

Should read:
$str{0} = strtoupper($str{0}); //$str{0} accesses the first character in the string

No closing ?> on the example

Also, the output does NOT match the description. It prints "the cat was hypnotized" twice, so it seems that $hypnotic_cat->hypnotize() DOES something, not as described in the comments and intro to the example. PHP 5.2.5
After this line on page 104:
$hypnotic_cat->hypnotize();
Please add the next line:
?>
It should read:
$hypnotic_cat->hypnotize();
?>

Replace the # character with // and remove the blank line after it like this:
foreach ($shapes as $key => $value) { // every associative array has $key and $value pairs
The entire block is:
<?php
$shapes = array('Soda can' => 'Cylinder',
'Notepad' => 'Rectangle',
'Apple' => 'Sphere',
'Orange' => 'Sphere',
'Phonebook' => 'Rectangle');
foreach ($shapes as $key => $value) { // every associative array has $key and $value pairs
print "The $key is a $value.<br />";
}
?>

"The assort() function works like sort"....

should read

"The asort() function works like sort"....

GRANT ALL PRIVILEGES ON store.* TO 'michele'@'localhost' IDENTIFIED BY 'secret';

Would produce an error because database store doesn't exist (until the next page).

Add a note after ?GRANT ALL PRIVELGES ON store.* TO ?michele?@?localhost? IDENTIFIED by ?secret?;

Note: Run this command after creating the store database in the next section Creating a MySQL Database or an error occurs since the database hasn?t been created yet.

The text on page 137:
To rename a column, use ALTER TABLE table new_column_name old_column_name definition new_column.

Should read (the CHANGE keyword is added and the order has been switched):

To rename a column, use ALTER TABLE table CHANGE old_column_name new_column_name definition_new_column.

DROP TABLE publications;
DROP TABLE authors;

After typing SELECT * FROM authors ORDER BY author; at the mysql command prompt the table shows an extra author. Alex Martelli should not be in the results.

Deleting Database Data, should read:

DELETE FROM books where title_id = 1;

Should have a semicolon on the end like:
SELECT * FROM authors WHERE author LIKE "Aaron Webe_";

The second sentence reads, "Notice that two % signs were used to surround the b, "&b&"."

It should read, "Notice that two % signs were used to surround the b, "%b%"." (Percentage characters
replacing the ampersands.)

Example should be:
Example 10-6: Checking input from a radio button or a single select
<?php
$options = array('option 1', 'option 2', 'option 3');

// Coming from a radio button or single select statement
if (in_array($_GET['input'], $options)) {
echo "Valid";
} else
{
echo "Not Valid";
}
?>

39 $search = htmlentities($GET["search"]);
40 $self = htmlentities($SERVER['PHP_SELF']);

should be:
39 $search = htmlentities($_GET["search"]);
40 $self = htmlentities($_SERVER['PHP_SELF']);

?php
to:
<?php

$base_path = basename(dirname(__FILE__));

should be:

$base_path = dirname(__FILE__);

should read:

12/13/05 16:18:01

since it is pm and "G" is hours in 24-hour format

Example 11-14 should read (to match the Figure):
<?php
$timestamp= time();
echo date("m/d/y g:i:sa",$timestamp);
?>

The file exist.php does exist.
With:
file_exist.php does exist.
(note there is an underscore between file and exists)
Please replace the line:
As you would expect, the file does exist:
With:
Since the file that is being checked for is the name of the PHP script that?s running it naturally exists:

unlink($HTTP_POST_FILES['upload_file']['tmp_name']);

<?php
exec(escapeshellcmd("df"),$output_lines,$return_value);
echo ("Command returned a value of $return_value.");
echo "</pre>";
foreach ($output_lines as $output) {
??? echo "$o";
}
echo "</pre>";
?>

Should be

<?php
exec(escapeshellcmd("df"),$output_lines,$return_value);
echo ("Command returned a value of $return_value.
");
echo "<pre>";
foreach ($output_lines as $output) {
??? echo "$output
";
}
echo "</pre>";
?>

insert_db($title, $pages){
should be:
function insert_db($title, $pages){

the function keyword is on the line before in the comments!

code should read:

// Define a function to perform the database insert and display the titles
function insert_db($title, $pages){

The Meaning column of Table 14-1 says that a "1" is used to indicate sending a cookie only over a secure HTTPS connection. The "Example value" column says that "0" is used for secure cookies. It can't be both.

The table should read:

Secure If set to TRUE, cookies are sent only over a secure HTTPS connection. HTTPS connections use encryption between the client and the browser to secure data. TRUE for secure and FALSE for insecure, which is the default.

unset ($_SESSION['username']);

Click to <a href="modify_posts.php?action=add">add</a> a posting.<br />

<form action="modify_posts.php" method="POST">