- Paperback: 587 pages
- Publisher: Wrox; 1 edition (March 29, 2010)
- Language: English
- ISBN-10: 0470563125
- ISBN-13: 978-0470563120
- Product Dimensions: 7.4 x 1.2 x 9.3 inches
- Shipping Weight: 2.3 pounds (View shipping rates and policies)
- Average Customer Review: 3.7 out of 5 stars See all reviews (6 customer reviews)
- Amazon Best Sellers Rank: #2,054,944 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.
Expert PHP and MySQL 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Customers who bought this item also bought
What other items do customers buy after viewing this item?
From the Back Cover
Best practices and expert techniques for today's most demanding apps
As the world's most popular, general purpose, open source scripting language, PHP is frequently used with MySQL to create high-traffic, mission-critical applications. This indispensable book shares proven, author-tested best practices and expert techniques that can be applied to even the most demanding MySQL-driven PHP apps. You'll explore ways to extend MySQL with user-defined functions, write PHP extensions, and solve problems when PHP and MySQL alone are not enough and other techniques or third-party tools are necessary.
Expert PHP and MySQL:
Reviews essential techniques, such as design patterns, complex queries, and advanced regular expression
Addresses advanced PHP concepts, such as iterators and closures
Demonstrates using Gearman for multitasking in your web applications
Discusses caching using memcached with MySQL and your PHP web applications
Discusses ways to create PHP Extensions and MySQL User Defined Functions
Shows how to use Sphinx for search functionality in your PHP web applications
Wrox Expert books present the wisdom accumulated by an experienced author team who is recognized as experts by the programming community. These experts challenge professional developers to examine their current practices in pursuit of better results.
Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
Find articles, ebooks, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
About the Author
Andrew Curioso is a senior software engineer at MyVBO (Virtual Business Office) creating an innovative and scalable infrastructure for Rich Internet Applications using PHP and MySQL.
Ronald Bradford is a technology strategist and advisor specializing in MySQL, Drizzle and related web technologies. With a primary focus on architecture, design, performance analysis and scalability of web applications, his consulting portfolio ranges from Internet startups to Fortune 500 companies.
Patrick Galbraith is a principal software engineer at Lycos, adding new PHP and MySQL offerings for Tripod Users, switching remaining apps using Oracle to MySQL as well as other interesting projects.
Browse award-winning titles. See more
If you are a seller for this product, would you like to suggest updates through seller support?
Top Customer Reviews
This book really does expect something from the reader, so perhaps a word of caution is in order: you really do need to be familiar with a range of non-beginner subjects on both PHP and MySQL. I strongly recommend that you first read Chapter 1 of the book, helpfully available on the books' website. If you are not familiar with the contents presented here, you're not likely to gain much from your purchase.
If, on the other hand, all that you read there is Known Stuff, you're really in for a treat with this book. If you write programs because you have that personal itch, this book is going to make you feel as if you've just been attacked by a horde of mosquitoes. Really. You'll be re-thinking everything about how you build your websites from now on. But you won't need any itches for this book to make you re-think how you work with PHP and MySQL.
The book is extremely information-packed. I'm not one to shy away from reading 3-400 pages of technical references in a day, but this book is so densely filled that you simply won't be able to do that. Considering the breadth of topics covered, the authors at the same time manage to dive very deeply into each subject, covering all relevant resources, options, program libraries and best practices along the way. This does not make the book hard to read, to the contrary the language is very clear and concise. Don't expect information to be repeated anywhere.
Whether it's due to the authors or excellent editing, the language is very consistent and flows very well from chapter to chapter. If it wasn't for the change in subject matter and the authors' stated focus areas in the beginning of the book, it would be hard to discern that three people have been involved in writing this book.
A wonderful trait of all the authors is that they are very frank in assessing the available technologies, and don't mind telling you which things simply don't work, and why you should stay away from them - even when those technologies are offered by their respective employers.
You'll learn not only how to make the most optimal pure-PHP and pure-MySQL solutions, you will also see how you can integrate both of these with external programs by writing your own extensions and libraries. Descriptions of best practices in subjects such as user authentication and security will probably make you want to go back and check whether something could be improved in your own code and web server setup.
The chapters on advanced caching techniques, multi-tasking, optimization and debugging considerations are all very detailed and to the point. You'll be able to immediately put the techniques presented to use, and the book will serve you not only as a great tutorial, it will also be a great reference later on when you want to tune your setup.
There are of course a few chapters that could have used a bit more work. One chapter consists of barely more than a listing of output of feature lists, another contains very lengthy outputs that the reader might as well pull up on his own screen when working with some of the products. But these examples really are exceptions in an otherwise extremely well-written, informative and above all useful book.
Another word of caution: The book is highly UNIX (Linux) centric. If all your work is done using Windows, your benefit from reading this book might be limited. Then again, reading the book and realizing the potentials just might explain to you why it is most shops deploy their PHP/MySQL solutions on Linux.
mysql > Being a MySQL DBA, not a developer, I was mostly interested in the MySQL sections but given I have a general interest in scripting I did go through some of the PHP sections. To be honest they were quite advanced for my php knowledge and experience.
The good thing about the book is that even though it assumes you have the basic knowledge, it still provides an introductory background on most of the two (PHP and MySQL) topics. This is not a "PHP and MySQL for dummies" so don't expect to learn the very basics nor will you become an expert in either topic by just reading the book. Even if you read the book thoroughly, becoming an expert requires years of hard work and experience. Having said that, his book is a good guide to make it there.
If you are at least a basic developer, this book will help you increase your knowledge drastically and create much better apps. If you are already an experienced dev, the book will probably still give you a few insights on things you don't use all that often and help keep your edge. As regards DBAs, the book is worth a great deal in that quite a substantial amount of its content is MySQL, and the PHP chapters will help you understand the developer point of view.
Finally, its a great addition to my library for referencing and a good read.
mysql > Recommended;
mysql > commit;