Web Database Applications with PHP and MySQL and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
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, or download a FREE Kindle Reading App.

Web Database Applications with PHP and MySQL [Paperback]

Hugh E. Williams , David Lane
4.3 out of 5 stars  See all reviews (37 customer reviews)
List Price: CDN$ 52.99
Price: CDN$ 32.92 & FREE Shipping. Details
You Save: CDN$ 20.07 (38%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Usually ships within 2 to 5 weeks.
Ships from and sold by Amazon.ca. Gift-wrap available.

Formats

Amazon Price New from Used from
Kindle Edition CDN $25.75  
Paperback CDN $32.92  
Join Amazon Student in Canada


Book Description

May 23 2004 0596005431 978-0596005436 2

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templatesto give your dynamic web pages a standard look.But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:

  • Installation and configuration of Apache, MySQL, and PHP on Unix®, Windows®, and Mac OS® X systems
  • Introductions to PHP, SQL, and MySQL administration
  • Session management, including the use of a custom database for improved efficiency
  • User input validation, security, and authentication
  • The PEAR repository, plus details on the use of PEAR DB and Template classes
  • Production of PDF reports

Special Offers and Product Promotions

  • Join Amazon Student in Canada


Customers Who Bought This Item Also Bought


Product Details


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 --This text refers to an out of print or unavailable edition of this title.

Review

"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 --This text refers to an out of print or unavailable edition of this title.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

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
Format:Paperback
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?
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
Format:Paperback
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?
1 of 1 people found the following review helpful
2.0 out of 5 stars Read my review Feb. 25 2003
Format:Paperback
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?
5.0 out of 5 stars Comprehensive review and examples July 6 2004
Format:Paperback
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?
Format:Paperback
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?
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
Only search this product's reviews

Look for similar items by category


Feedback