[LWN Logo]
[LWN.net]
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.