Errata for Web Database Applications with PHP and MySQL

"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"

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

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

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

"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)"

"...there are six attributes in each row: wine_id wine_name, type, ..." The third attribute name NOW READS "wine_type".

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..."

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

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

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

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

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

hyphenation of "timestamp" fixed ##########################################

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

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

Setup -> Set up ##########################################

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

Marketing Secret -> Flat Foot ##########################################

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

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

E_COMPILE WARNING -> E_COMPILE_WARNING ##########################################

markup -> mark up ##########################################

layout -> lay out ##########################################

"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."

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

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

"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..."

"Appendix E" should be "Appendix G".

"Appendix E" should be "Appendix G".

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 ...

rollback -> roll back ##########################################

shutdown -> shut down ##########################################

backup -> back up ##########################################

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

backup -> back up ##########################################

startup -> start up and shutdown -> shut down ##########################################

MySQL includes is the -> MySQL includes the ##########################################

"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"

beings -> begins ##########################################

KB. -> KB and MySQL -> MySQL server ##########################################

login -> log in and logout -> log out ##########################################

Setup -> Set up ##########################################

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

"Chapter 7" should be "Chapter 9".

"Chapter 7" should be "Chapter 9".

Lookup the country_id -> Look up the country_id ##########################################

Lookup the title -> Look up the title ##########################################

setup -> set up ##########################################

authentication.inc NOW READS: includes/authenticate.inc

identified -> identify ##########################################