Errata

Web Database Applications with PHP and MySQL

Errata for Web Database Applications with PHP and MySQL, Second Edition

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
Printed
Page 23
10th line from the bottom

"11100100" NOW READS "11100001"

Anonymous    Jan 01, 2006
Printed
Page 49
"a bit to hard to" NOW READS "a bit too hard to"

Anonymous    Aug 01, 2005
Printed
Page 49
the print function does not add a new line character, hence the fragment printed out NOW READS '1111' not '11 11'

Anonymous    Jan 01, 2006
Printed
Page 53

"Include files that are placed in directories outside of the web
server's document root are protected from accessed via the web server"

NOW READS:
"Include files that are placed in directories outside of the web
server's document root are protected from access via the web server"

Anonymous    Aug 01, 2005
Printed
Page 59

"To including print_r() output as part of a web page,..."

NOW READS:
"To include print_R() output as part of a web page,..."

Anonymous    Aug 01, 2005
Printed
Page 62
4th line from the bottom

"Mars" => array("dist"=>0.39, "dia"=>0.53,

NOW READS:
"Mars" => array("dist"=>1.52, "dia"=>0.53,

Anonymous    Jan 01, 2006
Printed
Page 100
table

Minutes NOW READS lower case i, not upper case.

Anonymous    Aug 01, 2005
Printed
Page 158

The GROUP BY clause in the query the bottom of the page NOW READS:
"GROUP BY surname, firstname, city HAVING count(*) > 2".

Anonymous    Aug 01, 2005
Printed
Page 159
the last query on the page;

"SELECT ciry FROM customer GROUP BY city"

NOW READS:
"SELECT city FROM customer GROUP BY city"

179:
"//Print the field length in brackets e.g.(2)"

NOW READS:
"//Print the field length in parentheses e.g.(2)"

Anonymous    Aug 01, 2005
Printed
Page 174
List Item Number 5

"...there are six attributes in each row: wine_id wine_name, type, ..."

The third attribute name NOW READS "wine_type".

Anonymous    Jan 01, 2006
Printed
Page 188
line 9:

if (isset($defaultvalue) && $result == $defaultValue)

NOW READS:
if (isset($defaultValue) && $result == $defaultValue)

195:
"This makes them a little different to the global variables..."

NOW READS:
"This makes them a little different from the global variables..."

Anonymous    Aug 01, 2005
Printed
Page 211
line above mysql_insert_id heading

The last line of the example is missing a closing square bracket. It should read:
print "There are {$row["custcount"]} customers";

Anonymous    Aug 01, 2008
Other Digital Version
211
line above mysql_insert_id heading

The last line of the example is missing a closing square bracket. It should read:
print "There are {$row["custcount"]} customers";

Anonymous    Aug 01, 2008
Printed
Page 223
first word

The very first word on the page is misspelled. It says "sever" instead of "server".

Anonymous    Aug 01, 2008
Other Digital Version
223
first word

The very first word on the page is misspelled. It says "sever" instead of "server".

Anonymous    Aug 01, 2008
Printed
Page 226

http://pear.php.net/manual/en/core.db.php

NOW READS:
http://pear.php.net/manual/en/package.database.php#package.database.db

Anonymous    Aug 01, 2005
Printed
Page 244
Lines 18 and 21

$template->addBlockFile

NOW READ:
$template->addBlockfile

Anonymous    Jan 01, 2006
Printed
Page 245
8th line from bottom of page

loadTemplateFile

NOW READS:
loadTemplatefile

Anonymous    Jan 01, 2006
Printed
Page 289
3rd Paragraph

if (!ereg("^[[:alpha:]]$", $string))

NOW READS:
if (!ereg("^[[:alpha:]]+$", $string))

This same CORRECTION also appears in the following two examples.

Anonymous    Aug 01, 2005
Printed
Page 303
7 lines from bottom

hyphenation of "timestamp" fixed

##########################################

Anonymous    Apr 01, 2007
Printed
Page 304
2nd para, line 1

"...required to enter a date..."
should be:
"...required to enter a time..."

Anonymous    Aug 01, 2008
Other Digital Version
304
2nd para, line 1

"...required to enter a date..."
should be:
"...required to enter a time..."

Anonymous    Aug 01, 2008
Printed
Page 344
Examples 10-3

Missing initial < before ?php HAS BEEN CORRECTED.

Anonymous    Aug 01, 2005
Printed
Page 346
Line 3 from top

Setup
->
Set up

##########################################

Anonymous    Apr 01, 2007
Printed
Page 351
Line 6 from top

The fields are passed back the session array variable
->
The fields are passed back in the session array variable

##########################################

Anonymous    Apr 01, 2007
Printed
Page 372
Line 1

Marketing Secret
->
Flat Foot

##########################################

Anonymous    Apr 01, 2007
Printed
Page 395
in the comments in example 11-16,

"// Connect to a authenticated session..."

NOW READS:
"// Connect to an authenticated session..."

Anonymous    Aug 01, 2005
Printed
Page 398
First sentence after bullets

Even if none of these of reasons
->
Even if none of these reasons

##########################################

Anonymous    Apr 01, 2007
Printed
Page 406
2nd paragraph

"doc_ref ="

NOW READS:
"docref_ext ="

Anonymous    Aug 01, 2005
Printed
Page 412
Line 2 from bottom

E_COMPILE WARNING
->
E_COMPILE_WARNING

##########################################

Anonymous    Apr 01, 2007
Printed
Page 426
Last line in "To define new standards" paragraph

markup
->
mark up

##########################################

Anonymous    Apr 01, 2007
Printed
Page 426
Line 3 from bottom

layout
->
lay out

##########################################

Anonymous    Apr 01, 2007
Printed
Page 447
below Fig. 13-8

"options['fontsize']"

NOW READS:
"options['fontSize']"

482:
"It's required that the attribute (or comma-separated) attributes listed in the USING clause are enclosed in brackets."

NOW READS:
"It's required that the attribute (or comma-separated attributes) listed in the USING clause are enclosed in brackets."

Anonymous    Jan 01, 2006
Printed
Page 463
2nd to last line of the page,the function to calculate the area of a circle

function area()
{
return 2 * pi() * $this->radius;
}

NOW READS:
function area()
{
return pi() * $this->radius * $this->radius;
}

Anonymous    Aug 01, 2005
Printed
Page 469
Second paragraph

Example 4-9 also define the...
->
Example 4-9 also defines the...

##########################################

Anonymous    Apr 01, 2007
Printed
Page 486

"but only for cities that have more the five customers"

NOW READS:
"but only for cities that have more than five customers"

Anonymous    Jan 01, 2006
Printed
Page 496

"Section 5 of the MySQL also includes an explanation of how..."

NOW READS:
"Section 5 of the MySQL manual also includes an explanation of how..."

Anonymous    Jan 01, 2006
Printed
Page 496
Line 5 from bottom

"Appendix E" should be "Appendix G".

Anonymous    Aug 01, 2008
Other Digital Version
496
Line 5 from bottom

"Appendix E" should be "Appendix G".

Anonymous    Aug 01, 2008
Printed
Page 503

The command for loading the winery.csv file listed as:
... LOAD DATA INFILE 'winery.cdf' INTO TABLE winery ...

NOW READS:
... LOAD DATA INFILE 'winery.csv' INTO TABLE winery ...

Anonymous    Jan 01, 2006
Printed
Page 517
Line 5 from top

rollback
->
roll back

##########################################

Anonymous    Apr 01, 2007
Printed
Page 522
Last sentence in first paragraph of "Heap" section

shutdown
->
shut down

##########################################

Anonymous    Apr 01, 2007
Printed
Page 523
Lines 2, 15, and 19 from top

backup
->
back up

##########################################

Anonymous    Apr 01, 2007
Printed
Page 524
At the bottom

For Microsoft Windows, if the file is stored as
C:windows empws-dump, you can use:

mysql>SOURCE C: empws-dump

NOW READS:
For Microsoft Windows, if the file is stored as
C:windows empws-dump, you can use:

mysql>SOURCE C:windows empws-dump

Anonymous    Jan 01, 2006
Printed
Page 525
Line 2 from bottom

backup
->
back up

##########################################

Anonymous    Apr 01, 2007
Printed
Page 527
Line 5 from bottom

startup
->
start up

and

shutdown
->
shut down

##########################################

Anonymous    Apr 01, 2007
Printed
Page 537
Line 1 of second paragraph

MySQL includes is the
->
MySQL includes the

##########################################

Anonymous    Apr 01, 2007
Printed
Page 539
change the last bullet on the page from

"Queries that use functions that should return different results dont't use the cache"

NOW READS:
"Queries that use functions that could return different results dont't use the cache"

Anonymous    Jan 01, 2006
Printed
Page 539
Line 14 from bottom

beings
->
begins

##########################################

Anonymous    Apr 01, 2007
Printed
Page 540
Line 3 and 5 from top

KB.
->
KB

and

MySQL
->
MySQL server

##########################################

Anonymous    Apr 01, 2007
Printed
Page 550
Line 2 from top

login
->
log in

and

logout
->
log out

##########################################

Anonymous    Apr 01, 2007
Printed
Page 566
Line 16 from top

Setup
->
Set up

##########################################

Anonymous    Apr 01, 2007
Printed
Page 566
Comment line immediately preceding function selectWidget

// (3) The PEAR DB Result...
->
// (4) The PEAR DB Result...

##########################################

Anonymous    Apr 01, 2007
Printed
Page 571
Line 11 from bottom

"Chapter 7" should be "Chapter 9".

Anonymous    Aug 01, 2008
Other Digital Version
571
Line 11 from bottom

"Chapter 7" should be "Chapter 9".

Anonymous    Aug 01, 2008
Printed
Page 580
Lines 6 from bottom

Lookup the country_id
->
Look up the country_id

##########################################

Anonymous    Apr 01, 2007
Printed
Page 581
Line 8 from top

Lookup the title
->
Look up the title

##########################################

Anonymous    Apr 01, 2007
Printed
Page 631
Line 21 from top

setup
->
set up

##########################################

Anonymous    Apr 01, 2007
Printed
Page 658 and 659

authentication.inc

NOW READS:
includes/authenticate.inc

Anonymous    Jan 01, 2006
Printed
Page 745
4th line from the top

"wine_variety" NOW READS "grape_variety"

Anonymous    Jan 01, 2006
Printed
Page 751
Line 7 from top

identified
->
identify

##########################################

Anonymous    Apr 01, 2007