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
Anyone who wants to get started using PHP to write dynamic web applications.
Author(s): Frank M. Kromann
Edition: 5
Publisher: Apress
Year: 2018
Language: English
Pages: 875
City: New York
Tags: Programming;Web development;PHP;MySQL;SQL;Database
Front Matter ....Pages i-xxv
Introducing PHP (Frank M. Kromann)....Pages 1-14
Configuring Your Environment (Frank M. Kromann)....Pages 15-46
PHP Basics (Frank M. Kromann)....Pages 47-96
Functions (Frank M. Kromann)....Pages 97-112
Arrays (Frank M. Kromann)....Pages 113-152
Object-Oriented PHP (Frank M. Kromann)....Pages 153-184
Advanced OOP Features (Frank M. Kromann)....Pages 185-208
Error and Exception Handling (Frank M. Kromann)....Pages 209-227
Strings and Regular Expressions (Frank M. Kromann)....Pages 229-269
Working with the File and Operating System (Frank M. Kromann)....Pages 271-307
Third-Party Libraries (Frank M. Kromann)....Pages 309-318
Date and Time (Frank M. Kromann)....Pages 319-341
Forms (Frank M. Kromann)....Pages 343-359
Authenticating Your Users (Frank M. Kromann)....Pages 361-380
Handling File Uploads (Frank M. Kromann)....Pages 381-390
Networking (Frank M. Kromann)....Pages 391-416
Session Handlers (Frank M. Kromann)....Pages 417-441
Web Services (Frank M. Kromann)....Pages 443-460
Secure PHP Programming (Frank M. Kromann)....Pages 461-478
Integrating jQuery and PHP (Frank M. Kromann)....Pages 479-494
MVC and Frameworks (Frank M. Kromann)....Pages 495-512
Introducing MySQL (Frank M. Kromann)....Pages 513-520
Installing and Configuring MySQL (Frank M. Kromann)....Pages 521-541
The Many MySQL Clients (Frank M. Kromann)....Pages 543-565
MySQL Storage Engines and Data Types (Frank M. Kromann)....Pages 567-603
Securing MySQL (Frank M. Kromann)....Pages 605-636
Using PHP with MySQL (Frank M. Kromann)....Pages 637-662
Introducing PDO (Frank M. Kromann)....Pages 663-688
Stored Routines (Frank M. Kromann)....Pages 689-716
MySQL Triggers (Frank M. Kromann)....Pages 717-731
MySQL Views (Frank M. Kromann)....Pages 733-750
Practical Database Queries (Frank M. Kromann)....Pages 751-775
Indexes and Searching (Frank M. Kromann)....Pages 777-796
Transactions (Frank M. Kromann)....Pages 797-808
Importing and Exporting Data (Frank M. Kromann)....Pages 809-826
Back Matter ....Pages 827-875
