Beginning PHP 5 and MySQL

From Novice to Professional

By W. Jason Gilmore

Beginning PHP 5 and MySQL Cover Image

Beginning PHP 5 and MySQL: From Novice to Professional offers a comprehensive introduction to two of the most popular open-source technologies on the planet: the PHP scripting language and the MySQL database server.

Full Description

  • ISBN13: 978-1-893115-51-4
  • 768 Pages
  • User Level: Beginner to Advanced
  • Publication Date: June 20, 2004
  • Available eBook Formats: PDF
  • Print Book Price: $39.99
  • eBook Price: $27.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Beginning PHP 5 and MySQL: From Novice to Professional offers a comprehensive introduction to two of the most popular open-source technologies on the planet: the PHP scripting language and the MySQL database server. You are not only exposed to the core features of both technologies, but will also gain valuable insight into how they are used in unison to create dynamic data-driven web applications, not to mention learn about many of the undocumented features of the most recent versions.

The first part of the book is devoted to PHP's foundational features, with special focus on those new to PHP 5, including the improved object-oriented support, exception handling, SQLite support, SimpleXML, and much more. But PHP 5-specific topics are only part of what's covered; you’ll also learn about the language's core capabilities, beginning with a survey of installation and configuration tasks. Early chapters are devoted to basic PHP programming concepts such as variables, datatypes, arrays, string manipulation, and user interaction. Later chapters cover session handling, LDAP integration, the Smarty templating engine, and Web Services support.

Next up is a broad overview of the powerful MySQL database server. Among other topics, you’ll learn about the installation and configuration process, datatypes, key security features, and various administration utilities. With this groundwork in pace, you'll then learn about PHP's assortment of MySQL functions, accompanied by dozens of examples depicting the creation and execution of queries. You’ll also learn how to perform searches, and manage database transactions.

Whether you’re a newcomer searching for a thorough introduction to these popular technologies, or a seasoned developer in need of a comprehensive reference, this book is for you.

Table of Contents

Table of Contents

  1. An Introduction to PHP
  2. Installing and Configuring PHP
  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. Forms and Navigational Cues
  12. Authentication
  13. Handling File Uploads
  14. Networking with PHP
  15. PHP and LDAP
  16. Session Handlers
  17. Templating with Smarty
  18. Web Services
  19. Secure PHP Programming
  20. SQLite
  21. MySQL: The Disruptive Database
  22. Installing and Configuring MySQL
  23. The Many MySQL Clients
  24. MySQL Table Structures
  25. Securing MySQL
  26. PHP’s MySQL Functionality
  27. Practical Database Queries
  28. Indexes and Searching
  29. Transactions
  30. 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.

No errata are currently published