PHP & MySQL: The Missing Manual, 2nd Edition
The book that should have been in the box
Publisher: O'Reilly Media
Final Release Date: November 2012
Pages: 546

If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users. With step-by-step tutorials, this completely revised edition gets you started with expanded coverage of the basics and takes you deeper into the world of server-side programming.

The important stuff you need to know:

  • Get up to speed quickly. Learn how to install PHP and MySQL, and get them running on both your computer and a remote server.
  • Gain new techniques. Take advantage of the all-new chapter on integrating PHP with HTML web pages.
  • Manage your content. Use the file system to access user data, including images and other binary files.
  • Make it dynamic. Create pages that change with each new viewing.
  • Build a good database. Use MySQL to store user information and other data.
  • Keep your site working. Master the tools for fixing things that go wrong.
  • Control operations. Create an administrative interface to oversee your site.
Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyPHP & MySQL: The Missing Manual, 2nd Edition
 
3.7

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (0)

67%

of respondents would recommend this to a friend.

Reviewed by 3 customers

Sort by

Displaying reviews 1-3

Back to top

(3 of 3 customers found this review helpful)

 
5.0

Good enough for me

By Cole

from Grand Rapids, MI

About Me Client-side Programmer

Verified Reviewer

Pros

  • Accurate
  • Easy to understand
  • Helpful examples
  • Well-paced

Cons

  • Some Grammar Errors

Best Uses

  • Intermediate
  • Novice
  • Student

Comments about oreilly PHP & MySQL: The Missing Manual, 2nd Edition:

(I've got the most recent ebook, as of October 2013.)

This is a good book. Yes, there are some quality control issues, grammar-wise, but the content is still good and well-paced. It's a tiny bit frustrating to run into some of the unedited sentences (and there are a lot; I stopped submitting grammatical corrections to the errata page because I ran into so many, at least two or three per chapter, sometimes), but it's a programming book, and the programming information is solid.

As for the previous review stating that the code examples didn't work, I think that that person might have not adhered to the directory structure the book uses, and that therefore their scripts weren't linking to each other properly. Just like with most coding books, you've really got to stick to the directory structure the examples in this book use, especially if you're new to the language. I can definitely vouch for the quality of the code examples; they all worked for me, sometimes after a little investigating to figure out what I had done wrong.

I'm a client side programmer who came to this book with a solid foundation in other languages (JavaScript mostly), but with no PHP or MySQL knowledge. After powering through the book, I feel like I've got the confidence and basic/advanced beginner knowledge to move on to more hefty texts and more professional web apps. Missing Manuals are generally jumping-off points more than all-encompassing textbooks, and this book does a very good job of providing a jumping-off point. I'm very excited to dive into more advanced books and I have a much easier time understanding more sterile, official PHP and SQL documentation than I did before reading this book.

Overall, it's a fun book. You build a little proto-social-network-type site that's rudimentary but nonetheless involves a pretty comprehensive survey of queries, functions, database administration, basic security, and lots of other really useful skills. There are also lots of sidebars and extra notes that go over things like best practices, common conventions, and other information that's important for beginners to learn about early on, before they make a habit of coding poorly. I give it 4.5 out of 5, just because of the grammatical issues, many of which the author seems to be addressing, given his responsiveness on the errata page. I rounded up to 5 partly because I think that the previous 2 star review claiming that the code examples don't work was unfair and shouldn't drag they cumulative rating down. The code examples work well.

Buy this book; it's more convenient and of higher quality than the big pile of disconnected tutorials you'd have to sort through online, plus it'll help you pick up some best practices early on. Go through the chapters in order, adhere to the directory structure, think critically about the information presented, and take breaks as you go along to get creative and work with the skills you've built so far. It's a very good investment, money-wise and time-wise.

(3 of 3 customers found this review helpful)

 
2.0

Good Book: Very Poor Quality Control

By haitiman

from Miami, FL

About Me Developer

Verified Reviewer

Pros

  • Well-written

Cons

  • Too many errors

Best Uses

    Comments about oreilly PHP & MySQL: The Missing Manual, 2nd Edition:

    I bought the first edition of this book, it was full of errors. O'Reilly was good and sent me the 2nd edition; that book version still had errors. I've reached a point in this book where I simply couldn't get the code to work. I have even tried to download the code from the missing manuals, and it didn't work either. I am sick of having to look through the errata pages to make sure it was something the author mistook or overlooked.

    This book suffers from poor quality control. It shouldn't have been released with this many errors. Even the files available for download have errors in them. For example, I had to correct the link to the images in the phpMM.css file for chapter nine.

    I am not a novice computer user so imagine how people who are novice users or aspiring PHP coders feel when they can't something from the book to work correctly.

    Buyer beware! Buy this book only if enjoy frustration.

    (4 of 4 customers found this review helpful)

     
    4.0

    This book gets you started

    By teak

    from Jyväskylä, Finland

    About Me Developer

    Verified Reviewer

    Pros

    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Novice
      • Student

      Comments about oreilly PHP & MySQL: The Missing Manual, 2nd Edition:

      This book is part of the Missing Manual series published by O'Reilly company. It is first Missing Manual which I've read so I cannot compare the book with others in the same series.

      The main objective of the book is to teach how to make dynamic web page with PHP and MySQL. One can get going with zero knowledge on programming and databases by using this book. The PHP basics were taught quite cursory but one can get away with these. On the other hand the basics of MySQL and databases were taught well. I would say that on the database front this was one of the best presentations on the basics which I've encountered.

      One thing where the book fell short in my mind was on introducing some functions of PHP, but the book correctly pointed out that there is plenty of good tutorials on the net. The book also used "outdated" mysql API and not the currently recommended ones. One of the major positive surprises was the fact that the book introduces also good programming practices. Other major topics included were security questions, regular expressions, error handling, binary files and MySQL, cookies and sessions, and 1-to-1, 1-to-many, and many-to-many relationships on databases.

      The order of the material presented was logical (while I might have chosen some other order for some items). The text was well written and typographic conventions well thought. I'm bold and say that this would be the book for somebody doing his first dynamic web page using databases. For learning basic database stuff this might be good place to start but there might be better books for that. For learning just PHP there are better resources. But as I mentioned this is an excellent book for learning basics of both PHP and MySQL.

      Displaying reviews 1-3

      Back to top

       
      Buy 2 Get 1 Free Free Shipping Guarantee
      Buying Options
      Immediate Access - Go Digital what's this?
      Ebook: $33.99
      Formats:  DAISY, ePub, Mobi, PDF
      Print & Ebook: $43.99
      Print: $39.99