Beginning PHP 5 and MySQL: From Novice to Professional [Paperback]

William J. Gilmore (Author)

Book Description

ISBN-10: 1893115518 | ISBN-13: 978-1893115514 | Publication Date: October 21, 2004

Beginning PHP 5 and MySQL: From Novice to Professional, offers a comprehensive introduction to two of the most popular web application building technologies on the planet: the scripting language PHP and the MySQL database server. Readers are not only exposed to the core aspects of both technologies, but also gain valuable insight into how they are used in unison to create dynamic data-driven web applications. It is the first book to delve into the features of the latest releases of the world's most popular open source web development technologies, the MySQL 4 database server and PHP 4 scripting language. Not only will readers profit from extensive introductions to the core features of each technology, but also from insight into the cutting-edge, sometimes undocumented features of the most recent versions.

Editorial Reviews

About the Author

W. Jason Gilmore is a Columbus, Ohio-based developer, consultant, writer, and editor. He's a cofounder of the CodeMash conference and is a member of the MySQL Conference speaker selection board. In his previous capacity as Apress's open source editor, he fostered the publication of more than 60 books, along the way helping to transform the open source line into one of the industry's most respected publishing programs.

Through W.J. Gilmore, LLC, (WJGilmore.com) Jason provides an array of consulting and web development services to small businesses around the country. Contact Jason at [e-mail] if you're looking for competent, timely, and cost-effective services.

Product Details

• Paperback: 800 pages
• Publisher: A-Press (October 21, 2004)
• Language: English
• ISBN-10: 1893115518
• ISBN-13: 978-1893115514
• Product Dimensions: 9.3 x 7.5 x 1.6 inches
• Shipping Weight: 2.6 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (90 customer reviews)
• Amazon Best Sellers Rank: #489,902 in Books (See Top 100 in Books)
  • #28 in Books > Computers & Technology > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

172 of 175 people found the following review helpful:

5.0 out of 5 stars Beginning PHP Not Beginning Programming, June 17, 2005

By 

David Stapleton (California) - See all my reviews
(VINE VOICE)    (REAL NAME)   

Amazon Verified Purchase

This review is from: Beginning PHP 5 and MySQL: From Novice to Professional (Paperback)

[Updated for Second Edition]
A beginning PHP book, not a beginning programming book. The subtitle, 'From Novice to Professional', can be a tad misleading for the novice coder. A beginning programming book covers a lot of material that this book assumes the reader already understands. Many software books include a 'Who Is This Book For' section that offers some guidance on the suitable reader knowledge level, not this one.

That said, I found this book to be very helpful. The sections on installing and configuring Apache, PHP and MySQL certainly saved me many hours of reading the online documentation and tweaking of settings while setting up my local test bed. That, in itself, made me a very happy camper. The author goes on to cover the various aspects from the basics of the PHP language and class libraries to topics like Authentication, Security, Session Handlers and eMail functionality that help anyone new to PHP setup some fairly sophisticated site capabilities.

The second edition has been supplemented with an added 200 pages, including a new section on PEAR (PHP Extension and Application Repository). This is a wealth of prewritten classes and packages that can be used to add even more sophisticated functionality to the novice's web development toolbox. The author demonstrates several of the more prominent packages.

The second edition has greatly beefed up with additional coverage of MySQL 5, including chapters on stored procedures, triggers and the PHP mysqli extension (all missed in the first edition). Most of the examples offered are clean and general enough to be useful templates for the reader's tailoring.

My suggestion for novices to PHP is read through chapter 9, then skip to the various sections that solve specific problems being faced or are of particular interest, including installing and configuring your local test bed.

Bottom line, the first edition was a good book for intermediate to veteran programmers looking for a quick tutorial on PHP (circa version 5.0); the second edition is even better. Novice programmers should ensure that they have a full understanding of the basics of programming (and OOP) before attempting it. I would now use this book to teach a class on PHP.
P-)

89 of 94 people found the following review helpful:

3.0 out of 5 stars Frustrating, December 20, 2006

By 

David Diez (Boston, MA) - See all my reviews

Amazon Verified Purchase

This review is from: Beginning PHP and MySQL 5: From Novice to Professional (Beginning: From Novice to Professional) (Paperback)

I'm not new to programming or web programming, but I was new to PHP. This book is much better as a reference than an intro to PHP, however, even there it has its limitations.

I bought this book, read the first 5 chapters (130 pages), and then stopped reading it because I was learning too slowly (ie, reading too many pages and picking up too little usability). As an introductory text, I would rather this book moved at a greater breadth but less depth -- it goes through dozens of specific functions, making it feel like a dictionary. There is also little attention brought to the functions you will be using soon over the ones you will not use for awhile yet. In that sense, it was very frustrating to spend a lot of time reading several chapters and still not feeling like I was getting anywhere or able to use much of the power of PHP.

In my frustration, I decided to revisit w3schools . com, and I found their tutorial immensely useful as an introduction to both PHP and MySQL (I needed both and I needed them quickly). That choice allowed me to start writing some PHP code within an hour and start working with databases quickly as well (nothing is mentioned about MySQL until Chapter 24 of this book).

So now, instead of use this PHP/MySQL book as a learning tool, I use it as a reference. The index isn't ideal*, so it still isn't a great reference, and the MySQL layout has not been helpful. I will be buying some PHP cookbooks to get a better feel for the capabilities of PHP and how to use its functions properly, and I will report back in this review after I find a better reference to recommend over this one (hopefully by mid-January).
*The index is HUGE, but I still have a difficult time finding things I need since I look for a lay-word over the word that is listed. If I already knew the word that is listed in the index, I may not even need to look in the index.

This book was written for new programmers that want a programming introduction to PHP and was not written for web programmers new to PHP. Although I program, I want features of a web programming book when I buy a web programming book.

What I consider a feature of a (good) web programming book: Chapters are split into a quick intro to the most commonly used fuctions of the chapter's topic (5-10 pages) and a longer part for use as a reference (15-20 pages). The book's format has good eye catching sections so readers do not waste time finding what is important if we just want to skim things so we can get into doing some web programming quickly. Commonly used functions are not buried in a bunch of uncommonly used functions.

66 of 69 people found the following review helpful:

4.0 out of 5 stars Excellent "Let's Do It" Tutorial, December 13, 2004

By 

Robert L. Cochran (Greenbelt, MD USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: Beginning PHP 5 and MySQL: From Novice to Professional (Paperback)

I reach for this book when I want to get up to speed on something about PHP 5 quickly. With it, I can start coding and seeing results right away. The book covers a range of topics, the practicality of which can be best appreciated when you are faced with a real life project. For example, pp. 660-665 in Chapter 27, "Practical Database Queries", covers creating paged output (that is, spreading query results across several web pages) and listing page numbers which was just the thing I wanted to learn last night. My wife's database needs that sort of output. You can download Gilmore's example code and quickly start using it and then applying the lessons learned to build your own code.

This book is geared to people who want to get their hands on real code, wring the juice from it, make mistakes with it, learn all they can from it, and then tap out fresh code that does the same things with a little more oomph. Such people do not like long, dreary tracts of reading before being able participate in the elusive action. It is a good learning format because the only useful way to learn programming is to dive right in and do it. The book is a blend of brief discussion and quick code snippets with the expected results shown right away. This is a very good way to learn programming.

The section on SOAP, starting on page 450, makes me realize I had better experiment with this interesting technology. I'd certainly like to be able to find the temperature for a given postal code -- and other things of greater interest. Chapters 12, "PHP Authentication", 14, "Networking With PHP", and 15, "PHP and LDAP", look into core internet services that every programmer should know how to exploit, but too often don't. For example I've learned how to authenticate a user with LDAP.

The author, W. Jason Gilmore, is cheerful and most helpful in his responses to reader inquiries. He responded quickly to my questions and I am impressed with his ability to courteously point me in the right direction.

Be sure to download Gilmore's example code. There are 30 chapters worth of programming stuffed into that zip file.

The book has a few rough edges. The most obvious is that some sentences are a little wordy. That's all right, you can move on to the next paragraphs, and will soon be trying out a new example. I wish Jason had discussed MySQL 4.1 and the mysqli interface, especially since there are other books around that cover MySQL 4.0.x. Perhaps if he had added another chapter to cover that? We can always look forward to a second edition.

This book should be near every serious programmer's desk. You, dear reader, will reach for it a surprising amount of the time.