LibWeb -- a vanilla web site backend current version: 0.02  
Home | Requirements | Features | Documentation | Downloads | License
  Sourceforge
Control panel
CVS
News
Bug Tracking
Mailing lists
Message forums
Downloads

  Sponsors
SourceForge.net
Documentation:

LibWeb::Database::Mysql

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 LibWeb::Database. 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 LibWeb::Core 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(at)utoronto.ca)


CREDITS


BUGS


SEE ALSO

LibWeb::Database.



Copyright © 2000-2002 LibWeb.
All trademarks and copyrights on this page are properties of their respective owners. Forum comments are owned by the poster.