Beginning PHP and MySQL: From Novice to Professional, Third Edition (Paperback)

~ W. Jason Gilmore (Author)
Key Phrases: web services, package manager, subnet mask, Jason Gilmore, Off Scope, New York (more...)

Editorial Reviews

Product Description

Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQLs most significant release to date, readers learn how to take advantage of the latest features of both technologies to build powerful, manageable, and stable web applications.

Essentially three books in one, readers not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's 7 years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide.

What you'll learn

• The PHP language
• How to back your web site with MySQL
• Templating so that you can apply a consistent design across all pages on your site
• How to authenticate your web site users
• How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site

Who is this book for?

This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.

About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!

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 2008 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, (http://www.wjgilmore.com/) Jason provides an array of consulting and web development services to small businesses around the country. Contact Jason at wjATwjgilmore.com if you’re looking for competent, timely, and cost–effective services.

Product Details

• Paperback: 1080 pages
• Publisher: Apress; 3 edition (March 24, 2008)
• Language: English
• ISBN-10: 1590598628
• ISBN-13: 978-1590598627
• Product Dimensions: 9.2 x 7 x 2.1 inches
• Shipping Weight: 3.8 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (107 customer reviews)
• Amazon.com Sales Rank: #26,818 in Books (See Bestsellers in Books)

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

  #2 in	Books > Computers & Internet > Databases > Beginning & Introductory
  #8 in	Books > Computers & Internet > Web Development > Programming > PHP
  #9 in	Books > Computers & Internet > Databases > Specific Databases > MySQL & mSQL

Customer Reviews

Most Helpful Customer Reviews

151 of 153 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 (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-)

67 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)

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.

74 of 77 people found the following review helpful:

3.0 out of 5 stars Frustrating, December 20, 2006

By	David Diez (Los Angeles, CA) - See all my reviews

This review is from: Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (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.