About the Author
PHP and MySQL Web Development Third EditionAbout the Authors

Laura Thomson is a lecturer in the School of Computer Science and Information Technology at RMIT University in Melbourne, Australia. She is also a partner in the award-winning web development firm Tangled Web Design. Laura has previously worked for Telstra and the Boston Consulting Group. She holds a Bachelor of Applied Science (Computer Science) degree and a Bachelor of Engineering (Computer Systems Engineering) degree with honors, and is currently completing her Ph.D. in Adaptive Web Sites. In her spare time, she enjoys sleeping. Laura can be reached via email at laura@tangledweb.com.au.

Luke Welling is a senior web developer at MySQL AB, the company behind the MySQL database. He has previously taught engineering and computer science at RMIT University in Melbourne, Australia and worked as a computer programmer for many years. He holds a Bachelor of Applied Science (Computer Science) degree. In his spare time, he attempts to perfect his insomnia. Luke can be reached via email at luke@tangledweb.com.au.

Both authors have attained the MySQL Core Certification offered by MySQL AB and the Zend Certified PHP Engineer offered by Zend Technologies Ltd.
© Copyright Pearson Education. All rights reserved.

FROM OUR EDITORS

The Barnes & Noble Review
Thousands of web developers have found all the database help they need in PHP and MySQL Web Development. In their new Third Edition, Luke Welling and Laura Thomson update their classic to reflect new enhancements ranging from PHP5￯﾿ﾽs new object model to MySQL 5￯﾿ﾽs long-awaited stored procedures.

As before, you￯﾿ﾽll find loads of practical sample code (all of it on the accompanying CD-ROM). The authors begin with a crash course on PHP itself: basic syntax, storing and retrieving data from flat file databases, using arrays; working with strings and regular expressions; functions; code reuse; and finally, object-oriented PHP.

One crucial PHP5 enhancement is exception handling: a unified, extensible, object-oriented solution for handling errors. Welling and Thompson cover PHP5 error handling in detail, from basic concepts and control structures through user-defined exceptions.

Next, you￯﾿ﾽll master MySQL from the web developer￯﾿ﾽs point of view. Welling and Thompson introduce mysqli, PHP5￯﾿ﾽs new library for connecting with MySQL with either object-oriented or procedural syntax. Along the way, you￯﾿ﾽll learn how to use MySQL's privilege system to secure your databases more effectively, and how to address the performance issues that arise in web database applications.

You'll find chapter-length coverage of networking, session control, interactions with filesystems and servers, managing dates and times, generating images, debugging, and more. The book￯﾿ﾽs highlight: seven start-to-finish projects, ranging from content management to email, generating on-the-fly PDFs to connecting with web services. Follow along with these case studies, and you should be ready to write just about anything. Bill Camarda

Bill Camarda is a consultant, writer, and web/multimedia content developer. His 15 books include Special Edition Using Word 2003 and Upgrading & Fixing Networks for Dummies, Second Edition.

ANNOTATION

An intermediate to advanced guide to PHP and MySQL, the free, open-sourced Web development products. Offers coverage of object-oriented Web programming, creating services using SSL and authentication, and other applications. The CD-ROM includes full versions of PHP, MySQL, and Apache for Windows and Linux/Unix systems, several graphics libraries, files containing the code listings in the book, and the entire book in PDF format.

FROM THE PUBLISHER

"PHP and MySQL Web Development shows how to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server." "This practical, hands-on book includes numerous examples that demonstrate common tasks such as authenticating users, constructing a shopping cart, generating PDF documents and images dynamically, sending and managing email, facilitating user discussions, managing content, and connecting to Web services using XML." The third edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to include coverage of PHP 5 - including its new object model, better exception handling, and SimpleXML - as well as features introduced in MySQL 5, such as stored procedures.

SYNOPSIS

Topics covered: The MySQL database server (for both Unix and Windows) Accessing MySQL databases through PHP scripting (the letters don't really stand for anything) Database creation and modification PHP tricks in order of increasing complexity--everything from basic SQL queries to secure transactions for commerce Authentication Network connectivity Session management Content customization

FROM THE CRITICS

Booknews