Beginning PHP and MySQL: From Novice to Professional, Fourth Edition

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. SQLite
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