SECOND EDITION Learning PHP and MySQL Michele E. Davis and Jon A. Phillips Beijing • Cambridge • Farnham • Köln • Paris • Sebastopol • Taipei • Tokyo Learning PHP and MySQL, Second Edition by Michele E. Davis and Jon A. Phillips Copyright © 2007, 2006 Michele E. Davis and Jon A. Phillips. All rights reserved. Printed in the United States of America. Published by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. O’Reilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (safari.oreilly.com). For more information, contact our corporate/institutional sales department: (800) 998-9938 or
[email protected] Editor: Simon St.Laurent Production Editor: Marlowe Shaeffer Copyeditor: Reba Libby Proofreader: Sohaila Abdulali Indexer: Ellen Troutman Zaig Cover Designer: Karen Montgomery Interior Designer: David Futato Illustrator: Jessamyn Read Printing History: June 2006: First Edition. August 2007: Second Edition. Nutshell Handbook, the Nutshell Handbook logo, and the O’Reilly logo are registered trademarks of O’Reilly Media, Inc. Learning PHP and MySQL, the image of kookaburra birds, and related trade dress are trademarks of O’Reilly Media, Inc. Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and O’Reilly Media, Inc. was aware of a trademark claim, the designations have been printed in caps or initial caps. While every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein. This book uses RepKover™, a durable and flexible lay-flat binding. ISBN-10: 0-596-51401-8 ISBN-13: 978-0-596-51401-3 [M] Table of Contents Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ix 1. Dynamic Content and the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 HTTP and the Internet PHP and MySQL’s Place in Web Development The Components of a PHP Application Integrating Many Sources of Information Requesting Data from a Web Page 1 2 4 7 11 2. Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Developing Locally Working Remotely 15 35 3. Exploring PHP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 PHP and HTML Text Coding Building Blocks 39 43 4. PHP Decision-Making . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 Expressions Operator Concepts Conditionals Looping 62 64 71 77 5. Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Calling Functions Defining Functions Object-Oriented Programming 87 89 96 v 6. Arrays . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Array Fundamentals 107 7. Working with MySQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 MySQL Database Managing the Database Using phpMyAdmin Database Concepts Structured Query Language 122 125 126 131 132 8. Database Best Practices . . . . . . . . . . . . . . . . . . . . . . . . . . . .