MySQL::HandlerBuilds upon DBD::mysql for advanced CGI web apps | |
Download |
MySQL::Handler Ranking & Summary
Advertisement
- License:
- GPL
- Price:
- FREE
- Publisher Name:
- Cyber Sprocket Labs
- Publisher web site:
- http://search.cpan.org/~csa/
MySQL::Handler Tags
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