A Web-Enabled Aircraft Scheduler

Michael Wallette20 Nov. 2002

Project Description:

Web-enabled, database driven aircraft scheduling application using the following components:

MySQL v. 3.23.49 database. Apache v. 1.3.20 web server. Perl v.5.6.1 Scripts. Slackware Linux 8.0 Operating System.

Project Requirements

On-line schedule with 24x7 access.

Automated process with minimal staff intervention required.

Fully integrated web package:

Club information;

Aircraft description;

Membership application;

Flight Instructor contact information;

User administration functionality for club staff.

Inexpensive to build and maintain.

Database Design

Perl and HTML code:

18 HTML documents and 12 Perl scripts.Perl scripts generate HTML code for dynamic pages, like the following:

Site Navigation for Main Program:

Note--Static HTML pages that do not call or respond to CGI scripts have been ommitted.

Site Navigation for Administrative Tools:

Conclusion

What went well in version 1.0: Perl/Apache/MySQL integration. Most user interfaces. Database design.

What to look for in version 2.0: New schedule interface. Cleaner, more optimal Perl code. Pages optimized for typical resolutions (currently, designed

for 800x600, with compromises for other resolutions). Enhanced security.