Beginning PHP and MySQL

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.

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.