Recent SCO/Linux News

From: Kathryn Barrett <kathrynb@oreilly.com>
Subject: "Web Database Applications with PHP & MySQL" Released by O'Reilly
Date: Thu, 18 Apr 2002 23:24:22 GMT

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.
 

Index

Buy Take Control of Easy Backups in Leopard

Buy Take Control of Fonts in Leopard

Buy Take Control of Screen Sharing in Leopard

Buy Take Control of Permissions in Leopard

Jump to Comments

Many of the products and books I review are things I purchased for my own use. Some were given to me specifically for the purpose of reviewing them. I resell or can earn commissions from the sale of some of these items. Links within these pages may be affiliate links that pay me for referring you to them. That's mostly insignificant amounts of money; whenever it is not I have made my relationship plain. I also may own stock in companies mentioned here. If you have any question, please do feel free to contact me.

Specific links that take you to pages that allow you to purchase the item I reviewed are very likely to pay me a commission. Many of the books I review were given to me by the publishers specifically for the purpose of writing a review. These gifts and referral fees do not affect my opinions; I often give bad reviews anyway.

We use Google third-party advertising companies to serve ads when you visit our website. These companies may use information (not including your name, address, email address, or telephone number) about your visits to this and other websites in order to provide advertisements about goods and services of interest to you. If you would like more information about this practice and to know your choices about not having this information used by these companies, click here.