- Paperback: 680 pages
- Publisher: O'Reilly Media; 2nd edition (May 16, 2004)
- Language: English
- ISBN-10: 0596005431
- ISBN-13: 978-0596005436
- Product Dimensions: 7 x 1.7 x 9.2 inches
- Shipping Weight: 2.6 pounds (View shipping rates and policies)
- Average Customer Review: 70 customer reviews
- Amazon Best Sellers Rank: #1,290,116 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Web Database Applications with PHP & MySQL, 2nd Edition 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
See the Best Books of 2017
Looking for something great to read? Browse our editors' picks for the best books of the year in fiction, nonfiction, mysteries, children's books, and much more.
Frequently bought together
Customers who bought this item also bought
PHP and MySQL go hand in hand; the former has been carefully adapted, through the efforts of the open-source community, to the latter. For situations that require dynamic content but don't merit the complexity and development time of Java or .NET enterprise applications, the PHP language and the MySQL database server fit the bill perfectly. That's the point Hugh Williams and David Lane make in Web Database Applications with PHP & MySQL, which combines language tutorials with application design advice to yield a comprehensive picture of its subjects at a reasonable price. Williams and Lane--both Australian academics who use an online wine store in many of their examples--deserve tremendous kudos for their way of presenting recommended coding strategies. Though the code listings themselves aren't remarkably well commented, the authors do a commendable job of explaining in prose what the code is up to.
Case in point: The ever-essential task of using PHP to open a connection to a MySQL database, submit a query to that database, receive a response, and format the returned rows, if any. The book addresses this problem with a straight code listing, followed by text that explains what's happening in five numbered steps. Similar care goes to the other popular applications of the PHP/MySQL duo: session management, shopping carts, and authentication of users. --David Wall
Topics covered: How to use the PHP server-side scripting language and the MySQL database engine to underlie dynamic Web sites (those that rely on database queries) and full-on Web applications, such as those that require session management and maintenance of user rosters. Tutorials in both subjects begin with the basics and proceed through moderately complicated stuff, though there's no absolutely comprehensive reference here. --This text refers to an out of print or unavailable edition of this title.
"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.
Author interviews, book reviews, editors picks, and more. Read it now
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The code page where you download examples hasn't been updated since 2005.
Another major problem and this one can't be blamed on time is that the code examples and the wine store app itself have a few programming errors. I was able to spot and fix these but it goes to show you that whoever wrote this thing didn't even bother to run and check to see if their code actually works. When you're trying to learn a programming language the last thing you want to worry about is the author's own mistakes. You could literally spend hours wondering what YOU did wrong when in reality it's THEIR fault.
I can't comment on Chapter 5 onwards because this book is now mostly useless to me, and to anyone who wants to learn PHP and mySQL in a PHP 5 environment (today's world). Unfortunately I don't have any recommendation as a substitute, though I would suggest checking what version the book is for before buying.
First, learn very basic PHP from [...]
Make a few sample pages for yourself using as many techniques on the site as you can. After that, make your way to the book. Up until page 134, it's just dry syntax. You can learn dry syntax much faster from the website I listed. You'll be able to skim across the first 134 pages with your knowledge, and since it will look somewhat familiar, you won't get bored out of your mind.
When you start actually getting in to mysql implementation, you can start reading the page over.
I highly suggest that you read along and make your own project that you will find interesting instead of the project provided. I'm using this book to make an inventory application for a pretend game store website, and it's keeping me much more interested than when I was making the winestore example.
Some of the functions don't work, such as the selectDistinct, but I didn't find that too annoying. The book uses some outdated techniques such as ereg for regular expressions, but that's because the book itself is slightly outdated.
Don't try to read the book cover to cover and then try to go apply what you learned. You'll just end up having to read the book again. Digest the book in chunks and actually CREATE something with it!
One final word: Do NOT attempt to install Apache, PHP, and MySQL using the book. I lost so many hours that way. Just look up some forum posts on how to do it manually using the zip files as opposed to the MSI installer.