MySQL::Handler Builds upon DBD::mysql for advanced CGI web apps
Download

MySQL::Handler Ranking & Summary

MySQL::Handler Tags

Perl module MySQL handler MySQL handler

MySQL::Handler Description

Builds upon DBD::mysql for advanced CGI web apps MySQL::Handler is a Perl module that builds upon the foundation set by DBI and DBD::mysql to create a superset of methods for tying together some of the basic interface concepts of DB management when used in a web server environment. MySQL::Handler is meant to build upon the strengths of DBD::mysql and DBI and add common usability features for a variety of Internet applications.MySQL::Handler encapsulates error message handling, information message handling, simple caching of requests through a complete iteration of a server CGI request. You will also find some key elements that hook the CGI class to the DBI class to simplify data IO to & from web forms and dynamic pages.SYNOPSIS # Instantiate Object # use MySQL::Handler; my $DB = MySQL::Handler->new(dbname=>'products',dbuser=>'MySQL',dbpass=>'msqlpassword'); # Retrieve Data & List Records # $DB->PrepLEX('SELECT * FROM products'); while ($item=$DB->GetRecord()) { print "$item->{PROD_ID} $item->{PROD_TITLE} $item->{PROD_QTY} "; } # Add / Update Record based on CGI Form # assuming objCGI is an instatiated CGI object # if the CGI param 'prod_id' is set we update # if it is not set we add # my %cgimap; foreach ('prod_id','prod_title','prod_qty') { $cgimap{$_} = $_; } $DB->AddUpdate( CGI=>$objCGI , CGIKEY=>'prod_id', TABLE=>'products', DBKEY=>'prod_id', hrCGIMAP=>\%cgimap ); Requirements: · Perl What's New in This Release: · Fixed problem with SetDH - database handle management.

MySQL::Handler Related Software