DBIx::HTMLinterface 0.11 reviewDownload
DBIx::HTMLinterface is a class for creating a CGI interface to a database. SYNOPSIS use CGI; use DBI; use DBIx::HTMLinterf
DBIx::HTMLinterface is a class for creating a CGI interface to a database.
$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 "url . "?HTMLinterface-table=[TABLENAME]&HTMLinterface-action=add>Addn";
print "url . "?HTMLinterface-table=[TABLENAME]&HTMLinterface-action=search>Searchn";
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.
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.
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.
DBIx::HTMLinterface 0.11 search tags