Errata

"The next chapter will show you how to use the Smarty templating engine..."

The Amazon Kindle edition of this book (which I purchased at URL http://www.amazon.com/dp/1449319262) seems to contain no Smarty material whatsoever, other than a URL at location 108503.

I can only conclude that a large chunk of the book is missing.

Note from the Author or Editor:
Smarty was covered in Edition 1 of the book but so few readers actually used it the decision was taken to focus on an area of more interest, and so that chapter was removed to make way for one of the later chapters on CSS. Unfortunately the reference to Smarty appears not to have also been removed, please ignore that sentence.

--printed--

copies the property values from the original class to the new instance.

--should be--

copies the property values from the original instance to the new instance.

In the first paragraph of page 266 the author writes down the formula for converting from Celsius to Fahrenheit.
According to him, the formula is "Fahrenheit = (9/5) * (Celsius +32).
I have tested back an forth, and I think the correct way of writing it would be like this:
"Fahrenheit = ((9/5) * Celsius) + 32"

In the final closing tag '?' is missing, i. e. should be "?>".

The 'l' format specifier implies that the day should be output as 'Thursday'
and not 'Thu' as shown.
Also hyphens are shown in the format specifier but not in the example output.
Which is the correct format for DATA_COOKIE format?

Sorry to be pedantic, but if your depiction of a chessboard is to follow the usual convention of white pieces starting at the bottom of the board, you need to swap round the King and Queen positions.
;-)

The title of example 10-7 should be

Closing a MySql server connection

although it does by implication also close the database.

Title of this example should read:-

Connecting to a MySQL server

rather than a database.

ereg_replace() has been deprecated

Example 9-8. Dumping the publications database to screen

--should be--

Example 9-8. Dumping the publications database to file

echo date('M jS \'y g:sa:', $row[4]);

Should be:
echo date('M jS \'y g:i:sa', $row[4]);

Note from the Author or Editor:
The date() function call as used displayed hh:ss (hours and seconds) instead of hh:mm (hours and minutes). To correct this it should read as follows:

echo date('M jS \'y g:ia', $row[4]);

The book says:
"...by setting the mode with '+r', which puts..."
It should say:
"...by setting the mode with 'r+', which puts..."

The terminating condition in the for loop is:

$i + $j < 10

but in the analysis of this loop it appears as:

$i + $j < 1

Note from the Author or Editor:
The three example lines at the foot of page 82 should be as follows (the middle line should be $j < 10, not $j < 1):

$i = 1, $j = 1 // Initialize $i and $j
$i + $j < 10 // Terminating condition
$i++ , $j++ // Modify $i and $j at the end of each iteration

...within a static class, ...

should be

...within a static function, ...

Rationale: I've never heard of static classes (it's pointless because it's like saying 'class classes').

The line "After this, the open method is called to set the object to make a POST request to geturl.php in asynchronous mode." Does not correspond with the code on page 381 where it is listed as:

request.open("POST", "urlpost.php", true)

The 'geturl.php' on page 382 needs to be replaced with 'urlpost.php'

Second sentence "Within these slashes, certain characters have special meanings; there are called metacharacters." should change "there" (after semicolon) to "they".

The out at the top of this page should be:

Element at index 0 has the value Cat
Element at index 1 has the value Dog
Element at index 2 has the value Rabbit
Element at index 3 has the value Hamster

Note from the Author or Editor:
Example 16-11 was modified late in the copy edit stage to clarify the difference between indexes and elements held in indexes. Therefore the output shown from the modified example should include the extra words "at index". This does not affect the working of the example or the explanation of its function.

The term

$_SERVER['HTTP_REFERRER']

should be replaced with $_SERVER['HTTP_REFERER']

(one less R)

<?php // formtest.php
echo <<<_END
<html>
<head>
<title>Form Test</title>
</head>
<body>
<form method="post" action="formtest.php" />
What is your name?
<input type="text" name="name" />
<input type="submit" />
</form>
</body>
</html>
_END;
?>

Same online. Form shouldn't be closed by />, right?

Note from the Author or Editor:
The <form method... /> statement in Example 11-1 should not have the self-closing /> tag, and should therefore read:

<form method="post" action="formtest.php">

However, since self-closing is not supported by the <form> tag, this typo should not affect the behavior of the HTML.

In table 17-2, example:

a-f Matches any of the characters a,b,c,d,e or f

the a-f should be in square brackets:

[a-f]

Note from the Author or Editor:
You would place such sequences within square brackets so I agree it would be better to show them in the table.

The fourth example in Table 17-2, rec(ei)|(ie)ve, should be: rec(ei|ie)ve.

Instead of GRANT ALL ON publications.* TO 'jim' IDENTIFIED BY 'mypasswd';

Following is the correct syntax, as recommended at http://dev.mysql.com/doc/refman/5.1/en/adding-users.html:

GRANT ALL ON publications.* TO 'jim'@'localhost' IDENTIFIED BY 'mypasswd';

This is a minor error.
Instead of the password input type being 'text' it should have been 'password' so that the password isn't visible when the user types it in.

So the code should be:
<?php //rnsignup.php
.
.
.
}
echo<<<_END
<form method='post' action='rnsignup.php'>$error
Username<input type='text' maxlength='16' name='user' value='$user'
onBlur='checkUser(this)'/><span id='info'></span><br/>
Password<input type='password' maxlength='16' name='pass'
value='$pass' /><br/>
??????
<input type='submit' value='Signup' />
</form>
_END;
?>

Great book though. 5/5. Thanks Robin.

Note from the Author or Editor:
Although not an error the reader makes a useful suggestion to change the type of the user input from text to password. I had left it as text so that the user could see what was happening, but on reflection this change to obscure the password as it is entered is better practice.

I just happened to notice a simple title in your text. You refer to mysql_real_escape_string as mysql_real_eascape_string. Notice the extra "a" in escape. Thanks for the great book!

In Example 6-11 on page 122 there are 10 rows instead of 8 in the array used to construct a chessboard. Two of the blank rows should be removed from the middle.

Shouldn't the caption read 'Two simple JavaScript statements'. The caption currently refers to PHP instead of JavaScript.

First slash is in the wrong direction on the figure.
It is correct in the rest of the explanation

Note from the Author or Editor:
On page 365 of the printed edition, the first character in Figure 17-3 is shown as a \, but it should be a /. The same goes for the first character of Figure 17-4 which should be a /.

Example 9-9 should include "use publications;" statements after both startings of the mySql command line environment, and semicolons at the end of each mySql command.

Note from the Author or Editor:
The section on page 221 that reads as follows is not quite correct, since the publications table is not selected before issuing the LOCK command, and it can also be much simplified:

Should you wish to back up only a single table from a database
(such as the classics table from the publications database), you
could use a sequence of commands such as those in Example 9-9, in
which you simply follow the database name with that of the table
to be backed up.

I've assumed here that you haven't shut down the MySQL server.
You're letting it run while you back up the classics table, but
you lock that single table during the backup so that no one can
access it.

Example 9-9. Dumping just the classics table from publications

$ mysql -u user -ppassword
mysql> LOCK TABLES classics READ
mysql> QUIT
$ mysqldump -u user -ppassword publications classics > classics.sql
$ mysql -u user -ppassword
mysql> UNLOCK TABLES
mysql> QUIT

The replacement text for these two paragraphs and Example 9-9 is as follows:

To back up only a single table from a database (such as the
classics table from the publications database), you should first
lock the table from within the MySQL command line, by issuing a
command such as the following:

LOCK TABLES publications.classics READ

This ensures that MySQL remains running for read purposes, but
writes cannot be made. Then, while keeping the MySQL command line
open, use another terminal window to issue the following command
from the operating system command line:

mysqldump -u user -ppassword publications classics > classics.sql

You must now release the table lock by entering the following
command from the MySQL command line, which unlocks all tables
that have been locked during the current session:

UNLOCK TABLES

The example given,

LOCK TABLES tablename1 tablename2 ... READ

produces an error for me. I found this format will work:

LOCK TABLES tablename1 READ, tablename2 READ, ... ;

Because the path to the template files is already known, the fifth line from the bottom of Example 12-3, which reads:

$smarty->display("$path/temp/smartytest.tpl");

Should be replaced with:

$smarty->display("smartytest.tpl");

Because the path to the template files is already known, the final line of Example 12-1, which reads

$smarty->display("$path/temp/index.tpl");

Should be replaced with:

$smarty->display("index.tpl");

in line 3 of example:

$msg2 - mysql_error();

should be:

$msg2 = mysql_error();

Example 4-9. After evaluating the subexpressions in parentheses
1 + (6) - (20)
2 - (60) + 1
5 + 2 - 4 + (4)

3rd example should be:

5 + 2 - 4 + (3)

Note from the Author or Editor: