Expert PHP and MySQL (Wrox Programmer to Programmer) and over one million other books are available for Amazon Kindle. Learn more



or
Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $0.78 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading Expert PHP and MySQL (Wrox Programmer to Programmer) on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.
Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 

Expert PHP and MySQL [Paperback]

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

List Price: $44.99
Price: $30.27 & FREE Shipping. Details
You Save: $14.72 (33%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Ships from and sold by Amazon.com. Gift-wrap available.
Want it tomorrow, May 24? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Formats

Amazon Price New from Used from
Kindle Edition $25.64  
Paperback $30.27  
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Book Description

March 29, 2010 0470563125 978-0470563120 1
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.


Frequently Bought Together

Expert PHP and MySQL + Pro PHP Programming
Price for both: $71.43

Buy the selected items together
  • Pro PHP Programming $41.16


Editorial Reviews

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.

wrox.com

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.

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.


Product Details

  • Paperback: 624 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.2 inches
  • Shipping Weight: 2.3 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #619,062 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.8 out of 5 stars
(5)
3.8 out of 5 stars
Share your thoughts with other customers
Most Helpful Customer Reviews
14 of 15 people found the following review helpful
Format:Paperback
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.
Was this review helpful to you?
4 of 4 people found the following review helpful
4.0 out of 5 stars Good read, good reference. July 12, 2010
Format:Paperback
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;
Was this review helpful to you?
2 of 2 people found the following review helpful
4.0 out of 5 stars Quite thorough May 14, 2010
Format:Paperback|Amazon 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.
Comment | 
Was this review helpful to you?

What Other Items Do Customers Buy After Viewing This Item?


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Listmania!


So You'd Like to...


Create a guide


Look for Similar Items by Category