Product Description
PHP MySQL Website Programming: Problem – Design – Solution shows the development process for a website using a specific set of technologies: the Apache web server, the MySQL database system, and the PHP scripting language. It gives you a completely hands-on experience and guides you through the construction of a complete application-driven site from design to deployment.
Each chapter in the book is broken into three parts:
- Problem: The authors analyze each task and identify areas that may be particularly hard to implement.
- Design: Once the problems have been identified, a proposal is sketched out for solving them.
- Solution: The code is developed and deployed to accomplish the task at hand.
Throughout the book, good object-oriented PHP coding methods are used where appropriate. The site you construct features a modular design, so the individual chapters are generally focused on designing and building a specific piece of the site’s functionality.
This invaluable tutorial provides a lot of insight into the ways you can implement web applications with PHP and MySQL in real-world situations.
PHP MySQL Bible Book | Tim Converse Joyce Park Clark Mo | US $53.68 End Date: Thursday May-24-2012 11:55:53 PDT Buy It Now for only: US $53.68 Buy it now | Add to watch list |
This is the most rock solid computer science programming text that i have read in the last decade.Period.No one should miss out on this buy.
Amazon User Rating: 5 / 5
(This review is of the Wrox Press 2002 edition)
This book gives you a thorough course in building a PHP-MySQL website, working up a complete system in stages. The book contains lots of useful code and techniques that can be used in your own websites. As a previous reviewer said, it is not for complete beginners in PHP/MySQL, but in combination with a good fast intro to these topics (I used SAMS “Teach Yourself PHP, MySQL and Apache in 24 Hours”), I reckon this book should be all you need to get your cool interactive database-driven site out onto the web. And when I contacted the authors to find the download code (which is available from Apress now that Wrox no longer publish it), they were extremely helpful. So go on – the software cost you nothing after all: why not splash out a few pennies on this excellent book?
Amazon User Rating: 5 / 5
Chris Lea et al., PHP MySQL Website Programming: Problem – Design – Solution (Apress, 2002)
I’ve been bulking up on PHP/MySQL books recently as I transition my household machines to Linux and prepare to implement a webserver to hold my book database and the painfully simple font-end I’ve designed to work with it. The more I read, the more convinced I am that PHP isn’t exactly what I need (though since that’s an issue of preference, I won’t be addressing it in this review), but MySQL has always seemed the way to go for Linux databases, and so I’m still devouring these things. I have yet to come across one that really gets into intricate databases on the web (the book database is currently thirty tables without factoring in logins, permissions, and the like), but this is the most complex of the lot so far. Unfortunately, it sticks with MyISAM, and indicates that’s the usual convention when dealing with webhosts. This does answer a few questions I’ve had for years about why website updates sometimes seem inconsistent, anyway (MyISAM, at least at the time this book was written, didn’t support foreign keys, leaving the programmers to make sure relations were enforced in code; the possible problems should be obvious). Still, this book covered a lot of ground I haven’t come across in other PHP/MySQL web design books before, and that was easily worth the price of admission.
Lea and his cohorts take the reader through the construction of a complete website, with a number of features one would expect to see (discussion fora, polls, basic ecommerce, etc.). As a side note, the website used as an example in the book is still out there on the web as of this writing, though I did get a number of unspecified database errors while wandering through it (and it hasn’t been updated in a long, long time). In any case, the layout of the book, and much of the code used in it, is simple and straightforward. While that makes a great deal of sense from a teaching standpoint, it does tend to exacerbate some of the inherent problems with using MyISAM as a database scheme for web development, and the authors seem to dismiss some of those problems (such as the lack of foreign keys I mentioned; yes, it’s certainly good programming practice for the programmers to check for errors before the data gets passed, but having another layer of built-in error checking isn’t ever extraneous) rather than discussing them rationally. More importantly, however, the book discusses building a home-rolled content management system. With the recent rise (and explosion in popularity) of out-of-the-box CMSes like Joomla! and Drupal, this might seem like overkill, but let’s face it: how many people out there building websites are actually going to need even 20% of the features you find in a CMS written for the purpose of trying to please everyone all the time? Lea et al. offer a much lighter-weight option that even the novice web-building geek can easily extend and customize.
All in all, a lot here of worth. I actually picked this one up at the store instead of getting it out of the library, and while I’m not sure how much of the actual code I’m going to use, some of the design concepts made it worth the price of admission by themselves; everything else is icing on the cake. *** ½
Amazon User Rating: 4 / 5
This book is simply the best among the sea of books available today on PHP and MySQL. Anyone wanting to learn how to create a site using the three popular technologies – PHP, Apache and MySQL should buy this book.
What i found most interesting was the LEARNING CURVE – too fast, too ruddy fast that your client will gape at the speed at which you put together his site.
Amazon User Rating: 5 / 5
The book is enjoyable to read; it focuses on the step-by-step delivery of a very dynamic website,starting with the basics of designing the file layout and how the files will work together. It then goes into more detail on delivering each feature, provides enough general ideas to help most PHP enthusiasts and budding developers understand the basics and advantages of OOP programming (although there are a few functions thrown in to ease in those not conversant with OOP)…
Amazon User Rating: 5 / 5