.com Solutions Inc. - logo  
Products - Header Buttons
.
FmPro Script Diff bullet item 7b FmPro Layout Diff bullet item 7b FmPro Migrator bullet item 7b SQLite Diff
.
.
.
. .

 

 

. .

 

...
.

CGIScripter - MySQL Files Title

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.
   
   

 

.

hline

. .

.

 

. .

 

 

 

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

Legal Notices

.
.   .
.
Home Products Services Downloads Order Support Contact