DBIx::HTMLinterface 0.11

DBIx::HTMLinterface is a class for creating a CGI interface to a database.

SYNOPSIS

use CGI;
use DBI;
use DBIx::HTMLinterface;

$cgi = new CGI;
$dbh = DBI->connect("DBI:mysql:[DATABASE]:[HOSTNAME]","[USERNAME]","[PASSWORD]") );
$DBinterface = new DBIx::HTMLinterface ($cgi, $dbh, "[INFOTABLE NAME]");

# Below here is only executed if a HTMLinterface action was not taken, so print a menu

print $cgi->header;
print
";
print

The DBIx::HTMLinterface class allows a CGI interface to a database. It enables a CGI interface to a database to be created, supporting record addition, modification, deletion and searching. It provides a user friendly interface with descriptions of fields provided. The field descriptions along with information on whether the field is visible, hidden or excluded are extracted from a table, allowing easy modification and addition of fields and tables without having to edit code.

Features

Simple database administration

Forms are created automatically on demand, SQL statements are generated as needed and processed. The module contains enough autonomy to potentially run with only wrapper perl code placed around it.

Full form configuration

Forms can be modified to add descriptions and extra information to fields, making it easy to change output without having to edit code.

Control

Extensive callback procedures and configuration options allow output, password protection and logging to be configured as desired.

Full HTML customisation

HTML output and table formats can be customised easily by the user.