Beginning PHP 5 and MySQL 5

Beginning PHP and MySQL 5 From Novice to Professional, Second Edition - - - W. Jason Gilmore Beginning PHP and MySQL 5: From Novice to Professional, Second Edition Copyright (c) 2006 by W. Jason Gilmore All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher. ISBN-13 (pbk): 978-1-59059-552-7 ISBN-10 (pbk): 1-59059-552-1 Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1 Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark. Lead Editor: Matthew Moodie Technical Reviewer: Matthew Wade Editorial Board: Steve Anglin, Dan Appleman, Ewan Buckingham, Gary Cornell, Tony Davis, Jason Gilmore, Jonathan Hassell, Chris Mills, Dominic Shakeshaft, Jim Sumser Project Managers: Laura Cheu, Beth Christmas Copy Edit Manager: Nicole LeClerc Copy Editor: Bill McManus Assistant Production Director: Kari Brooks-Copony Production Editor: Laura Cheu Compositor: Susan Glinert Stevens Proofreader: Nancy Sixsmith Indexer: John Collin Cover Designer: Kurt Krames Manufacturing Director: Tom Debolski Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor, New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer-sbm.com, or visit http://www.springeronline.com. For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone 510-549-5930, fax 510-549-5939, e-mail info@apress.com, or visit http://www.apress.com. The information in this book is distributed on an as is basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work. The source code for this book is available to readers at http://www.apress.com in the Source Code section. v Contents at a Glance About the Author ... xxvii About the Technical Reviewer ... xxix Acknowledgments ... xxxi Introduction ... xxxiii -CHAPTER 1 An Introduction to PHP ... 1 -CHAPTER 2 Installing and Configuring Apache and PHP ... 9 -CHAPTER 3 PHP Basics ... 43 -CHAPTER 4 Functions ... 91 -CHAPTER 5 Arrays ... 103 -CHAPTER 6 Object-Oriented PHP ... 133 -CHAPTER 7 Advanced OOP Features ... 157 -CHAPTER 8 Error and Exception Handling ... 177 -CHAPTER 9 Strings and Regular Expressions ... 191 -CHAPTER 10 Working with the File and Operating System ... 229 -CHAPTER 11 PEAR ... 259 -CHAPTER 12 Date and Time ... 271 -CHAPTER 13 Forms and Navigational Cues ... 303 -CHAPTER 14 Authentication ... 325 -CHAPTER 15 Handling File Uploads ... 345 -CHAPTER 16 Networking ... 359 -CHAPTER 17 PHP and LDAP ... 399 -CHAPTER 18 Session Handlers ... 425 -CHAPTER 19 Templating with Smarty ... 447 -CHAPTER 20 Web Services ... 473 -CHAPTER 21 Secure PHP Programming ... 515 -CHAPTER 22 SQLite ... 535 -CHAPTER 23 Introducing PDO ... 555 vi -CONTENTS AT A GLANCE -CHAPTER 24 Introducing MySQL ... 573 -CHAPTER 25 Installing and Configuring MySQL ... 581 -CHAPTER 26 The Many MySQL Clients ... 607 -CHAPTER 27 MySQL Storage Engines and Datatypes ... 631 -CHAPTER 28 Securing MySQL ... 661 -CHAPTER 29 PHP s MySQL Extension ... 689 -CHAPTER 30 PHP s mysqli Extension ... 719 -CHAPTER 31 Stored Routines ... 745 -CHAPTER 32 MySQL Triggers ... 767 -CHAPTER 33 Views ... 779 -CHAPTER 34 Practical Database Queries ... 793 -CHAPTER 35 Indexes and Searching ... 817 -CHAPTER 36 Transactions ... 831 -CHAPTER 37 Importing and Exporting Data ... 845 -INDEX ... 859