Beginning PHP and MySQL: From Novice to Professional

by Frank M. Kromann

Overview

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.

Product Details

ISBN-13:	9781430260431
Publisher:	Apress
Publication date:	11/30/2018
Edition description:	Fifth Edition
Pages:	875
Product dimensions:	7.00(w) x 9.90(h) x 1.90(d)

About the Author

Frank Kromann has spent more than 30 years solving business problems using software and technology. Since the introduction of the first web browser he has developed systems with web technology on Unix, Linux, Windows, and Mac platforms, with the primary focus on PHP, JavaScript, C/C++, and other languages. He has contributed several PHP extensions over the years and has been a member of the PHP development team since 1997. Previous publications included several articles in PHP Magazine and he was the coauthor of PHP and MySQL Recipes (Apress, 2016). Frank has held managing positions for more than 20 years, leading both smaller and larger teams in development and implementation of business systems and processes utilizing databases and programming. Currently he is an Engineering Manager at Panasonic Avionics and the CEO and cofounder of Web by Pixel, Inc. Kromann holds a Master of Science degree in Electrical Engineering from the Technical University of Denmark.

Table of Contents

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