Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning from Novice to Professional) (Paperback)

~ W. Jason Gilmore (Author)
Key Phrases: new mysgli, resource result set, mysgli extension, Jason Gilmore, Procedural Syntax, New Jersey (more...)

Editorial Reviews

Product Description

Book Description

• Essentially three books in one, provides thorough introductions to the PHP language, MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites.
• Provides over 500 code examples, including real-world tasks such as providing an auto-login feature, sending HTML-formatted email, testing password guessability, and uploading files via a Web interface.
• Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.

From the Back Cover

Interested in becoming a master of the PHP language and MySQL database but don't know where to begin? This bestselling book ranks among the most thorough and practical guides in print, covering all of the key concepts and features, and showing you how to effectively integrate PHP and MySQL to build powerful websites.

The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.

Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5-specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.

What You Will Learn from This Book

• Install and configure Apache, PHP and MySQL on both Windows and Linux
• Accept and process information submitted via HTML forms
• Authenticate users and track user preferences and data using PHP's session-handling capabilities
• Process Web-based file uploads using the HTTP_Upload PEAR package
• Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML
• Use both command-line and graphical MySQL clients to effectively manage your data
• Secure the MySQL server, creating roles and restricting access even at very granular levels
• Effectively integrate PHP and MySQL to create dynamic, data-driven web applications

Who This Book Is For

This book is for the budding web developer searching for a powerful and low-cost solution to building flexible, scalable websites.

About the Author

W. Jason Gilmore has been involved in PHP and MySQL Web application development for six years, and has developed hundreds of applications using the LAMP (Linux Apache MySQL PHP) platform. His writings on open source technologies have been featured within many of the computing industry’s leading publications, including Linux Magazine, O'Reillynet, Devshed, and Zend.com, and have been adapted for educational initiatives led by numerous organizations, including the Ford Foundation and the United Nations. Jason is Developer.com’s monthly PHP columnist, and a regular contributor to Linux Magazine. He spends his days (and many nights) running Apress' Open Source program, and loves every moment of it. Jason graduated from The Ohio State University in 2000 with a bachelor's degree in computer science.

Product Details

• Paperback: 952 pages
• Publisher: Apress; 2 edition (January 23, 2006)
• Language: English
• ISBN-10: 1590595521
• ISBN-13: 978-1590595527
• Product Dimensions: 9.2 x 6.9 x 1.9 inches
• Shipping Weight: 3.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (108 customer reviews)
• Amazon.com Sales Rank: #290,127 in Books (See Bestsellers in Books)

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

  #5 in	Books > Computers & Internet > Hardware > PC Buyers' Guides
  #44 in	Books > Computers & Internet > Databases > Beginning & Introductory
  #65 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.

75 of 78 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

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.