DBIx-XHTML_Table
view release on metacpan or search on metacpan
{
"abstract" : "SQL query result set to XHTML table.",
"author" : [
"jeffa <jeffa@cpan.org>"
],
"dynamic_config" : 1,
"generated_by" : "ExtUtils::MakeMaker version 6.62, CPAN::Meta::Converter version 2.130880",
"license" : [
"artistic_2"
],
"meta-spec" : {
"url" : "http://search.cpan.org/perldoc?CPAN::Meta::Spec",
---
abstract: 'SQL query result set to XHTML table.'
author:
- 'jeffa <jeffa@cpan.org>'
build_requires:
Test::More: 0
configure_requires:
ExtUtils::MakeMaker: 0
dynamic_config: 1
generated_by: 'ExtUtils::MakeMaker version 6.62, CPAN::Meta::Converter version 2.130880'
license: artistic_2
meta-spec:
lib/DBIx/XHTML_Table.pm view on Meta::CPAN
unless ($self->{'keep_alive'}) {
$self->{'dbh'}->disconnect if defined $self->{'dbh'};
}
}
1;
__END__
=head1 NAME
DBIx::XHTML_Table - SQL query result set to XHTML table.
=head1 SYNOPSIS
use DBIx::XHTML_Table;
# database credentials - fill in the blanks
my ($data_source,$usr,$pass) = ();
my $table = DBIx::XHTML_Table->new($data_source,$usr,$pass);
lib/DBIx/XHTML_Table.pm view on Meta::CPAN
select bar,baz from foo
where bar = ?
and baz = ?
');
$table->exec_query($sth,[$foo,$bar]);
Consult the DBI documentation for more details on bind vars.
After the query successfully executes, the results will be
stored interally as a 2-D array. The XHTML table tags will
not be generated until the output() method is invoked.
=item B<output>
$scalar = $table->output([$attribs])
Renders and returns the XHTML table. The only argument is
an optional hash reference that can contain any combination
of the following keys, set to a true value. Most of the
time you will not want to use this argument, but there are
three times when you will:
# 1 - do not display a thead section
print $table->output({ no_head => 1 });
This will cause the thead section to be suppressed, but
not the caption if you set one. The
lib/DBIx/XHTML_Table.pm view on Meta::CPAN
$table->modify(td => {
bgcolor => [qw(red purple blue green yellow orange)],
}),
As the table is rendered row by row, column by column, the
elements of the array reference will be 'rotated'
across the <td> tags, causing different effects depending
upon the number of elements supplied and the number of
columns and rows in the table. The following is the preferred
XHTML way with CSS styles:
$table->modify(th => {
style => {
background => ['#cccccc','#aaaaaa'],
}
});
See the set_row_color() and set_col_color() methods for more info.
The last argument to modify() is optional and can either be a scalar
lib/DBIx/XHTML_Table.pm view on Meta::CPAN
Note the use of the empty string and not undef or 0. Setting
the value to undef will work, but will issue a warning if you
have warnings turned on. Setting the value to 0 will set the
value of the attribute to 0, not remove it.
A final caveat is setting the <caption> tag. This one breaks
the signature convention:
$table->modify(tag => $value, $attrib);
Since there is only one <caption> allowed in an XHTML table,
there is no reason to bind it to a column or an area:
# with attributes
$table->modify(
caption => 'A Table Of Contents',
{ align => 'bottom' }
);
# without attributes
$table->modify(caption => 'A Table Of Contents');
lib/DBIx/XHTML_Table.pm view on Meta::CPAN
specify the names of the columns. Problems have been reported
using 'select *' with SQLServer7 will cause certain 'text' type
columns not to display. I have not experienced this problem
personally, and tests with Oracle and MySQL show that they are not
affected by this. SQLServer7 users, please help me confirm this. :)
=item Not specifying <body> tag in CGI scripts
I anticipate this module to be used by CGI scripts, and when
writing my own 'throw-away' scripts, I noticed that Netscape 4
will not display a table that contains XHTML tags IF a <body>
tag is NOT found. Be sure and print one out.
=back
=head1 CREDITS
Briac [OeufMayo] PilprE<eacute> for the name.
Mark [extremely] Mills for patches and suggestions.
( run in 1.296 second using v1.01-cache-2.11-cpan-49f99fa48dc )