Product Description

• Written for the budding web developer searching for a powerful, low-cost solution for building flexible, dynamic web sites.
• Essentially three books in one: provides thorough introductions to the PHP language and the MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites.
• Provides over 500 code examples, including real-world tasks such as creating an auto-login feature, sending HTML-formatted e-mail, testing password guessability, and uploading files via a web interface.
• Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.

From the Back Cover

Interested in becoming a master of the PHP language and MySQL database but don't know where to begin? This best-selling book ranks among the most thorough and practical guides in print, covering all of the key concepts and features, and showing you how to effectively integrate PHP and MySQL to build powerful web sites.

The book begins with a vast overview of PHP's capabilities, starting with a survey of the installation and configuration process on both the Windows and Linux platforms. Next, several chapters are devoted to basic PHP concepts, including variables, datatypes, arrays, functions, string manipulation, and processing user input. Other key PHP topics are also covered, including PEAR, session handling, LDAP integration, the Smarty templating engine, Web services, and PDO.

Next up is a presentation of MySQL's key features. You're first guided through MySQL's installation and configuration process, and are presented with an introduction to its storage engines, datatypes, administration utilities, security features, and data import/export facilities. New MySQL 5�specific chapters have been added in this edition, covering triggers, stored procedures, and views. Along the way, you'll gain insight into PHP's assortment of MySQL functions (using both the mysql and mysqli extensions), and learn how to create and execute queries, perform searches, and carry out key database tasks from within your Web application.

What You Will Learn from This Book

• Install and configure Apache, PHP, and MySQL on both Windows and Linux.
• Accept and process information submitted via HTML forms.
• Authenticate users and track user preferences and data using PHP's session-handling capabilities.
• Process web-based file uploads using the HTTP_Upload PEAR package.
• Create your own RSS aggregator using Magpie, and process XML files in amazingly efficient fashion using SimpleXML.
• Use both command-line and graphical MySQL clients to effectively manage your data.
• Secure the MySQL server, creating roles and restricting access even at very granular levels.
• Effectively integrate PHP and MySQL to create dynamic, data-driven web applications.

Product Details

• Amazon Sales Rank: #173447 in Books
• Published on: 2006-01-23
• Original language: English
• Number of items: 1
• Binding: Paperback
• 952 pages

About the Author

W. Jason Gilmore is 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.

Customer Reviews

A great reference for any web designer!
This is a great book for any web designer no matter what your experience level. It is a great reference and I was able to teach myself what was needed using this book!

Excellent Book
I own several PHP/Mysql reference books, and this one is the most comprehensive of all of them. Just the right balance and written descriptions/explanations and practical applications/examples. I wouldn't necessarily say this book is for beginners, but anyone that's a novice to professional would love this book. I highly recommend the 3rd addition for any PHP/MySQL developer that is looking for a great reference.

This book is a reference manual at best...
If you are new to PHP, DO NOT buy this book. I can't believe all the good reviews here. There are no practical examples, and very little useful information. It is, at best, a reference manual. If you're new to PHP, check out David Powers' books.