Beginning PHP and MySQL: From Novice to Professional

0.0

Beginning PHP and MySQL: From Novice to Professional, Fourth Edition is a major update of W. Jason Gilmore's authoritative book on PHP and MySQL. The fourth edition includes complete coverage of PHP 5.3 features, including namespacing, an update of AMP stack installation and configuration, updates to Zend Framework, coverage of MySQL Workbench, and much more. 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. Gilmore has seven years of experience working with these technologies, and he has packed 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’ll learn How to install and configure Apache, PHP 5.3, and MySQL PHP and object-oriented programming basics New PHP 5.3 features and how to use them How to move beyond basic PHP, including using the Zend Framework How to use MySQL to securely store your website's data How to use MySQL Workbench to manage your database Who this book is for Developers who want to harness PHP and MySQL to create powerful web applications 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. PEAR 12. Date and Time 13. Forms 14. Authenticating Your Users 15. Handling File Uploads 16. Networking 17. PHP and LDAP 18. Session Handlers 19. Templating with Smarty 20. Web Services 21. Secure PHP Programming 22. Integrating jQuery and PHP 23. Building Web Sites for the World 24. MVC and the Zend Framework 25. Introducing MySQL 26. Installing and Configuring MySQL 27. The Many MySQL Clients 28. MySQL Storage Engines and Datatypes 29. Securing MySQL 30. Using PHP with MySQL 31. Introducing PDO 32. Stored Routines 33. MySQL Triggers 34. MySQL Views 35. Practical Database Queries 36. Indexes and Searching 37. Transactions 38. Importing and Exporting Data