Table of Contents


creating database web applications with php and asp
Creating Database Web Applications with PHP and ASP
by Jeanine Meyer  ISBN:1584502649
Charles River Media © 2003 (409 pages)

This informative text teaches beginning and intermediate designers the fundamentals of creating complex Web applications and teaches the basic concepts behind creating and testing database code.

has cd content

Table of Contents
Creating Database Web Applications with PHP and ASP
Preface
Chapter 1 - Introduction
Chapter 2 - Basic HTML
Chapter 3 - HTML Forms and Client-Side JavaScript
Chapter 4 - Server-Side Basics
Chapter 5 - Database Basics
Chapter 6 - Analysis and Design of Applications
Chapter 7 - Structured Query Language
Chapter 8 - Database Management Systems: MySQL and Access
Chapter 9 - Connecting to the Database
Chapter 10 - Connecting to a Database: Advanced
Chapter 11 - Regular Expressions
Chapter 12 - Files
Chapter 13 - Cookies and Session Variables
Chapter 14 - Shopping Cart
Chapter 15 - Quiz Show
Chapter 16 - Scaling Up Your Application
Chapter 17 - Emerging Trends
Appendix A - Running ASP and PHP Scripts on Your Own Computer
Appendix B - About the CD-ROM
Bibliography
Index
List of Figures
List of Tables
cd content CD Content


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

  • Students learning how to create databases for Web applications (some knowledge of HTML and JavaScript is assumed)
  • Beginner or intermediate Web designers who want to learn how to add database applications to their sites using either PHP or ASP tools

Topic Highlights

  • Basic Web technologies (HTML and JavaScript)
  • Client-side versus server-side programming
  • Database design and planning
  • SQL fundamentals
  • Form handling
  • Passing information using query strings
  • Cookies and session variables
  • Validating user input using regular expressions

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

Jeanine Meyer

Charles River Media, Inc.
Hingham, Massachusetts

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
781-740-0400
781-740-8816 (FAX)
info@charlesriver.com
www.charlesriver.com

This book is printed on acid-free paper.

Jeanine Meyer. Creating Database Web Applications with PHP and ASP.
ISBN: 1-58450-264-9

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

Meyer, Jeanine.
  Creating database Web applications with PHP and ASP / Jeanine Meyer.
      p. cm.
  ISBN 1-58450-264-9
  1. Web databases.  2. PHP (Computer program language)  3. Active
server pages.  4. Application software—Development.  I. Title.
  QA76.9.W43M49 2003
  005.75'8—dc21
2003007395

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

Acknowledgments

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.