NAME

LibWeb::Database::Mysql - Mysql database API for libweb applications

SUPPORTED PLATFORMS

BSD, Linux, Solaris and Windows.

REQUIRE

No non-standard Perl's library is required.

ISA

LibWeb::Database

SYNOPSIS

  use LibWeb::Database::Mysql;
  my $db = new LibWeb::Database::Mysql();

  my ($where, $count);

  $where = 'LOGIN_STATUS = LOGGED_IN';
  $count = $db->get_count(
                           -table => USER_TABLE,
                           -where => $where
                         );

  print "Content-Type: text/html\n\n";
  print "$count users have logged in.";

ABSTRACT

This class provides enhanced support to MySQL database interaction in you LibWeb applications. This class also ISAs LibWeb::Database so you can use all the methods provided in LibWeb::Database via objects created from this class. See the LibWeb::Database manpage. This module is still in the stage of planning as you can tell from the number of methods available.

The current version of LibWeb::Database::Mysql is available at

   http://libweb.sourceforge.net

Several LibWeb applications (LEAPs) have be written, released and are available at

   http://leaps.sourceforge.net

TYPOGRAPHICAL CONVENTIONS AND TERMINOLOGY

Variables in all-caps (e.g. USER_TABLE) are those variables set through LibWeb's rc file. Please read the LibWeb::Core manpage for more information. Method's parameters in square brackets means optional.

DESCRIPTION

METHODS

get_count()

Params:

  -table =>, -where =>

Pre:

-table is a scalar indicating a database table's name,
-where is a scalar describing the `where' phrase of a SQL query.

Post:

Return the number of counts satisfying the criteria specified in the -where parameter.

AUTHORS

Colin Kong (colin.kong@toronto.edu)