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

NAME

LibWeb::Database - A generic database driver for libweb applications


SUPPORTED PLATFORMS

BSD, Linux, Solaris and Windows.


REQUIRE

  • DBI


ISA

  • LibWeb::Core


SYNOPSIS

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

   my ($sql, $user, $host, $fetch, $result);
   $sql = "select USER_NAME, USER_HOST ".
          "from USER_TABLE ".
          "where USER_LOGIN_STATUS = ".
          "LOGIN_INDICATOR";
 

   $fetch = $db->query(
                        -sql => $sql,
                        -bind_cols => [\$user, \$host]
                      );
 

   while ( &$fetch ) {
       $result .= "$user $host <BR>\n";
   }
 

   $db->done();
 

   print "Content-Type: text/html\n\n";
   print "<P> The following users have logged in: $result";
 


ABSTRACT

As long as you have the proper DBD installed for your database, you can use this class to interact with your database in your LibWeb applications.

The current version of LibWeb::Database 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

do()

Params:

   -sql => 
 

Pre:

  • -sql is a valid sql statement.

Post:

  • Return the number of rows affected by the SQL statement, -sql.

query()

Params:

   -sql=>, -bind_cols=> [, -want_hash=> ]
 

Pre:

  • -sql is the sql statement to perform the query,

  • -bind_cols is an ARRAY reference to SCALAR references to fields to be bound in the table specified in -sql,

  • -want_hash indicates whether the returning function (a reference) is a reference to DBI's fetchrow_hashref() or fetchrow_arrayref().

Post:

  • Returns a reference to a fetching function based on -sql. A reference to DBI's fetchrow_arrayref() is returned if -want_hash is not defined; otherwise a reference to DBI's fetchrow_hashref() is returned.

finish()

Finish a statement execution.

disconnect()

Disconnect the current database session.

done()

Finish a statement execution and disconnect the current database session.


AUTHORS

Colin Kong (colin.kong(at)utoronto.ca)


CREDITS


BUGS


SEE ALSO

DBI, LibWeb::Core.



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