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
- Introducing PHP
- Configuring Your Environment
- PHP Basics
- Functions
- Arrays
- Object-Oriented PHP
- Advanced OOP Features
- Error and Exception Handling
- Strings and Regular Expressions
- Working with the File and Operating System
- PEAR
- Date and Time
- Forms
- Authenticating Your Users
- Handling File Uploads
- Networking
- PHP and LDAP
- Session Handlers
- Templating with Smarty
- Web Services
- Secure PHP Programming
- SQLite
- Building Web Sites for the World
- MVC and the Zend Framework
- Introducing MySQL
- Installing and Configuring MySQL
- The Many MySQL Clients
- MySQL Storage Engines and Datatypes
- Securing MySQL
- Using PHP with MySQL
- Introducing PDO
- Stored Routines
- MySQL Triggers
- MySQL Views
- Practical Database Queries
- Indexes and Searching
- Transactions
- Importing and Exporting Data
About the Author
W. Jason Gilmoreis a Columbus, Ohio-based developer, consultant, writer, and editor. He’s a cofounder of the CodeMash conference and is a member of the 2008 MySQL Conference speaker selection board. In his previous capacity as Apress’s open source editor, he fostered the publication of more than 60 books, along the way helping to transform the open source line into one of the industry’s most respected publishing programs.
Through W.J. Gilmore, LLC, (http://www.wjgilmore.com/) Jason provides an array of consulting and web development services to small businesses around the country. Contact Jason at wjATwjgilmore.com if you’re looking for competent, timely, and cost-effective services.
Book Details
- Paperback: 1100 pages
- Publisher: Apress; 4 edition (September, 2010)
- Language: English
- ISBN-10: 1430231149
- ISBN-13: 978-1430231141
- File Size: 9.5 MiB
- Hits: 4,383 times
