|Table of Contents|
Creating Database Web Applications with PHP and ASP teaches beginning and intermediate designers the fundamentals of creating complex Web applications. By covering both open source (PHP/MySQL) and proprietary tools (Microsoft ASP and Access), readers gain insight to the strengths and weaknesses of each. In addition, they learn how to work with both sets of tools and determine which works best for their projects. Practical examples, including a shopping cart and quiz show, are used to teach the basic concepts behind creating and testing database code. Every example is also provided in both PHP and ASP for easy comparison and use. With the knowledge and experience gained here, beginners will learn the fundamental concepts behind these two technologies, while more experienced developers will learn which technology works best for their specific needs. Exercises, questions, and projects are included with each chapter.
Whom this book is for
About the Author
Jeanine Meyer, Mt. Kisco, NY, has a Ph.D. in computer science from New York University. She is currently an Associate Professor at Purchase College, SUNY, where she teaches computer science and New Media courses including Programming Games and Creating Databases for Web Applications. She is also the co-author of Multimedia in the Classroom and Programming Games using Visual Basic.
Creating Database Web Applications with PHP and ASP
Charles River Media, Inc.
Copyright 2003 by CHARLES RIVER MEDIA, INC.
All rights reserved.
No part of this publication may be reproduced in any way, stored in a retrieval system of any type, or transmitted by any means or media, electronic or mechanical, including, but not limited to, photocopy, recording, or scanning, without prior permission in writing from the publisher.
Associate Acquisitions Editor: James Walsh
Production: Publishers’ Design and Production Services
Cover Design: The Printed Image
CHARLES RIVER MEDIA, INC.
10 Downer Avenue
Hingham, Massachusetts 02043
This book is printed on acid-free paper.
Jeanine Meyer. Creating Database Web Applications with PHP and ASP.
All brand names and product names mentioned in this book are trademarks or service marks of their respective companies. Any omission or misuse (of any kind) of service marks or trademarks should not be regarded as intent to infringe on the property of others. The publisher recognizes and respects all marks used by companies, manufacturers, and developers as a means to distinguish their products.
Library of Congress Cataloging-in-Publication Data
Creating database Web applications with PHP and ASP / Jeanine Meyer.
1. Web databases. 2. PHP (Computer program language) 3. Active
server pages. 4. Application software—Development. I. Title.
Printed in the United States of America
03 7 6 5 4 3 2 First Edition
CHARLES RIVER MEDIA titles are available for site license or bulk purchase by institutions, user groups, corporations, etc. For additional information, please contact the Special Sales Department at 781-740-0400.
Requests for replacement of a defective CD-ROM must be accompanied by the original disc, your mailing address, telephone number, date of purchase and purchase price. Please state the nature of the problem, and send the information to CHARLES RIVER MEDIA, INC., 10 Downer Avenue, Hingham, Massachusetts 02043. CRM’s sole obligation to the purchaser is to replace the disc, based on defective materials or faulty workmanship, but not on the operation or functionality of the product.
To my father Joseph Louis Minkin 1913-2002
Many people helped in the creation and production of this book (but are not responsible for any errors): Michael Conry built and maintained the server for the first and subsequent offerings of the course; Gretchen Culp worked on her fish of the Hudson River project, which stimulated us to work harder; Anne Kellerman read and gave suggestions on the text; Connie Knapp taught me how to teach databases; Stephanie Lee has been an excellent student and teaching assistant in multiple courses; Amit Mangal was the official reviewer and provided many helpful suggestions; Aviva Meyer kept me from devolving and helped in many ways; Esther Minkin fed me oatmeal on very cold days and serenaded me by playing the piano; Marge Oztunali gave technical advice and support; Alexander Pinnock rescued me when my hard drive crashed; and Jenifer Niles, Jim Walsh, Bryan Davidson, and others at Charles River Media provided the highest level of support and guidance for this author. Thanks to all my students and colleagues at Purchase College/SUNY.
THE CD-ROM WHICH ACCOMPANIES THE BOOK MAY BE USED ON A SINGLE PC ONLY. THE LICENSE DOES NOT PERMIT THE USE ON A NETWORK (OF ANY KIND). YOU FURTHER AGREE THAT THIS LICENSE GRANTS PERMISSION TO USE THE PRODUCTS CONTAINED HEREIN, BUT DOES NOT GIVE YOU RIGHT OF OWNERSHIP TO ANY OF THE CONTENT OR PRODUCT CONTAINED ON THIS CD-ROM. USE OF THIRD PARTY SOFTWARE CONTAINED ON THIS CD-ROM IS LIMITED TO AND SUBJECT TO LICENSING TERMS FOR THE RESPECTIVE PRODUCTS.
CHARLES RIVER MEDIA, INC. (“CRM”) AND/OR ANYONE WHO HAS BEEN INVOLVED IN THE WRITING, CREATION, OR PRODUCTION OF THE ACCOMPANYING CODE (“THE SOFTWARE”) OR THE THIRD PARTY PRODUCTS CONTAINED ON THE CD-ROM OR TEXTUAL MATERIAL IN THE BOOK, CANNOT AND DO NOT WARRANT THE PERFORMANCE OR RESULTS THAT MAY BE OBTAINED BY USING THE SOFTWARE OR CONTENTS OF THE BOOK. THE AUTHOR AND PUBLISHER HAVE USED THEIR BEST EFFORTS TO ENSURE THE ACCURACY AND FUNCTIONALITY OF THE TEXTUAL MATERIAL AND PROGRAMS CONTAINED HEREIN; WE, HOWEVER, MAKE NO WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, REGARDING THE PERFORMANCE OF THESE PROGRAMS OR CONTENTS. THE SOFTWARE IS SOLD “AS IS” WITHOUT WARRANTY (EXCEPT FOR DEFECTIVE MATERIALS USED IN MANUFACTURING THE DISC OR DUE TO FAULTY WORKMANSHIP).
THE AUTHOR, THE PUBLISHER, DEVELOPERS OF THIRD PARTY SOFTWARE, AND ANYONE INVOLVED IN THE PRODUCTION AND MANUFACTURING OF THIS WORK SHALL NOT BE LIABLE FOR DAMAGES OF ANY KIND ARISING OUT OF THE USE OF (OR THE INABILITY TO USE) THE PROGRAMS, SOURCE CODE, OR TEXTUAL MATERIAL CONTAINED IN THIS PUBLICATION. THIS INCLUDES, BUT IS NOT LIMITED TO, LOSS OF REVENUE OR PROFIT, OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OF THE PRODUCT.
THE SOLE REMEDY IN THE EVENT OF A CLAIM OF ANY KIND IS EXPRESSLY LIMITED TO REPLACEMENT OF THE BOOK AND/OR CD-ROM, AND ONLY AT THE DISCRETION OF CRM.
THE USE OF “IMPLIED WARRANTY” AND CERTAIN “EXCLUSIONS” VARY FROM STATE TO STATE, AND MAY NOT APPLY TO THE PURCHASER OF THIS PRODUCT.