Beginning PHP and MySQL From Novice to Professional

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
  

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.