FmPro Migator VFP Code Converter FmPro Script Diff SQLite Diff Screenshot Toolbar Printer Maintainer

CGIScripter Demo Available for download...

CGIScripter creates 15 files (including Perl, HTML, and SQL code) for each form which has been defined within the CGIScripter application. This page provides descriptions of the generated output files, links to sample files created by CGIScripter and flowcharts for Perl CGI script processing. Click on the link to the example filename to see the output file generated by CGIScripter.

Filename	Features
example_instructions.txt	This file contains the setup, usage and troubleshooting instructions for the Perl CGI scripts generated by CGIScripter.
example_create_table1.sql	This SQL script creates the MySQL table for the web application data. Notes: The MySQL DBA should review and update the DDL code within this file prior to creating the table. The MySQL VARCHAR column widths should be reduced to the maximum size actually used within the web application.
example_submit1.html                 Submit Form Flowchart	This HTML submit page POSTs information to the example_submit1 CGI script.
example_submit1	This Perl program accepts web submitted form data, provides data validation and auto-enter processing, then writes the entered data into the database.
example_query1.html                  Query Form Flowchart	This HTML query page POSTs information to the example_query1 CGI script.
example_query1                                 Sample Query List	This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_display_record1            Sample Display Record	This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_update1.html                Update Form Flowchart	This HTML update page POSTs information to the example_update1 CGI script.
example_update1                               Sample Update List	This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_update_record1             Sample Update Record cgiscripter_mysql_update_form.zip	This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database with updatable fields. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser. The cgiscripter_mysql_update_form.zip file includes example Perl code files, HTML files and flowchart files in gif, png and VISIO formats for the Update Form.
example_update_record_validate1	This Perl program accepts web submitted form data from the update script, provides data validation then updates the specified record in the database.
example_delete1.html                  Delete Form Flowchart	This HTML update page POSTs information to the example_delete1 CGI script.
example_delete1                                 Sample Delete List	This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_delete_record_display1    Sample Delete Record	This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_delete_one_record1	This Perl program accepts the primary key value passed in via an HTTP POST then deletes that one record from the database. For security reasons the primary key column name is hard coded into this script. Also, the referer URL must match the Display Record Script - or the record will not be deleted.

 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices