Wiley MySQL PHP Database Applications 2nd (2004).pdf

MySQL ® /PHP

Database

Applications,

Second Edition

Brad Bulger, Jay Greenspan,

and David Wall

MySQL ® /PHP Database Applications, Second Edition

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

ISBN: 0-7645-4963-4

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

2O/RW/RQ/QT

Published by Wiley Publishing, Inc., Indianapolis, Indiana

Published simultaneously in Canada

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, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher

for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd.,

Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4447, E-Mail: permcoordinator@wiley.com .

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: WHILE THE PUBLISHER AND AUTHOR HAVE

USED THEIR BEST EFFORTS IN PREPARING THIS BOOK, THEY MAKE NO REPRESENTATIONS OR

WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS

BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OF MERCHANTABILITY OR

FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY

SALES REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE ADVICE AND STRATEGIES

CONTAINED HEREIN MAY NOT BE SUITABLE FOR YOUR SITUATION. YOU SHOULD CONSULT WITH

A PROFESSIONAL WHERE APPROPRIATE. NEITHER THE PUBLISHER NOR AUTHOR SHALL BE

LIABLE FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOT

LIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES.

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 (800) 762-2974, outside the U.S. at (317) 572-3993 or fax (317)

572-4002.

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 Cataloging-in-Publication Data: 2002114859

Trademarks: Wiley, the Wiley Publishing 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 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.

is a trademark of Wiley Publishing, Inc.

About the Authors

Brad Bulger can remember when computers were as big as refrigerators and old-

timers would come into the machine room and call them “mini.” After working for

several companies that no longer exist, he is now a member of The Madfish Group

( http://www.madfishgroup.com ), where he builds Web sites for money. He would

still like to know when the future is going to get here but has a sneaking suspicion

he already knows.

Jay Greenspan is a New York–based writer, editor, and technical consultant. He

has contributed to sites run by Apple Computer and Wired Digital, and is author of

MySQL Weekend Crash Course. He runs Trans-City Productions, Inc. ( http://www.

trans-city.com ), a firm that provides editorial services to high-tech companies.

David Wall is a freelance technical consultant, lecturer, and writer. He specializes

in Linux/Apache/MySQL/PHP (LAMP) servers and in Voice over IP technologies

from IBM and Cisco Systems. His consultancy, David Wall Enterprises ( http://

www.davidwall.com ), has offices in Washington, D.C., and Sydney.

Credits

ACQUISITIONS EDITORS

Debra Williams Cauley

Jim Minatel

PROJECT COORDINATOR

Maridee Ennis

PROJECT EDITORS

Kevin Kent

Neil Romanosky

GRAPHICS AND PRODUCTION

SPECIALISTS

Beth Brooks

Jennifer Click

LeAndra Hosier

Michael Kruzil

TECHNICAL EDITORS

Zak Greant

Bill Patterson

Liz Warner

PERMISSIONS EDITOR

Carmen Krikorian

COPY EDITOR

S. B. Kleinman

MEDIA DEVELOPMENT SPECIALIST

Angela Denny

EDITORIAL MANAGER

Mary Beth Wakefield

PROOFREADING AND INDEXING

TECHBOOKS Production Services

VICE PRESIDENT & EXECUTIVE

GROUP PUBLISHER

Richard Swadley

VICE PRESIDENT AND

EXECUTIVE PUBLISHER

Bob Ipsen

VICE PRESIDENT AND PUBLISHER

Joseph B. Wikert

EXECUTIVE EDITORIAL DIRECTOR

Mary Bednarek

Preface

Welcome. If you are thumbing through these pages, you’re probably considering

writing Web-based applications with PHP and MySQL. If you decide to go with

these tools, you’ll be in excellent company. Thousands of developers — from total

newbies to programmers with years of experience — are turning to PHP and MySQL

for their Web-based projects, and for good reason.

Both PHP and MySQL are easy to use, fast, free, and powerful. If you want to get

a dynamic Web site up quickly, there are no better choices. The PHP scripting lan-

guage was built for the Web. All the tasks common to Web development can be per-

formed in PHP with an absolute minimum of effort. Similarly, MySQL excels at tasks

common to dynamic Web sites. Whether you’re creating a content-management sys-

tem or an e-commerce application, MySQL is a great choice for your data storage.

Is This Book for You?

Quite a few books deal with PHP, and a few cover MySQL. We’ve read some of these

and found a few to be quite helpful. If you’re looking for a book that deals with the

gory details of either of these packages, you should probably look elsewhere.

The focus of this book is applications development. We are concerned with what

it takes to get data-driven Web sites up and running in an organized and efficient

way. The book does not go into arcane detail of every aspect of either of these tools.

For example, in this book you will not find a discussion of PHP’s LDAP functions

or MySQL’s C application program interface (API). Instead, we focus on the pieces

of both packages that affect one another. We hope that by the time you’re done

with this book you’ll know what it takes to get an application up and running using

PHP and MySQL.

How This Book Is Organized

We have organized the book into five parts.

Part I: Working with MySQL

Before you code any PHP scripts you need to know how to design a database, cre-

ate tables in your database, and get the information you want from the database.

Part I of this book shows you just about everything you need to know to work with

MySQL.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: