PHP and MySQL remain the two most popular open-source Web development technologies. In PHP and MySQL Web Development, the authors share their experience with PHP and MySQL without reservation. This book is a definitive guide to building database-driven Web applications using PHP and MySQL, and has been a best-seller for more than a decade.

The book is divided into five chapters. The first chapter covers the basic knowledge of PHP language; the second chapter covers the basic knowledge of MySQL; the third chapter explains the security of Web applications; the fourth chapter explains the advanced programming techniques of PHP; and the fifth chapter focuses on the actual practices. Compared to the fourth edition of this book, the fifth edition is fully updated, rewritten, and extended, provides a detailed overview of the updates and new features for PHP 7, as well as new features in the latest version of MySQL.

As one of the classic books to learn PHP and MySQL development, PHP and MySQL Web Development is rich and complete in content, has rigorous and reasonable layout and structure, is easy to understand, and provides simple and practical examples. If you're new to PHP and MySQL, you'll have enough technology and confidence to develop complex Web applications after reading this book. This book is also a good reference if you are an experienced developer looking to get into a real world project.

Key Features

  • The definitive, best-selling book on combining these two open source tools to create dynamic Web sited -- updated for PHP 7 and MySQL 5.7
  • Clear, practical, down to earth, and now extensively updated for today's best practices
  • Includes a brand-new chapter on PHP cloud development, plus all-new mobile web app projects
  • Now focuses on security issues throughout, and contains an all-new chapter on Web security
  • Adds new coverage of using the indispensable PEAR repository of PHP extensions and applications

Table Of Contents

  • Part I: Using PHP
    • 1 PHP Crash Course
    • 2 Storing and Retrieving Data
    • 3 Using Arrays
    • 4 String Manipulation and Regular Expressions
    • 5 Reusing Code and Writing Functions
    • 6 Object-Oriented PHP
    • 7 Error and Exception Handling
  • Part II: Using MySQL
    • 8 Designing Your Web Database
    • 9 Creating Your Web Database
    • 10 Working with Your MySQL Database
    • 11 Accessing Your MySQL Database from the Web with PHP
    • 12 Advanced MySQL Administration
    • 13 Advanced MySQL Programming
  • Part III: Web Application Security
    • 14 Web Application Security Risks
    • 15 Building a Secure Web Application
    • 16 Implementing Authentication Methods with PHP
  • Part IV: Advanced PHP Techniques
    • 17 Interacting with the File System and the Server
    • 18 Using Network and Protocol Functions
    • 19 Managing the Date and Time
    • 20 Internationalization and Localization
    • 21 Generating Images
    • 22 Using Session Control in PHP
    • 23 Integrating JavaScript and PHP
    • 24 Other Useful Features
  • Part V: Building Practical PHP and MySQL Projects
    • 25 Using PHP and MySQL for Large Projects
    • 26 Debugging and Logging
    • 27 Building User Authentication and Personalization
    • 28 (Web Edition) Building a Web-Based Email Client with Laravel Part I
    • 29 (Web Edition) Building a Web-Based Email Client with Laravel Part II
    • 30 (Web Edition) Social Media Integration Sharing and Authentication
    • 31 (Web Edition) Building a Shopping Cart
  • Part VI: Appendix
    • A Installing Apache, PHP, and MySQL

Book Example Codes

Download URLs

Format Pages Download Size
Forth Edition
PDF 1009 reserved 12.0 MB
Fifth Edition
PDF 687 4.94 MB
(Homepage)