There are many ways of addressing this issue. The following is not the best, but it works. I have a form where teachers can enter lesson plans and a series of check boxes represent the appropriate grade levels, K through 12. The checkboxes are named GradeK, Grade1, ... Grade12.

When this data is sent via CGI, the parameter is sent to the script as GradeK=on (or whatever value you set the checkbox at). No checkbox parameter is sent if it's not checked. Therefore, I use the following sub to pull the data: 

sub getGrades {
    my $grades;
    my @keys = $template->param;

    # Look for the grade parameters and add each one to $grades
    foreach (@keys) {
        $grades .= $1 . ',' if /^Grade([1-9]|1[0-2]|K)$/;
    }
    $grades =~ s/,$//; # remove trailing comma
    return $grades;
}

[download]
This sub is called from the following sub which uses DBI to write the data to a MySQL database: 
sub storeData {
    my $table = shift;

    my $grades    = getGrades();
    my $standards = getStandards();

    use DBI;
    my $dbh = DBI->connect("DBI:mysql:$database",$user,$password);
    $dbh->{RaiseError} = 1;

    # save template information to database

    my $sql = 'INSERT INTO ' . $table . '(title,  lesson_summary,
                                              grades, standards) 
                                    VALUES (?, ?, ?, ?)';
    my $sth = $dbh->prepare($sql);

    $sth->execute(
      $template->param('Title'), 
      $template->param('Summary'),
      $grades, 
      $standards
    );
    
    $template->end_html;
    $sth->finish;
    $dbh->disconnect;

    print $template->redirect('http://www.someserver.com/some/path/tha
+nks.html');
}

[download]
This should give you a good start on how to approach this (Grades is defined as varchar(28), by the way).

Cheers,
Ovid

In reply to Re: How do I use a database and handle checkboxes? by Ovid
in thread How do I use a database and handle checkboxes? by scratch

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.