Errata

PHP & MySQL: The Missing Manual

Errata for PHP & MySQL: The Missing Manual

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 XVI
Last paragraph

example codes under mentioned website are not complete. Only chapter 1 and 2 partly available.

Note from the Author or Editor:
Example code can now be downloaded from the book's Missing CD page at http://missingmanuals.com/cds/phpmysqlmm/

The direct link to the complete zip file is http://examples.oreilly.com/9780596515867/PHPMySQLMissingCD.zip

 Yogibear  Dec 31, 2011 
Other Digital Version
XVI
Last paragraph

Raised the issue of missing code examples with O'Reilly on their 'Get Satisfaction' page (http://support.oreilly.com/oreilly).

All code examples should now be available for download.

Note from the Author or Editor:
Example code can now be downloaded from the book's Missing CD page at http://missingmanuals.com/cds/phpmysqlmm/

The direct link to the complete zip file is http://examples.oreilly.com/9780596515867/PHPMySQLMissingCD.zip

 emteec  Jan 09, 2012 
Printed
Page 6
3rd paragraph

"Once the download's done" should read, "Once the download is done..."

 Ediana  Feb 29, 2012 
Printed
Page 18-19
United States

On page 18 the book begins writing a code sample. The last item on page 18 is <div id="content">.

On page 19, the first code block ends with a closing <div> tag but right before that there is a closing <form> tag. Where does this form tag originate? I believe this is a mistake but I'm not sure.

Note from the Author or Editor:
This is indeed an error. Remove the line that reads </form> entirely.

 Anonymous  Dec 07, 2011 
Printed
Page 18
3rd or 4 th paragraph

There's no mention in the "Writing your Second Program" section to save the "sayHello.html" code.

Whereas in other areas, i.e. page 19, 1st paragraph, it says "Save this program as "sayHelloWeb.php.

Please clarify. Later in this section/chapter there's mention of sayHello.html but at no time is there a request to save this code.

Thanks.

Note from the Author or Editor:
For clarity, at the end of the first paragraph, we will add the text "Go ahead and save this HTML as sayHello.html."

 Joe  Dec 10, 2011 
Printed
Page 18
code near bottom of page

The code at the top of pg 19 contains a closing </form> tag, but the opening <form> tag on pg 18 seems to be missing.

Note from the Author or Editor:
This is indeed an error. Remove the line that reads </form> entirely.

 Eric Egana  Feb 07, 2012 
PDF
Page 19
fourth line of code

sayHelloWeb.php: It looks like some example code is missing. There is a </form> tag with no corresponding <form> tag. Since the Missing CD is not yet posted, I can't download it to check. Needless to say, the example doesn't work.

Note from the Author or Editor:
This is indeed an error. Remove the line that reads </form> entirely.

 Catbar  Dec 09, 2011 
Printed
Page 19
Forth line from the top of the page

</form>

There is no starting <form> for this closing. Also when I run this program on the Mac or on Windows instead of showing the output, the program sayhellpweb.php opens up in the editor. Could this be the issue?

Regards,
Neeraj

Note from the Author or Editor:
This is indeed an error. Remove the line that reads </form> entirely.

 Neeraj  Mar 18, 2012 
Printed
Page 39
Step # 2

"of" should be "if" . . .

2. Figure out of the Twitter handle has an @ sign in it.

 Eric Egana  Feb 10, 2012 
Other Digital Version
42
Link to cd

The link to the cd works, but the cd does not contain all the chapters. It only has chapters one and two. Also, the CSS file is incomplete. Some of the div tags don't work because of this.

Note from the Author or Editor:
Notes from the Author: Example code can now be downloaded from the book's Missing CD page at http://missingmanuals.com/cds/phpmysqlmm/

The direct link to the complete zip file is http://examples.oreilly.com/9780596515867/PHPMySQLMissingCD.zip

 Jeff Young  Dec 24, 2011 
Printed
Page 42
Paragraph below first "NOTE" section

"now" should be "know"

You (k)now how PHP strings work, and you've already used . . .

Eric Egana  Feb 10, 2012 
PDF
Page 48
4th line and 29th line


At the end of php code blocks (just before ?>), $twitter_url; should be $twitter_handle;

Why?

Because twitter_url is not defined in these blocks of PHP code on p.48. Output pasted below:

Derek Trucks
Email: derek@DerekTrucks.com
Facebook URL: http://www.facebook.com/DerekTrucksPHP Notice: Undefined variable
: twitter_url in E:\\PHP-Work\TOp48.php on line 17

Note from the Author or Editor:
1st edition: $twitter_url should be $twitter_handle on p. 48, 4th and 29th lines.

Thanks!

 Anonymous  Jul 21, 2012 
Printed
Page 70
First command near bottom of second column

It seems that to re-hide the hidden files again, the word 'TRUE' should be 'FALSE.'

$ defaults write com.apple.finder Apple-
ShowAllFiles TRUE (change to FALSE)

 Eric Egana  Feb 12, 2012 
Printed
Page 70
last paragraph, last piece of code, second line

In order to HIDE all files on a Mac:

$ defaults write com.apple.finder AppleShowAllFiles FALSE

The book shows TRUE (again), as in the first piece of code written in the Power Users' Clinic which offers instruction on how to turn all the file ON... in order to turn the files OFF, a FALSE statement needs to be present in the code.

 Brian Divizich  Mar 02, 2012 
Printed
Page 92
1st paragraph of "Connecting to a MySQL Database"

The last word of the first paragraph of "Connecting to a MySQL Database" is the word "followng:" which is the word "following" with a missing "i."

 Brian Divizich  Mar 02, 2012 
Printed
Page 129
Bottom of Page---- NOTE Section

The re are also several additional things you can pass into....
^ Extra space in the word "There"

Note from the Author or Editor:
Thanks.

 haitiman  Mar 16, 2013 
Printed
Page 147
2nd paragraph - 4th Line.

"...for a database: databases function better with numbers that text."

It should be

"...for a database: databases function better with numbers than text."

Note from the Author or Editor:
THanks.

 haitiman  Mar 30, 2013 
PDF,
Page 173
Code snippet

In the statement for $twitter_url, the variable $position is not defined. Going by earlier code, the statement could be inserted above:

$position = strpos($twitter_handle, "@");

 Halyn  Jan 03, 2012 
Printed
Page 202
between 2nd and 3rd paragraph

the regex for the error message variable causes an error.

$error_message = preg_replace_all("/\\\\/", '', $_REQUEST['error_message']);

causes the page to not load. there is some kind of error.

Note from the Author or Editor:
preg_replace_all should be replaced by preg_replace

 Anonymous  Dec 28, 2011 
PDF,
Page 202
Response to Dec 28, 2011 errata for page 202

The function preg_replace_all() is not a pre-existing PHP function. Rather, the function preg_replace() is meant, and it defaults to "replacing all" if a limit argument is not included.

Note from the Author or Editor:
preg_replace_all should be replaced by preg_replace

 Halyn  Jan 04, 2012 
Printed
Page 220
bold code at bottom

function label is missing
line reads:
function ($user_error_message.....

should read
function handle_error ($user_error_message...

 AmeJane  Dec 14, 2011 
Printed
Page 220
1st paragraph - 2nd sentence

There is a typo here.

"Now multiple that..."

That should say:

"Now multiply that... "

 haitiman  Apr 13, 2013