while (<>) {  
    my $quantity = param("quantity");
    my $gross_sales = param("gross_sales");
    my $sql = qq/
       insert into transaction_details(quantity, gross_sales)
             values($quantity, $gross_sales)
        /;
     my $rv = $dbh->do($sql);
     # check return value, etc.
}