Beginning PHP and MySQL

From Novice to Professional

4th Edition

By W Jason Gilmore

Beginning PHP and MySQL Cover Image

Up-to-date coverage of PHP 5.3 and MySQL from one of the most trusted names in PHP development, W. Jason Gilmore.

Full Description

  • ISBN13: 978-1-4302-3114-1
  • 824 Pages
  • User Level: Beginner to Intermediate
  • Publication Date: September 23, 2010
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $49.99
  • eBook Price: $34.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

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

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
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

On page 130:

$diff = array_diff($array1, $array2, $array3);
print_r($intersection);
get an error $intersection undefined.

On page 146:
the public method greetVisitor() can only be called on an object.

Visitors::greetVisitor() is not correct, this would only work if it was static

On page 187:

"catch (InvalidEmailException $e)" must come before "catch (Exception $e)". Otherwise "catch (InvalidEmailException $e)" will never fire even if "InvalidEmailException" is thrown. It will not be caught by "catch (InvalidEmailException $e)" because as long as "InvalidEmailException" it is a subclass of "Exception" it will be caught by "catch (Exception $e)".

One more.
The call "$e->notifyAdmin($email)" cannot be made from the class "subscribe" because "notifyAdmin" method is private in the "InvalidEmailException" class.