LibWeb::Database::Mysql - Mysql database API for libweb applications
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
Several LibWeb applications (LEAPs) have be written, released and are available at
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.
-table =>, -where =>
-tableis a scalar indicating a database table's name,
-whereis a scalar describing the `where' phrase of a SQL query.