PHP and MySQL Web Development, 5th Edition

The definitive guide to building database-driven Web applications with PHP and MySQL

PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications.

PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server.

This practical, hands-on book consistently focuses on real-world applications, even in the introductory chapters. The authors cover important aspects of security and authentication as they relate to building a real-world website and show you how to implement these aspects in PHP and MySQL. They also introduce you to the integration of front-end and back-end technologies by using JavaScript in your application development.

The final part of this book describes how to approach real-world projects and takes the reader through the design, planning, and building of several projects, including:

• User authentication and personalization
• Web-based email
• Social media integration

The fifth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP through versions 5.6 and 7, as well as features introduced in recent stable releases of MySQL.

Table of Contents

Part I: Using PHP
Chapter 1 PHP Crash Course
Chapter 2 Storing and Retrieving Data
Chapter 3 Using Arrays
Chapter 4 String Manipulation and Regular Expressions
Chapter 5 Reusing Code and Writing Functions
Chapter 6 Object-Oriented PHP
Chapter 7 Error and Exception Handling

Part II: Using MySQL
Chapter 8 Designing Your Web Database
Chapter 9 Creating Your Web Database
Chapter 10 Working with Your MySQL Database
Chapter 11 Accessing Your MySQL Database from the Web with PHP
Chapter 12 Advanced MySQL Administration
Chapter 13 Advanced MySQL Programming

Part III: Web Application Security
Chapter 14 Web Application Security Risks
Chapter 15 Building a Secure Web Application
Chapter 16 Implementing Authentication Methods with PHP

Part IV: Advanced PHP Techniques
Chapter 17 Interacting with the File System and the Server
Chapter 18 Using Network and Protocol Functions
Chapter 19 Managing the Date and Time
Chapter 20 Internationalization and Localization
Chapter 21 Generating Images
Chapter 22 Using Session Control in PHP
Chapter 23 Integrating JavaScript and PHP
Chapter 24 Other Useful Features

Part V: Building Practical PHP and MySQL Projects
Chapter 25 Using PHP and MySQL for Large Projects
Chapter 26 Debugging and Logging
Chapter 27 Building User Authentication and Personalization

Part VI: Appendix
Appedix A: Installing Apache, PHP, and MySQL