Category: Databases
Author/Contact Info
Description: Not always there is a handy database shell within reach. Strangely enough, sometimes PLP is :) DBIx::Simple >= 1.24 has a new method: html, which uses DBIx::XHTML_Table.

This script is in use here in case you want to try. (Note: link will die soon.)

<html><body>
<form method=get><input name=q size=80></form>
<:
    use DBIx::Simple; 
    $get{q} and print 
        DBIx::Simple
        -> new("dbi:SQLite:foo.db", undef, undef, { RaiseError => 1 })
        -> query($get{q})
        -> html(table => { border => 1 }, tr => { bgcolor => [qw/white
+ silver/] });
:>
</body></html>