File Coverage

blib/lib/HTML/DBForm.pm

Criterion	Covered	Total	%
statement	46	230	20.0
branch	3	58	5.1
condition	0	11	0.0
subroutine	11	37	29.7
pod	4	5	80.0
total	64	341	18.7

package HTML::DBForm;

use strict;
use warnings;
no warnings 'uninitialized';

use Carp;
use CGI;
use HTML::Template;
use HTML::SuperForm;
use DBI;

our $VERSION = '1.05';


=head1 NAME

HTML::DBForm - Creates a web interface for updating database tables

=head1 SYNOPSIS

    use HTML::DBForm;
    use HTML::DBForm::Search;

    my $editor = HTML::DBForm->new(
        table       => 'contacts',
        primary_key => 'id',
    );

    $editor->element(column => 'email');

    $editor->element(
        label  => 'First Name',
        column => 'fname',
    );

    $editor->element(
        column  => 'interest',
        type    => 'select',
        options => \@list_of_interests
    );

    $editor->element(
        label   => 'Reason for Contact',
        column  => 'reason',
        options => 'select reason from reasons'
    );

    $editor->connect(
        username   => 'webuser',
        password   => 'xxxxxxx',
        datasource => 'dbi:mysql:dbname'
    );

    $search = HTML::DBForm::Search->new('dropdown',
        { columns => ['id', 'lname'] }
    );

    $editor->run(search => $search);


=head1 INTRODUCTION

  HTML::DBForm provides a web interface to insert, update, and delete
  rows from a database. This can be used to easily create content editors
  for websites, content management systems, or anything that stores its
  data in a database.

  HTML::DBForm allows easy creation of simple admin screens, but is
  flexable enough to use in many different situations.

=cut

=head1 METHODS

=over 4

=cut

=head2 new

Creates a new editor object.

Required parameters:

I the table we are creating a form to update 




87




 





 





 





 





 





 



   




88




 





 





 





 





 





 



 I the primary key of this table. Caveat Programmor: There is  




89




 





 





 





 





 





 



 no checking done to enforce that the column provided as I is  




90




 





 





 





 





 





 



 a primary key.  




91




 





 





 





 





 





 



   




92




 





 





 





 





 





 



 Optional parameters: 




93




 





 





 





 





 





 



   




94




 





 





 





 





 





 



 I the URL to a custom stylesheet file.   




95




 





 





 





 





 





 



   




96




 





 





 





 





 





 



 I

I the primary key of this table. Caveat Programmor: There is
no checking done to enforce that the column provided as I is
a primary key.

Optional parameters:

I the URL to a custom stylesheet file.

I