Description

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 personalisation
• Web-based email
• Social media integration
• Shopping cart

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

New to this Edition

• Adds a new chapter on PHP cloud development and new projects on creating mobile web applications
• Includes a new focus on security issues throughout the book, in addition to a new chapter on Web security
• New coverage of how to use the increasingly important PEAR repository of PHP extensions and applications
• Updated for PHP 7 and MySQL 5.7

Table of Contents

PHP and MySQL Web Development, 5th Edition

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 (PDFs with Product Registration) Building a Web-Based Email Client with Laravel Part I

29 (PDFs with Product Registration) Building a Web-Based Email Client with Laravel Part II

30 (PDFs with Product Registration) Social Media Integration Sharing and Authentication

31 (PDFs with Product Registration) Building a Shopping Cart

Part VI: Appendix

A Installing Apache, PHP, and MySQL

Author