Start reading Expert PHP and MySQL on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.
Expert PHP and MySQL

Expert PHP and MySQL [Kindle Edition]

Andrew Curioso , Ronald Bradford , Patrick Galbraith
4.2 out of 5 stars  See all reviews (4 customer reviews)

Print List Price: £29.99
Kindle Price: £19.37 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £10.62 (35%)
* Unlike print books, digital books are subject to VAT.


Amazon Price New from Used from
Kindle Edition £19.37  
Paperback £20.39  
Kindle Summer Sale: Over 500 Books from £0.99
Have you seen the Kindle Summer Sale yet? Browse selected books from popular authors and debut novelists, including new releases and bestsellers. Learn more

Product Description

Product Description

Best practices and expert techniques for even the most demanding MySQL-driven PHP applications

PHP is the world's most popular, general-purpose, open-source scripting language and MySQL is the world's most popular open-source database. This expert-level book begins with a brief overview of the two technologies and quickly moves on to coverage of advanced programming techniques, as well as the exciting new features of the PHP 5.3 release.

Written by three of PHP and MySQL experts and veteran authors, this resource focuses on best practices and expert techniques that can be applied to the most difficult MySQL-driven PHP applications. The authors share design patterns and tools that they themselves have tested in order to save you valuable time usually spent on figuring things out via trial and error.

  • Reveals best practices and advanced techniques for handling challenges you may face with MySQL-driven PHP apps
  • Reviews practical data reporting techniques for separating business logic from presentation
  • Explains how to obtain improved performance and flexibility through caching, multi-tasking, PHP extensions, and MySQL user defined functions
  • Discusses security, optimization, and debugging
  • Shares author-tested design patterns and tools to save you time and effort

Packed with helpful examples and indispensable advice, this book shares tips and tricks that you can immediately apply to your projects.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

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. Programmer Forums 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. Code Downloads Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use. Read More 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.

Product details

  • Format: Kindle Edition
  • File Size: 4811 KB
  • Print Length: 625 pages
  • Page Numbers Source ISBN: 0470563125
  • Publisher: Wrox; 1 edition (9 April 2010)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B003NHR7TE
  • Text-to-Speech: Enabled
  • X-Ray:
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Bestsellers Rank: #448,921 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Authors

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

4 star
3 star
1 star
4.2 out of 5 stars
4.2 out of 5 stars
Most Helpful Customer Reviews
13 of 14 people found the following review helpful
5.0 out of 5 stars Brilliant introduction to advanced techniques 27 July 2010
The book is a brilliant introduction to some of the more advanced topics in PHP/MySQL development. I read this book cover-to-cover in one weekend and found it easy going and very informative. It touches on everything from PHP design patterns to performance, scalability and security and it goes in to detail about how various popular open source packages can be used together to drive a high-traffic website/application. I recommend this book to anybody involved in developing large-scale web applications. Even if you consider yourself an expert in PHP/MySQL you will find this book of interest for it's coverage of supplementary technologies, which should at the very least get you interested enough to study a more specific topic further.
Was this review helpful to you?
1 of 1 people found the following review helpful
2.0 out of 5 stars Disappointing 7 May 2014
Format:Paperback|Verified Purchase
I bought this book with expectations! What I've got a book with full of mistakes. At the beginning of the book you've not even reached the 60th page and there are countless coding mistakes! Which is annoying, cause I spent hours to find and fix them one by one!
If you decide to buy this book, I would suggest for you to download all of the code examples first, cause those you can find in the book are useless!
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Expert 3 April 2013
Format:Paperback|Verified Purchase
Well what can i say about this book other than it rocks. I was ready to develop my idea confident in the knowledge that i could build it but then i read this book and it introduced me to a whole host of topics that i did not even begin to consider. I thought my SQL and PHP skills were ok but this took them up a notch, with topics such as caching, security, mod-rewrite, advanced SQL, advanced php to name but a few this text is a must read for anyone with the next brilliant high traffic site idea or someone who develops/runs an existing high traffic site.

The book itself was published in 2010 but it's as relevant in 2013 as it was back then.

Definitely not for novices.

Read it!
Comment | 
Was this review helpful to you?
0 of 19 people found the following review helpful
5.0 out of 5 stars Expert PHP and MySQL 15 Jan 2011
Format:Paperback|Verified Purchase
The book was delivered promptly before Xmas. Sadly, my son already had a copy so I had to return it and this was done very easily and with no fuss. I am very happy with all aspects of the deal.
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 3.8 out of 5 stars  5 reviews
15 of 16 people found the following review helpful
5.0 out of 5 stars For once, an "Expert" book where you not only can, but must take the title seriously. 2 April 2010
By pCarsten - Published on
This book is choke-full of information, examples and best practices written by some of the foremost experts in their respective fields. All of the authors clearly have extensive experience working on setups requiring expert knowledge. Best of all, they are not afraid of thinking outside the box and the solutions they present are in no way limited to pure PHP and MySQL solutions.

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.
4 of 4 people found the following review helpful
4.0 out of 5 stars Good read, good reference. 12 July 2010
By Darren Cassar - Published on
mysql > start review;

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;
2 of 2 people found the following review helpful
4.0 out of 5 stars Quite thorough 14 May 2010
By Yaroslav Zborovsky - Published on
Format:Paperback|Verified Purchase
Quite a nice book. I wouldn't say it's a "must have", because some topics were only given a brief outline. I wonder why the authors included those paragraphs where they didn't give the topic a full coverage, but presented a short summary and said "You should already know this". Why did they include those paragraphs at all? It concerns mostly chapters devoted to MySQL. But as for PHP, everything's more than OK. General conclusion - "Above average". But so far not that perfect as I expected.
5.0 out of 5 stars Amazing book 23 Sep 2011
By Mallesh - Published on
I am an techno guy with minimum knowledge about open source languages/technologies. I wanted to get an understanding of those languages. After I read the book, I feel like I knew so many new things. The explanation given in the book with examples is really simple to understand. It covers from basic to advanced topics. I would definitely recommend it.
5 of 10 people found the following review helpful
1.0 out of 5 stars Not what I was looking for 21 Jun 2010
By Shay M. Anderson - Published on
Format:Paperback|Verified Purchase
I assumed by the title, and past experiences with wrox publications, that this book would have a decent amount of code, however, this book has Very few lines of code. The book mainly covers methods/technologies for maintaining/developing large Web sites/apps in PHP and MySQL. The book does not give vast PHP code examples of what it would take to write expert PHP sites/apps. I read this book cover to cover in about a week and learned absolutely nothing. Most of the content in the book should already be familiar to a "PHP programmer". A lot of the content was also very vague. The lack of PHP code illustrated in the book was frustrating and the few lines of PHP code in the book are full of typos/syntax errors. I was hoping this book would extend wrox's Pro PHP5, but this is not the case. I guess I will have to wait for a Pro PHP 5.3 or a book by another publisher...
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category