LibWeb::Database::Mysql - Mysql database API for libweb applications
- BSD, Linux, Solaris and Windows.
-
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.";
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
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.
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:
- Colin Kong (colin.kong(at)utoronto.ca)
-
LibWeb::Database.
|