32%
Expert PHP and MySQL

Expert PHP and MySQL

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

Best practices and expert techniques for even the most demanding MySQL-driven PHP applicationsPHP 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 effortPacked with helpful examples and indispensable advice, this book shares tips and tricks that you can immediately apply to your projects.

Table of Contents:
INTRODUCTION XXIX CHAPTER 1: TECHNIQUES EVERY EXPERT PROGRAMMER NEEDS TO KNOW 1 Object-Oriented PHP 2 Using MySQL Joins 20 MySQL Unions 28 GROUP BY in MySQL Queries 30 Logical Operations and Flow Control in MySQL 33 Maintaining Relational Integrity 35 Subqueries in MySQL 46 Using Regular Expressions 49 Summary 63 CHAPTER 2: ADVANCED PHP CONCEPTS 65 A Problem That Needs Solving 65 Iterators and the SPL 67 Lambda Functions and Closures 78 Summary 85 CHAPTER 3: MYSQL DRIVERS AND STORAGE ENGINES 87 MySQL Drivers 88 About MySQL Storage Engines 89 Default Storage Engines 93 Other MySQL Supplied Engines 118 Pluggable Engines 121 Engines as Standalone Products 124 Other MySQL Offerings 125 Summary 129 CHAPTER 4: IMPROVING PERFORMANCE THROUGH CACHING 131 eAccelerator and APC 132 memcached 138 Installing memcached 145 Starting memcached 148 Libmemcached 153 Libmemcached Utility Programs 155 PECL/Memcached 158 Practical Caching 180 Summary 188 CHAPTER 5: MEMCACHED AND MYSQL 191 The Memcached Functions for MySQL 191 How the Memcached Functions for MySQL Work 192 Installing the Memcached Functions for MySQL 193 Using the Memcached Functions for MySQL 196 Summary 220 CHAPTER 6: ADVANCED MYSQL 221 Views 221 Stored Procedures and Functions 226 Triggers 232 Transactions 237 Replication 250 Events 264 Summary 270 CHAPTER 7: EXTENDING MYSQL WITH USER-DEFINED FUNCTIONS 271 Introduction to UDFs 272 Developing a UDF 273 A Practical UDF Example 274 Other UDF SQL Statements 300 Debugging a UDF 300 Summary 305 CHAPTER 8: WRITING PHP EXTENSIONS 307 Setting Up the Build Environment 308 Creating an Extension with ext-skel 309 Creating an Extension with CodeGen-PECL 314 Variables in PHP Extensions 321 Using Functions in Extensions 329 Input/Output 340 Arrays and Hash Tables 347 Objects and Interfaces 349 Constants, INI Directives, and Globals 357 Describing an Extension 361 Summary 364 CHAPTER 9: FULL-TEXT SEARCHING 365 MySQL FULLTEXT Indexes 365 A Better Solution: The Sphinx Full-Text Search Engine 369 Developing Applications That Use SPHINX 395 Summary 399 CHAPTER 10: MULTI-TASKING IN PHP AND MYSQL 401 Gearman 401 What Is Gearman? 402 Narada: A Search Engine Application 412 Summary 442 CHAPTER 11: REWRITE RULES 443 Using Rewrite Rules 444 Rewrite Maps 451 Summary 456 CHAPTER 12: USER AUTHENTICATION 457 Designing the Database 458 HTTP-Based Authentication 460 Pure PHP Authentication 466 Access Control Lists 473 Summary 475 CHAPTER 13:UNDERSTANDING THE INFORMATION-SCHEMA 477 Using the INFORMATION-SCHEMA 478 Table Objects Tables 479 Other Database Objects Tables 481 MySQL Status Tables 482 MySQL Meta Data Tables 486 MySQL ACL Permissions Tables 488 INFORMATION-SCHEMA Extensions 491 SHOW Cross Reference 491 Summary 492 CHAPTER 14: SECURITY 493 Hardening Your MySQL Server 493 Encoding Data 501 PHP Security Recipes 506 Summary 516 CHAPTER 15: COMMAND-LINE AND WEB SERVICES 517 Creating Command-Line Scripts 517 Creating Web Services 524 Summary 541 CHAPTER 16: OPTIMIZATION AND DEBUGGING 543 Debugging PHP 543 Optimizing Queries 545 Debugging MySQL 560 Summary 565 INDEX 567


Best Sellers


Product Details
  • ISBN-13: 9780470563120
  • Publisher: John Wiley & Sons Inc
  • Publisher Imprint: Wrox Press
  • Depth: 38
  • Language: English
  • Returnable: N
  • Spine Width: 31 mm
  • Width: 191 mm
  • ISBN-10: 0470563125
  • Publisher Date: 29 Mar 2010
  • Binding: Paperback
  • Height: 234 mm
  • No of Pages: 587
  • Series Title: English
  • Weight: 1066 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
Expert PHP and MySQL
John Wiley & Sons Inc -
Expert PHP and MySQL
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Expert PHP and MySQL

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA