Learning PHP and MySQL (Paperback)

~ (Author), Jon A. Phillips (Author)
Key Phrases: file manipulation, package manager, session security, Classic Shell Scripting, Ellen Siever, Aaron Weber (more...)

Editorial Reviews

Product Description

The PHP scripting language and MySQL open source database are quite effective independently, but together they make a simply unbeatable team. When working hand-in-hand, they serve as the standard for the rapid development of dynamic, database-driven websites. This combination is so popular, in fact, that it's attracting many programming newbies who come from a web or graphic design background and whose first language is HTML. If you fall into this ever-expanding category, then this book is for you.

Learning PHP and MySQL starts with the very basics of the PHP language, including strings and arrays, pattern matching and a detailed discussion of the variances in different PHP versions. Next, it explains how to work with MySQL, covering information on SQL data access for language and data fundamentals like tables and statements. Finally, after it's sure that you've mastered these separate concepts, the book shows you how to put them together to generate dynamic content. In the process, you'll also learn about error handling, security, HTTP authentication, and more.

If you're a hobbyist who is intimidated by thick, complex computer books, then this guide definitely belongs on your shelf. Learning PHP and MySQL explains everything--from basic concepts to the nuts and bolts of performing specific tasks--in plain English.

Part of O'Reilly's bestselling Learning series, the book is an easy-to-use resource designed specifically for newcomers. It's also a launching pad for future learning, providing you with a solid foundation for more advanced development.

About the Author

Michele Davis, a career writer since she was eight years old, has owned a technical writing and software training company since 1988. Michele contributed to the "HTML Bible 4.0" (Wiley).

Jon Phillips is a software developer who works with Oracle 9i, Oracle Financials and HRMS. Jon creates the backend of web sites that Michele designs and writes. Jon uses PHP and MySQL for numerous clients that want a database or web site interaction, such as forms. Both Michele and Jon are members of a PHP list serve.

Product Details

• Paperback: 384 pages
• Publisher: O'Reilly Media; 1 edition (June 2, 2006)
• Language: English
• ISBN-10: 0596101104
• ISBN-13: 978-0596101107
• Product Dimensions: 9 x 7 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 3.1 out of 5 stars  See all reviews (25 customer reviews)
• Amazon.com Sales Rank: #298,250 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #69 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL
  #83 in	Books > Computers & Internet > Web Development > Programming > PHP

Customer Reviews

Most Helpful Customer Reviews

24 of 24 people found the following review helpful:

2.0 out of 5 stars Reurned for a refund, December 17, 2006

By	Burak (New York, NY United States) - See all my reviews

There are two problems with this book. First of all it's filled with typos, both in the text and in the sample codes. The typos in the text made me laugh (its vs. it's type stuff), those in the codes made me cry. There are entire lines in some codes or screen ouputs that clearly do not belong there (take a look at page 126, about a third of the way into the page there's a line that goes --> ,"Aaron Weber"); <-- . Clearly, this line serves no purpose on its own and it was accidentally cut and paste from the end of the following line. Just too many typos, within 10 pages I had lost my confidence in this book. Secondly (and more importantly), this is NOT a beginner's book. It attempts to educate the reader on PHP and MySQL, and fails at both. For instance, the book never once mentions something as basic as the difference between echo and print in PHP. Then there's the instructions on installing phpMyAdmin on page 140, specifically item 6. I know nothing about MySQL so I have no idea how to "set the hostname, etc. of my database in the config.inc.php file". Thanks for nothing. In summary, if you're a beginner, you may think you've learned PHP and MySQL upon reading this book, and in fact you'll just be confused, and if you already know them, then why on earth would you use this simplistic book? I've returned my copy for a refund. By the way, I saw that one of the positive reviews below was posted on the book's blog site. Let's see if mine makes it.

35 of 38 people found the following review helpful:

4.0 out of 5 stars The Very Book for the Very Beginner, June 29, 2006

By	Brett Merkey (Palm Harbor, FL United States) - See all my reviews (REAL NAME)

This book will take you from a basic understanding of creating static HTML to an elementary but quite nifty practical knowledge of serving up dynamic Web pages on your own.

Chapters 1-6 take you through basic orientation, the installation of Apache, PHP and MySQL, followed by an intro to PHP statements.

Chapters 7-9 introduce database concepts and step you through getting PHP to talk to MySQL.

Chapters 10-17 begin the process of creating forms and other components of Web sites and applications following all the way through to integrating some sample applications.

Each step and procedure has ample code printouts, logic diagrams and output screenshots. Review of knowledge was done well. One feature of this book you should take advantage of is the question section at the end of each chapter. I usually find these irritating and skip them because often the questions don't reinforce learning and no answers are provided. The questions in this book *are* well constructed and the answers *are* provided.

Quibbles: Be prepared for a bit of keyboarding. O'Reilly provides a site for the book but the example code is not available for download. Your first bout of keying code may end in failure because the authors forget that in the first examples (the most important ones for an absolute beginner!) they need to recall being a beginner. They ask you to write out and save "a simple HTML document." I did that. The example did not work on the server. I checked this, I checked that, I re-typed the code, I typed other examples. No luck. Then I stumbled onto changing the extension of my .html file to .php and all was well. See my point?

6 of 6 people found the following review helpful:

3.0 out of 5 stars Wrong book for me, right book for some, April 26, 2007

By	Sean Crago "seancrago" (Kansas City, MO USA) - See all my reviews (REAL NAME)

I knew I had picked up the wrong book when, in the first or second chapter, the authors said that variable types didn't matter and that they wouldn't bother covering them until late in the book. Admittedly, I can see their point, but the way the statement was written made it apparent that they were aiming this at HTML authors and other people with little to no real programming experience. If you want to pick up the PHP language and already have experience with a real programming language or two, you'd be better off picking up something else. If not, this book actually would be a good way to get started.

Update: Now that I've chewed through a little more of the book, I would no longer recommend this book to even a beginner. Uncommented, and hard to read examples that make poor use of whitespace dominate later chapters. The examples aren't the 3-4 page long beasts you find in some C or Java books, but nonetheless, this book does not demonstrate good coding practices, and should not be used by a new programmer to pick up the ropes.