Maxscape::Database::DBQueryForm Package

Synopsis

use Maxscape::Database::DBQueryForm;

Description

The Maxscape::Database::DBQueryForm package implements a generic web form to query database tables.

List of Member Functions

1. addRecord
2. changeRecords
3. close
4. deleteRecords
5. displayDatabases
6. displayMenue
7. displayTableQuery
8. displayTableQueryActionMenu
9. displayTables
10. escapeTableName
11. execFormInContext
12. execHREFinContext
13. new
14. promptRecord
15. promptTable
16. queryTable
17. queryTableActionMenu
18. registerTable

Member Functions

new

Synopsis

my $PageAdmin = Maxscape::Database::DBQueryForm->new (%P);

Description

Creates a Maxscape::Database::DBQueryForm object.

displayMenue

Synopsis

my $Text = $DBQueryForm->displayMenue();

Description

Displays a menu.

queryTableActionMenu

Synopsis

my $Text = $DBQueryForm->queryTableActionMenu (%P);

Description

Returns a part of the submit button bar.

displayTableQueryActionMenu

Synopsis

my $Text = $DBQueryForm->displayTableQueryActionMenu (%P);

Description

Returns a part of the submit button bar.

execFormInContext

Synopsis

my $Text = $DBQueryForm->execFormInContext();

Description

Returns context data as hidden input fields.

execHREFinContext

Synopsis

my $Text = $DBQueryForm->execHREFinContext ($Function, $Database, $AnchorText);

Description

Returns an hyperlink.

displayDatabases

Synopsis

my $Text = $DBQueryForm->displayDatabases();

Description

Displays the tables of a database.

promptTable

Synopsis

my $Text = $DBQueryForm->promptTable();

Description

Prompts for a database table row.

registerTable

Synopsis

my $Error = $DBQueryForm->registerTable();

Description

Registers a table.

displayTables

Synopsis

my $Text = $DBQueryForm->displayTables ($P);

Description

Dispays a table.

escapeTableName

Synopsis

my $TableName = $DBQueryForm->escapeTableName ($TableName);

Description

queryTable

Synopsis

my $Text = $DBQueryForm->queryTable();

Description

Returns the query form.

displayTableQuery

Synopsis

my $Text = $DBQueryForm->displayTableQuery();

Description

Displays a query result.

promptRecord

Synopsis

my $Text = $DBQueryForm->promptRecord ($P);

Description

Prompts a table record.

addRecord

Synopsis

my $Text = $DBQueryForm->addRecord ($P);

Description

Adds a table record.

deleteRecords

Synopsis

my $Text = $DBQueryForm->deleteRecords ($P);

Description

Deletes table records.

changeRecords

Synopsis

my $Text = $DBQueryForm->changeRecords ($CGI);

Description

Changes table records.

close

Synopsis

$DBQueryForm->close ();

Description

Closes a connection to the database.

1