PHP5 and MySQL bible

1083 Pages·2004·15.973 MB·English

by  Tim Converse, Joyce Park, Clark Morgan

01 557467 FM.qxd 4/5/04 11:09 AM Page iii
PHP5 and
MySQL® Bible
Tim Converse and Joyce Park
with Clark Morgan
01 557467 FM.qxd 4/5/04 11:09 AM Page ii
01 557467 FM.qxd 4/5/04 11:09 AM Page i
PHP5 and
MySQL® Bible
01 557467 FM.qxd 4/5/04 11:09 AM Page ii
01 557467 FM.qxd 4/5/04 11:09 AM Page iii
PHP5 and
MySQL® Bible
Tim Converse and Joyce Park
with Clark Morgan
01 557467 FM.qxd 4/5/04 11:09 AM Page iv
PHP5 and MySQL®Bible
Published by
Wiley Publishing, Inc.
10475 Crosspoint Boulevard
Indianapolis, IN 46256
www.wiley.com
Copyright © 2004 by Wiley Publishing, Inc., Indianapolis, Indiana
Published simultaneously in Canada
ISBN: 0-7645-5746-7
Manufactured in the United States of America
10 9 8 7 6 5 4 3 2 1
1B/SR/QU/QU/IN
No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means,
electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108
of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization
through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA
01923, [phone], fax [phone]. Requests to the Publisher for permission should be addressed to the Legal
Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, [phone], fax [phone],
E-Mail: [email protected].
LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY:THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS
OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND
SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT LIMITATION WARRANTIES OF FITNESS FOR A
PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS.
THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS
SOLD WITH THE UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING,
OR OTHER PROFESSIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A
COMPETENT PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE
LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS REFERRED TO IN
THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMATION DOES NOT MEAN THAT
THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE
OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED
IN THIS WORK MAY HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT
IS READ.
For general information on our other products and services or to obtain technical support, please contact our Customer
Care Department within the U.S. at [phone], outside the U.S. at [phone] or fax [phone].
Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in
electronic books.
Library of Congress Control Number: 2004103176
Trademarks:Wiley, the Wiley logo, and related trade dress are trademarks or registered trademarks of John Wiley & Sons,
Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. MySQL
is a registered trademark of MySQL AB Limited Company. All other trademarks are the property of their respective owners.
Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book.
01 557467 FM.qxd 4/5/04 11:09 AM Page v
About the Authors
Tim Conversehas written software to recommend neckties, answer questions about space
stations, pick value stocks, and make simulated breakfast. He has an M.S. in Computer
Science from the University of Chicago, where he taught several programming classes. He is
now an engineering manager in the Web search group at Yahoo!.
Joyce Parkhas an M.A. in history from the University of Chicago, and has worked for several
Silicon Valley startups including Epinions, KnowNow, and Friendster. She is a co-lead of the
Mod-pubsub Open Source project.
Clark Morgan is a Web application and educational software developer with more than five
years’ experience writing PHP. He works primarily with medical clients and related busi-
nesses. Originally from Boston, he now lives and works in Jacksonville, Florida, with his wife
and two children. Clark spends entirely too much of his free time reading other people’s com-
puter books.
01 557467 FM.qxd 4/5/04 11:09 AM Page vi
Credits
Acquisitions Editor Vice President and Publisher
Debra Williams Cauley Joseph B. Wikert
Development Editor Executive Editorial Director
Sara Shlaer Mary Bednarek
Production Editor Project Coordinator
Eric Newman April Farling
Technical Editors Graphics and Production Specialists
Chris Cornell Beth Brooks
David Wall Sean Decker
Carrie Foster
Copy Editor Lauren Goddard
C. M. Jones
Quality Control Technician
Editorial Manager Laura Albert
Mary Beth Wakefield Carl William Pierce
Vice President & Executive Group Permissions Editor
Publisher Carmen Krikorian
Richard Swadley
Media Development Specialist
Vice President and Executive Angela Denny
Publisher
Bob Ipsen Proofreading and Indexing
TECHBOOKS Production Services
01 557467 FM.qxd 4/5/04 11:09 AM Page vii
To our parents:
For their love, for their sacrifices,
and for letting us read a lot when we were kids.
—Tim Converse and Joyce Park
This, my first serious writing effort, is for my lifelong friend Bob, who pointed me in
this direction nearly ten years ago and then had the nerve to suggest I write about it.
—Clark Morgan