This book comes with a CD in the back with lots of examples to learn from... at least it's supposed to. Actually you have to download the examples off the publisher's website (for an additional price, of course).
As for teaching PHP and MySQL, it's not worth it. I followed the examples to the letter but couldn't get PHP to work with MySQL. (Couldn't even get them to talk to each other)
If you're going to waste your money on this though, I *highly* recommend you order directly from the publisher, since it "seems" if you do, you might get the examples for free (maybe), but don't waste your money on this.
Author(s): Kevin Yank
Publisher: Sitepoint
Year: 2003
Language: English
Pages: 111
Build Your Own Database Driven Website using PHP & MySQL......Page 5
Table of Contents......Page 11
Introduction......Page 17
What's In This Book......Page 18
The SitePoint Forums......Page 21
Your Feedback......Page 22
Welcome to the Show......Page 23
Installing MySQL......Page 24
Installing PHP......Page 27
Linux Installation......Page 32
Installing MySQL......Page 33
Installing PHP......Page 37
Installing MySQL......Page 40
Installing PHP......Page 42
Post-Installation Setup Tasks......Page 43
If Your Web Host Provides PHP and MySQL......Page 45
Your First PHP Script......Page 46
Summary......Page 48
An Introduction to Databases......Page 51
Logging On to MySQL......Page 53
Creating a Database......Page 56
Creating a Table......Page 57
Inserting Data into a Table......Page 59
Viewing Stored Data......Page 60
Modifying Stored Data......Page 62
Summary......Page 63
Introducing PHP......Page 65
Basic Syntax and Commands......Page 67
Variables and Operators......Page 68
Arrays......Page 70
User Interaction and Forms......Page 71
Control Structures......Page 75
Multipurpose Pages......Page 79
Summary......Page 83
A Look Back at First Principles......Page 85
Connecting to MySQL with PHP......Page 87
Sending SQL Queries with PHP......Page 89
Handling SELECT Result Sets......Page 90
Inserting Data into the Database......Page 93
“Homework” Solution......Page 96
What’s Next?......Page 101
Index......Page 103