Starting Page

Front Matter
Table of Contents
About the Author

MySQL and Perl for the Web

Paul DuBois
Publisher: New Riders Publishing
First Edition August 03, 2001
ISBN: 0-7357-1054-6, 552 pages



MySQL and Perl for the Web guides you through the creation of dynamic and interactive database-backed Web sites that utilize the power of MySQL and Perl. Author Paul DuBois shows you how to use Perl’s DBI database access module,pairing it with the CGI.pm module that allows Web pages and forms to be generated and processed easily.
only for RuBoard - do not distribute or recompile

MySQL and Perl for the Web

About the Author

About the Technical Reviewers

Acknowledgments

Tell Us What You Think

Introduction
   How This Book Is Organized
   Conventions
   Other Information

1. Introduction to MySQL and Perl
   What You’ll Need
   Audience
   Using the Applications in This Book

2. Getting Connected—Putting Your Database on the Web
   Required Tools
   Configuring MySQL
   Configuring Apache
   Writing Perl Scripts
   Error Handling and Debugging
   A Simple Web-Based Application—To-Do List Maintenance
   What You Have Achieved

3. Improving Performance with mod_ perl
   What mod_ perl Is and How It Works
   mod_ perl Configuration
   Writing mod_ perl Scripts

4. Generating and Processing Forms
   Form Anatomy
   A Short Form Element Demonstration
   Form Design Issues

5. Writing Form-Based Applications
   Product Registration
   Using Email from Within Applications
   Running a Giveaway Contest
   Conducting a Poll
   Storing and Retrieving Images
   Electronic Greeting Cards—Send a Friend a Greeting

6. Automating the Form-Handling Process
   Obtaining Database and Table Information
   Generating Form Elements from Lookup Tables and Query Results
   Automating Poll Processing

7. Performing Searches
   Writing a Form-Based Search Application
   Extending the Search Application
   Providing Link-Based Navigation

8. Session Management
   State Maintenance Techniques
   Implementing Session Support
   Expiring Sessions
   Storing User Preferences
   Implementing Resumable Sessions
   When Sessions Aren’t Enough

9. Security and Privacy Issues
   Channels of Information
   Dangers Presented by Remote Users
   Dangers Presented by Local Users
   Network Access and Client Privacy Protection
   Writing a Secure Application

10. E-Commerce Applications
   The Place of a Database in E-Commerce
   Setting Up a Virtual Storefront
   Presenting Static Library Pages
   An Online Document Sales Application
   Collecting Payment Information
   A Cart-Based Sales Application
   Completing the Site
   Suggested Site-Wide Modifications
   Final Thoughts

A. Obtaining Software
   Required Software
   Optional Software
   Installing Software

B. References and Further Reading
   Books
   Online Resources

only for RuBoard - do not distribute or recompile