Auto boutiques-francophones Simple and secure cloud storage giftguide Countdown to Black Friday in Home & Kitchen Kindle Black Friday Deals Week in Music SGG Tools
Start reading Web Database Applications with PHP and MySQL on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for

Web Database Applications with PHP and MySQL [Kindle Edition]

David Lane , Hugh E. Williams
4.3 out of 5 stars  See all reviews (37 customer reviews)

Digital List Price: CDN$ 44.99 What's this?
Print List Price: CDN$ 66.26
Kindle Price: CDN$ 35.99 includes free international wireless delivery via Amazon Whispernet
You Save: CDN$ 30.27 (46%)

Free Kindle Reading App Anybody can read Kindle books even without a Kindle device with the FREE Kindle app for smartphones, tablets, and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition CDN $35.99  
Paperback CDN $58.37  

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel, please use your heading shortcut key to navigate to the next or previous heading.

Product Description

From Amazon

Web Database Applications shows Web developers how to build rich Web database applications using two leading open-source technologies, PHP and MySQL. The authors also assume use of the Apache Web server, which is by far the most common PHP scenario. Both PHP and MySQL are introduced from scratch, although this is a fast-paced book best suited to at least intermediate developers.

After a brief discussion of Web database applications, the authors offer a rapid tour of PHP essentials, including loops, expressions, functions and common mistakes. Next comes a quick-start guide to MySQL, focusing mainly on the SQL language itself. The following chapters tackle connecting to MySQL and other databases, implementing user-driven queries and enabling writing as well as reading data. There is a useful chapter on data validation, both on the client and the server and excellent coverage of another crucial subject: security and authentication. This looks at the fundamentals of HTTP authentication and examines security features in both Apache and PHP, identifying weaknesses and explaining pros and cons. The closing chapters form a detailed case study, an online wine store, with complete code available for download. It embraces user management, a shopping cart, searching, ordering and delivery, covering many key topics in the process. At the back of the book are appendices on a range of issues, including installation, Web protocols, database modelling and session management.

Web Database Applications is tightly-focused, packing in lots of solid technical information without wasting words. It does not pretend to cover all the potential uses of PHP, and the screen shots will not win prizes for design, but it's a great handbook for building robust, secure database applications with these popular technologies. --Tim Anderson


"As symbolized by the duck-billed platypus on the cover it is a book that will help you to survive in a rapidly changing world. Submerge yourself in proven technology and emerge unscathed once the dots have fallen out by the wayside. Recommended for its excellent examples which will save you thousands in case you need to develop a similar application." Information Security Bulletin, July 2002 "The book manages to deliver on two levels at once - the concepts, planning and design process as well as implementation. It's also surprisingly well written, and manages not to be too smug or patronizing." - Nick Veitch, LinuxFormat, October 2002

Product Details

  • Format: Kindle Edition
  • File Size: 2454 KB
  • Print Length: 818 pages
  • Page Numbers Source ISBN: 0596005431
  • Simultaneous Device Usage: Unlimited
  • Publisher: O'Reilly Media; 2 edition (May 13 2004)
  • Sold by: Amazon Digital Services, Inc.
  • Language: English
  • ASIN: B0043D2E0Y
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Not Enabled
  • Average Customer Review: 4.3 out of 5 stars  See all reviews (37 customer reviews)
  • Amazon Bestsellers Rank: #311,256 Paid in Kindle Store (See Top 100 Paid in Kindle Store)

Customer Reviews

Most helpful customer reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars Very useful and practical guide March 19 2003
Web Database Applications by H.E. Williams and D. Lane is a truly wonderful book if you are looking to learn how to get an online database application up and running fast. The book eases you into PHP with a decent length chapter on the basic syntax of the language, followed by an introduction of MySQL.
After that, each chapter will teach you new techniques which are instantly applicable to a real-world online database system. Among others this book will teach you how to: write scripts that interact with MySQL, deal with security issues, handle sessions, handle shopping carts and lots lots more.
The book was written before the introduction of PHP 4.2, so certain 4.2 (and up) specific issues are not covered. However, most of the examples in the book have been re-written for use with 4.2 and can be downloaded freely. On top of this the authors supply a level of support that is all but unheard of. Every question that I asked was answered within 1 day if not within the same day.
All in all this book is at the top of it's league, I can highly recommend it!
Was this review helpful to you?
Report abuse
1 of 1 people found the following review helpful
3.0 out of 5 stars Very good in principle but falls down on errata Sept. 26 2003
By A Customer
Like others I've found this text an absolute corker for getting started with on-line databases.
However, after struggling with one of the examples for several hours I was disappointed to finally realise that the code was woefully short.
Just in case, I thought, I'll check the book's web site for errata, and found several pages of it! Some of which contains errors, like wrong page number!!!!!
I don't know about you but I find it hard to learn new stuff when the examples don't work.
Well I finally got the code to work and I've submitted it to the publishers. But, whilst I'm quite an experienced developer, I've only been looking at PHP, MySQl & Java for a couple of weeks and presumably it takes longer to write a book.
So how come the readers are fixing the authors code?
Maybe I should write a book ...
Was going to give 4* but because of the errors went down to 3.
Was this review helpful to you?
Report abuse
1 of 1 people found the following review helpful
2.0 out of 5 stars Read my review Feb. 25 2003
I am a well versed programmer who has read many programming books by many different authors. If you are a person who learns by visual do not get this book. Here are some of the pitfalls of this book.
1. They throw globs of code at you and do not explain what any of it is doing. You have to figure it out for yourself.
2. This book is not a step by step book for beginners, you will get lost.
3. The name and the reviews fooled me. This book is not for the beginner who would like to advance into the subject of creating Dynamic web sites.
If anyone knows of a good book on the subject of creating dynamic web sites using php, and that is very visual and in a step by step format please let me know.
Was this review helpful to you?
Report abuse
5.0 out of 5 stars Comprehensive review and examples July 6 2004
Serving up dynamic content with scripting applications is all the rage now in the website development world. These scripting applications can provide customized information pages, shopping carts and content-management systems, and user-influenced web experiences. While "old-fashioned" static sites and pages still have their place, dynamic content sites are becoming more and more prevalent, primarily due to their obvious advantages, but also to their modest costs. The reason for these low costs is because the software applications are generally free, thanks to the open-source movement.
Apache is an open-source web server application widely used. The most prevalent and preferred scripting application is PHP; MySQL is the predominant database management program. These three drive the great increase in dynamic content web development. While essentially free, their installation, configuration, and use requires some technical and programming skills and knowledge, but small and medium-size database-driven web sites can be managed by those not expert in programming or database management.
While there is a lot of material available on the Internet about this software and database-driven sites, and a number of books available on these topics, none is as thorough and complete as "Web Database Applications with PHP and MySQL", by Hugh E. Williams and David Lane. This volume is in its 2nd edition and is a 2004 publication of O'Reilly Media Inc. The book presents an overview of dynamic web sites using open-source software and relates the principles behind generating dynamic content with database applications. The focus is on PHP, the scripting language, and MySQL, the database management software.
As befits a couple of university-associated authors, the book reads much like a college textbook.
Read more ›
Was this review helpful to you?
Report abuse
As the title indicates, this book is all about building websites powered by database applications. The book uses PHP and MySQL for a scripting language and a database technology respectively. Familiarity with programming and computers is assumed but other than that, not much else is assumed. The authors do an excellent job of explaining some of the fundamental concepts underlying database driven websites. All this is done in simple terms without too much jargon. To top it all off, a tutorial style approach is taken to illustrate how all these concepts come together. The tutorial is on building an online retail site that sells wines. The sample code used in the book can be downloaded from the publisher's website.
PHP is a powerful language that is open source and that can be used in lieu of Java and .NET technologies for many web applications that aren't too complex. For most small business owners, this should suffice. I am not too sure about using it in large corporations. This is one of the most popular open source technology along with Linux and MySQL.
MySQL is an open source database that can be used instead of SQL Server, Access, or Oracle. Once again, when the database application gets complex, I am not confident of its ability to handle the complexity. This is also excellent for small businesses but not large corporations.
There are about 13 chapters and 5 appendices spanning 550 pages starting with an introduction to database applications and the web, continuing with an intro to PHP and MySQL, covering the main concepts behind web technologies and ending with the sample wine store application. The main concepts discussed are querying databases, writing to databases, validations on the server and client, session management, user authentication and security.
Read more ›
Was this review helpful to you?
Report abuse
Want to see more reviews on this item?
Most recent customer reviews
5.0 out of 5 stars Detail study guide for PHP web application development
This book introduces all the technology detail about PHP web application development even include a simple introduction of credit card processing. Read more
Published on Jan. 15 2011 by Jianwei Yang
4.0 out of 5 stars Very useful
Requires some basic background knowledge (as stated in its introduction), but covers all the bases, with good examples on how to construct and use a database for a small on-line... Read more
Published on Jan. 7 2010 by Corrie
5.0 out of 5 stars Great start on PHP/MySQL for programmers
When I got this book, I already had experience programming in Perl, but PHP was entirely new to me. I also had database/SQL knowledge, but had never touched MySQL. Read more
Published on June 9 2004 by K.M.
5.0 out of 5 stars Wonderful book!
I've done several PHP and MySQL development jobs, and there
are problems which constantly hunt me...until I find this book. Read more
Published on Oct. 2 2003 by doudou1229
5.0 out of 5 stars the best book on the subject
If you want to learn how to build a large scale php web app from start to finish this is the best book you can buy. Read more
Published on Sept. 23 2003 by Amber Bobnar
5.0 out of 5 stars A serious book
This book is the only technie guide that discusses the theory behind building a web database application. It's written in a concise, information packed style. Read more
Published on March 16 2003
4.0 out of 5 stars PHP and MySQL straightforward and made clear
This book, as most O'Reilly books I own, contains a wealth of information that has taken me from being a novice to being able to construct my own dynamic website. Read more
Published on March 5 2003 by Don L.
2.0 out of 5 stars Not Worth It
My background - a little bit of perl, BASIC language, html.
This book in the first 2 or 3 chapters walks you through as to 'what is PHP? Read more
Published on Feb. 1 2003
Search Customer Reviews

Look for similar items by category