- Shopping Bag ( 0 items )
From Barnes & NobleThe Barnes & Noble Review
Every once in awhile, it's nice to step back and marvel at how much you can accomplish without spending a dime on software. Take, for example, the combination of the PHP scripting language and the MySQL database: together, they can do virtually everything needed by the vast majority of dynamic, database-driven web sites. And, with the right kind of help, they're really not that hard to use.
Thousands of web developers have found exactly the help they needed in PHP and MySQL Web Development. Now, Luke Welling and Laura Thomson have updated their outstanding guide to reflect the latest versions of both MySQL (4.0) and PHP (4.2). They've also added new coverage of XML, as well as the new PEAR framework and distribution system for reusable PHP components -- a great resource for folks who'd rather not write all their code from scratch.
As in the first edition, this book is packed with practical sample code (all of it on the accompanying CD-ROM). The authors begin with a crash course on PHP itself: basic syntax, storing and retrieving data from simple flat file databases, using arrays; working with strings and regular expressions; functions; code reuse; and finally, object-oriented PHP techniques.
Next, you'll master MySQL: designing, creating, and working with databases for web applications plus using PHP to access MySQL databases. Welling and Thomson show how to use MySQL's privilege system to secure your databases more effectively, explaining the GRANT command first introduced in MySQL version 3.22.11; the mysql tables that store user and privilege information; and the new security issues that arise when you connect databases to the Web.
Next, they briefly introduce several practical techniques for optimizing your database's performance: minimizing redundancy through careful design; simplifying permissions; optimizing tables; and using indexes.
Once you have the grounding you need, the authors present detailed techniques for building real-world applications. There's an entire section on e-commerce, with detailed chapters on managing e-commerce sites and security, implementing authentication with PHP and MySQL, and, finally, securing transactions. And you'll find chapter-length coverage of networking, session control, interactions with filesystems and servers, managing dates and times, generating images, debugging, and other useful features.
The book also contains seven start-to-finish projects, ranging from content management to email, from generating on-the-fly PDFs to connecting with web services via SOAP.
These application case studies are wonderfully detailed, with clear explanations of the problems they're designed to solve, and simple diagrams explaining the program's system flow and how its modules fit together. What's more, they draw on a wide variety of PHP resources, demonstrating the breadth and depth of this language's capabilities -- and that of the community which surrounds it.
For example, using PHP's IMAP function library, you'll build a complete web-based email client that connects to an existing mail server. (They call their program Warm Mail, which should give you an idea of the model.) Warm Mail allows users to connect to their email accounts, read and send mail, forward and reply to messages, and delete mail -- in short, it's a pretty good workout of PHP's mail capabilities.
Then, in the following chapter, you'll implement a front-end for a mailing list manager customized for managing online newsletters. This app has a pretty long list of requirements: administrators should be able to set up and modify multiple mailing lists, then send text or HTML newsletters to each subscriber. Meanwhile, users should be able to register for the newsletter, enter and manage information about themselves, subscribe to multiple newsletters, unsubscribe to any of them, and view past newsletters. Plus, of course, all of this should be secure.
By the time you've developed this application, you ought to be able to write pretty much anything you need. Few books help you leverage this much power at this little cost. (Bill Camarda/Read Only)