From: Kathryn Barrett <kathrynb@oreilly.com> To: lwn@lwn.net Subject: "Web Database Applications with PHP & MySQL" Released by O'Reilly Date: Thu, 18 Apr 2002 17:50:23 -0700 (PDT) For Immediate Release April 18, 2002 For more information, a review copy, cover art, or an interview with the authors, contact: Kathryn Barrett (707) 827-7094 or kathrynb@oreilly.com PHP AND MYSQL: THE BUILDING BLOCKS OF SUCCESSFUL WEB DATABASE APPLICATIONS Sebastopol, CA--When we think of database applications today, we are likely to think of some of the more popular sites on the Web such as eBay, Amazon, or CNN.com. Database applications have been around for more than thirty years, many having been deployed using network technology long before the Web existed. Hugh E. Williams and David Lane, authors of "Web Database Applications with PHP & MySQL" (O'Reilly, US $44.95) recall the first point-of-service systems used by bank tellers. Terminals were installed in bank branches and access to the bank's central database application was provided through a wide area network. These early applications were limited to organizations that could afford the specialized terminal equipment and, in some cases, to build and own the network infrastructure. Today the Web provides cheap, ubiquitous networking and access to thousands of web database applications for anyone armed with browser software and an ordinary computer. And every e-commerce web site is built upon a well-designed database and a suite of applications that allow a web front end to interact with it. "Web Database Applications with PHP & MySQL" shows developers how to combine two of the most important building blocks of such sites to create compelling web sites of their own. Both open source technologies, MySQL is a database query language and PHP a server-side, cross-platform, HTML-embedded scripting language used to create dynamic web content. "This is the only book in the marketplace that has extensive coverage of issues in writing data to web databases, the fundamental problems of integrating stateful applications with the Web, and how to use PHP sessions to develop a web database application" says coauthor Lane. "It is also up-to-date and covers PHP 4 for the Web. No other popular book in the marketplace does that." Williams adds, "Almost all books in this area are shallow in that they touch on how to solve small problems and not on why the problems exist. We saw a market for a book that not only covered the practice of developing web database applications, but also the principles. We also observed that it was hard to write medium-size applications using small-scale examples, and so we decided there was a market for a book that was oriented around a complete case study of a real world application." To provide developers with a hands-on example of a web database application, the book introduces Hugh and Dave's Online Wines, a complete but fictional online retail site that allows users to browse, search a database, add items to a shopping cart, manage their membership, and purchase wines. Using this site as an example, developers learn how to implement searching and browsing, store user data, validate user input, manage transactions, and maintain security. "Web Database Applications with PHP & MySQL" provides readers with both theoretical and practical information on creating web database applications. The authors include many chapter-length tutorials on the PHP and MySQL languages, as well as background material on Internet and web protocols, modeling and designing relational databases, session management, and installing open source server and database software. The book focuses on understanding and developing application logic that brings databases and the Web together. "Most web developers know that a web site and a web application are different, and our book explains why a web database application and a traditional database application are different," says Lane. "This allows the reader to think critically about the architecture of a web database application." If you are a web developer wanting to build a small- to medium-scale web database application that will run on modest hardware and process more than a million hits a day, "Web Database Applications with PHP & MySQL" is a complete guide that will show you how. Additional resources: "Web Database Applications with PHP & MySQL" is also available on Safari Books Online, see: http://safari.oreilly.com/ An article by coauthor Hugh E. Williams, "Tips for Building Web Database Applications with PHP and MySQL," can be found at: http://www.onlamp.com/pub/a/onlamp/2002/04/04/webdb.html An excerpt from Chapter 8, "Sessions," is available free online at: http://www.oreilly.com/catalog/webdbapps/chapter/ch08.html For more information about the book, including Table of Contents, index, author bios, and samples, see: http://www.oreilly.com/catalog/webdbapps/ For a cover graphic in jpeg format, go to: ftp://ftp.ora.com/pub/graphics/book_covers/hi-res/0596000413.jpg Web Database Applications with PHP & MySQL By Hugh E. Williams and David Lane ISBN 0-596-00041-3, 563 pages, $44.95 (US), $69.95 (CAN) order@oreilly.com 1-800-998-9938 1-707-827-7000 http://www.oreilly.com About O'Reilly O'Reilly & Associates is the premier information source for leading-edge computer technologies. The company's books, conferences, and web sites bring to light the knowledge of technology innovators. O'Reilly books, known for the animals on their covers, occupy a treasured place on the shelves of the developers building the next generation of software. O'Reilly conferences and summits bring alpha geeks and forward-thinking business leaders together to shape the revolutionary ideas that spark new industries. From the Internet to XML, open source, .NET, Java, and web services, O'Reilly puts technologies on the map. For more information: http://www.oreilly.com # # # O'Reilly is a registered trademark of O'Reilly & Associates, Inc. All other trademarks are property of their respective owners.