Master today’s best practices for succeeding with PHP 7 and MySQL 5.7 web database development! Long acknowledged as the clearest, most practical, and most down-to-earth 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.
Maintaining the approach that has made this book so successful through, Luke Welling and Laura Thomson add extensive new coverage of security, cloud and mobile development, and using the PEAR repository’s massive resources.
Part I offers a crash course in using PHP, including data storage/retrieval, arrays, strings, regular expressions, code reuse, objects, and error/exception handling. Next, Part II walks you through designing, creating, accessing, and programming MySQL databases.
Part III turns to web application security, adding new information on web security risks, instructions on how to build a secure web application, and up-to-the-minute discussions of cryptography and implementing authentication in PHP and MySQL.
A full section on advanced PHP techniques addresses everything from networking and filesystem interaction to internationalization and localization, generating images, and PHP frameworks and components.
The authors conclude with step-by-step walkthroughs of several real-world projects – from automated testing, to building user authentication and personalization, to building a web-based email service, to integrating with social media, to building web forums and shopping carts, and even to designing an API for your web applications.
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
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 Cryptography Basics
17 Implementing Authentication with PHP and MySQL
Part IV Advanced PHP Techniques
18 Interacting with the File System and the Server
19 Using Network and Protocol Functions
20 Managing the Date and Time
21 Internationalization and Localization
22 Generating Images
23 Using Session Control in PHP
24 Frameworks and Components
25 Other Useful Features
Part V Building Practical PHP and MySQL Projects
26 Using PHP and MySQL for Large Projects
27 Debugging and Logging
28 Automated Testing, Continuous Integration, and Continuous Deployment
29 Building User Authentication and Personalization
30 Building a Web-Based Email Service with Laravel
31 Social Media Integration Sharing and Authentication
32 Building Web Forums with Simple MVC
33 Building a Shopping Cart
34 Designing an API for Your Web Applications
Part VI: Appendix
A Installing Apache, PHP and MySQL