PHP and MySQL Web Development (Developer's Library)

Book Synopsis: PHP and MySQL Web Development, Fifth 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
• Shopping cart

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.

Free Access to Web Edition

Purchase of this book in any format, electronic or print, includes free access to the corresponding Web Edition, which provides several special features:

• The complete text of the book online
• Exercises and interactive quizzes to test your understanding of the material
• Bonus chapters not included in the print or e-book editions
• Updates and corrections as they become available

The Web Edition can be viewed on all types of computers and mobile devices with any modern web browser that supports HTML5.

Contents at a Glance

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

1. Designing Your Web Database
2. Creating Your Web Database
3. Working with Your MySQL Database
4. Accessing Your MySQL Database from the Web with PHP
5. Advanced MySQL Administration
6. Advanced MySQL Programming

Part III: Web Application Security

1. Web Application Security Risks
2. Building a Secure Web Application
3. Implementing Authentication Methods with PHP

Part IV: Advanced PHP Techniques

1. Interacting with the File System and the Server
2. Using Network and Protocol Functions
3. Managing the Date and Time
4. Internationalization and Localization
5. Generating Images
6. Using Session Control in PHP
7. Integrating JavaScript and PHP
8. Other Useful Features

Part V: Building Practical PHP and MySQL Projects

1. Using PHP and MySQL for Large Projects
2. Debugging and Logging
3. Building User Authentication and Personalization
4. (Web Edition) Building a Web-Based Email Client with Laravel Part I
5. (Web Edition) Building a Web-Based Email Client with Laravel Part II
6. (Web Edition) Social Media Integration Sharing and Authentication
7. (Web Edition) Building a Shopping Cart

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