Beginning PHP and MySQL: From Novice to Professional, 5th Edition

Get started with PHP and MySQL programming: no experience necessary. This fifth edition of a classic best-seller includes detailed instructions for configuring the ultimate PHP 7 and MySQL development environment on all major platforms, complete coverage of the latest additions and improvements to the PHP language, and thorough introductions to MySQL’s most relied-upon features.

You’ll not only receive extensive introductions to the core features of PHP, MySQL, and related tools, but you’ll also learn how to effectively integrate them in order to build robust data-driven applications. Author Frank M. Kromann draws upon more than 20 years of experience working with these technologies to pack this book with practical examples and insight into the real-world challenges faced by developers. Accordingly, you will repeatedly return to this book as both a valuable instructional tool and reference guide.

What You Will Learn

• Install PHP, MySQL, and several popular web servers
• Get started with PHP, including using its string-handling, networking, forms-processing, and object-oriented features
• Gain skills in MySQL’s fundamental features, including supported data types, database management syntax, triggers, views, stored routine syntax, and import/export capabilities
• Work with hundreds of examples demonstrating countless facets of PHP and MySQL integration

Who This Book Is For

Table of Contents

Chapter 1: Introducing PHP
Chapter 2: Configuring Your Environment
Chapter 3: PHP Basics
Chapter 4: Functions
Chapter 5: Arrays
Chapter 6: Object-Oriented PHP
Chapter 7: Advanced OOP Features
Chapter 8: Error and Exception Handling
Chapter 9: Strings and Regular Expressions
Chapter 10: Working with the File and Operating System
Chapter 11: Third-Party Libraries
Chapter 12: Date and Time
Chapter 13: Forms
Chapter 14: Authenticating Your Users
Chapter 15: Handling File Uploads
Chapter 16: Networking
Chapter 17: Session Handlers
Chapter 18: Web Services
Chapter 19: Secure PHP Programming
Chapter 20: Integrating jQuery and PHP
Chapter 21: MVC and Frameworks
Chapter 22: Introducing MySQL
Chapter 23: Installing and Configuring MySQL
Chapter 24: The Many MySQL Clients
Chapter 25: MySQL Storage Engines and Data Types
Chapter 26: Securing MySQL
Chapter 27: Using PHP with MySQL
Chapter 28: Introducing PDO
Chapter 29: Stored Routines
Chapter 30: MySQL Triggers
Chapter 31: MySQL Views
Chapter 32: Practical Database Queries
Chapter 33: Indexes and Searching
Chapter 34: Transactions
Chapter 35: Importing and Exporting Data