MySQL/PHP Database Applications, 2nd Edition [Paperback]

Brad Bulger (Author), Jay Greenspan (Author), David Wall (Author)

Book Description

ISBN-10: 0764549634 | ISBN-13: 978-0764549632 | Publication Date: October 1, 2003 | Edition: 2

• Demonstrates Web application development by presenting ten real, ready-to-use examples
• Samples start with a simple guess book and end with a fully-functional e-commerce site with a shopping cart
• New features include both MySQL 4.1 and PHP 4.2
• Latest edition contains new applications including log analysis and project tracking
• CD-ROM includes all the code and examples applications from the book in addition to MySQL, PHP, Apache, PHP classes, libraries, utilities, and other tools

Editorial Reviews

Amazon.com Review

How could the combination of PHP and MySQL--which is feature-rich, highly reliable combination, capable of dealing with large traffic volumes, and absolutely free of charge in most cases--be any better? In MySQL/PHP Database Applications, Jay Greenspan and Brad Bulger explain how to work with the capable pair, primarily for applications you might use on a Web site. If you take the time to study the advice and work through your own tests of the concepts presented, it's pretty much certain that you'll walk away with the knowledge you need to do serious development work with the PHP scripting language and the MySQL database server.

Rather than make up trivial programs just to illustrate aspects of the MySQL/PHP environment, this book features code snippets, each half a page or so in length, that illustrate the behavior of key code structures. For example, in explaining conditional statements in PHP, the book gives you a no-frills IF statement with real values in place. It's not always obvious how the code structures will behave in practice, but the book does a consistently good job of commenting intelligently on the place of each aspect of the language in a well-designed application. The latter half of the book attacks specific problems--a chat system, a guest book, and so on--and walks through the setup of MySQL and each important PHP function for each. --David Wall

Topics covered: The PHP server-side scripting language and the MySQL database server, explained for people who have neither a lot of database administration background nor programming experience. Matters of creating and querying databases, and of performing simple and advanced operations with PHP scripting, are covered adroitly. --This text refers to an out of print or unavailable edition of this title.

From the Back Cover

Learn what it takes to get data-driven Web sites up and running using PHP 5 and MySQL

The popularity of using MySQL and PHP to create organized and efficient Web sites is growing at a steady pace. MySQL has proven itself to be fast, robust, and easy to use. It works well with PHP, and it’s perfect for Web applications for simple to robust sites. For many developers, PHP is the next obvious step from HTML due to the fact that it was written specifically for use on the Web, it’s cross-platform, and it’s relatively easy to understand and write. MySQL/PHP Database Applications, Second Edition, demonstrates Web-application development using MySQL and PHP by presenting multiple practical, ready-to-use examples ranging from a simple guestbook to a fully functional e-commerce site with a shopping cart. Other applications include a catalog, a content manager, a threaded discussion, and a problem-tracking system. You’ll learn the essentials of working with MySQL and PHP so you can start building and customizing database applications for the Web in no time!

This edition offers updated coverage of MySQL 4.0 and an extensive look ahead into PHP 5. The example code was rewritten to run against the new PHP engine, and this edition explores its new object-oriented features, as well as improvements in XML processing, remote file access, and other areas. Containing advice on how to easily tweak and customize a site, this book:

• Provides a concise introduction to working with MySQL and PHP
• Includes complete applications–project management system and message board
• Delivers ready-to-use code for error handling, user and session management, and templating
• Helps create code with SOAP services

The CD-ROM contains the example code and applications from the book, as well as MySQL, PHP, and Apache.

See all Editorial Reviews

Product Details

• Paperback: 818 pages
• Publisher: Wiley; 2 edition (October 1, 2003)
• Language: English
• ISBN-10: 0764549634
• ISBN-13: 978-0764549632
• Product Dimensions: 9.2 x 7.4 x 1.7 inches
• Shipping Weight: 2.9 pounds
• Average Customer Review: 3.1 out of 5 stars  See all reviews (41 customer reviews)
• Amazon Best Sellers Rank: #838,148 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

16 of 16 people found the following review helpful:

4.0 out of 5 stars Quality Content, Sloppy Editing, March 3, 2001

By 

Steve Johnson (Grand Rapids, MI USA) - See all my reviews

This review is from: MySQL/PHP Database Applications (Paperback)

While the examples are great and the topic coverage is excellent, there are 2 or more typos on almost every page. It looks like they were in such a hurry to get the thing out the door that quality control was not a consideration.

The typos aren't just in the text; they are quite common in the examples. For instance, when showing an example of a "contact" table, the text refers to contacts while the example shows contracts. There are missing "_"'s in the data names and PHP and SQL syntax mistakes throughout.

Given that, if you are willing to debug the text and the examples, you'll find 99% of what you will need to know to be able to create a database driven website with Apache/PHP/MySQL.

If you need the information now, buy it. If you can, I'd wait for the second edition; perhaps they can reduce the mistakes.

sj

17 of 19 people found the following review helpful:

2.0 out of 5 stars Too Much Fluff, February 23, 2002

By 

A. C. Johnson (Oakland, CA USA) - See all my reviews
(REAL NAME)   

Amazon Verified Purchase

This review is from: MySQL/PHP Database Applications (Paperback)

I first learned PHP from Luke Welling and Laura Thomson's excellent "PHP and MySQL Web Development," and bought 'MySQL/PHP Database Applications' to provide an alternative perspective on solving problems. Unfortunately, this book doesn't offer enough content to warrant its high price.
A full 58 pages is devoted to a PHP function reference which is a bit of a joke because PHP has one of the better online function references available. Code examples are printed with very large font again taking up more space than is necessary.
Most important, though, some of these examples are a little bit suspect.
They present a Catalog application written using Object Oriented Programming (OOP). This would have been valuable except that the classes they create are so specific that they couldn't be re-used -- basically negating the value of OOP to begin with.
They do provide a couple of examples of good and bad relational database schema, but that isn't really worth the cost of this book.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Great for a quick introduction to PHP and MySQL, March 22, 2001

By A Customer

This review is from: MySQL/PHP Database Applications (Paperback)

Overall, I found this book to serve as an excellent introduction to development using PHP and MySQL. The authors have a refreshing, no-nonsense approach to presenting information on MySQL and PHP quickly and in an easily understandable manner. However, on the flip side, this book is definately not for the beginning programmer. It is clear that the authors assume at least some familliarity with procedural programming languages, especially when presenting their examples. In the end, I heartily recommend this book to its target audience- programmers with some experience looking to learn how to use PHP with MySQL.