PHP and MySQL Web Development

Long acknowledged as the clearest and most practical guide to PHP/MySQL web development, the brand-new Fifth Edition of PHP and MySQL Web Development fully reflects the latest versions of PHP and MySQL to help your students master today’s best practices for succeeding with PHP 7 and MySQL 5.7 web database development. New coverage of security, cloud and mobile development and using the PEAR repository’s massive resources have been added to this edition. The authors teach all these things while maintaining the clarity and character that thousands of readers have found so appealing in the book’s first four editions
1. 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
2. Clear, practical, down to earth and now extensively updated for today’s best practices
3. Includes a brand-new chapter on PHP cloud development, plus all-new mobile web app projects
4. Now focuses on security issues throughout and contains an all-new chapter on Web security
5. Adds new coverage of using the indispensable PEAR repository of PHP extensions and applications
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

Part VI: Appendix
A Installing Apache, PHP and MySQL