HTML::Template::Associate::DBI - HTML::Template::Associate DBI plugin
This class is not intended to be used directly but rather through a HTML::Template::Associate. It provides concrete class functionality. use DBI; use HTML::Template; use HTML::Template::Associate; #initiliaze your $dbh ... my $results_foo = $dbh->selectall_hashref ( 'SELECT foo FROM bar WHERE baz = ?', 'foo_id', {}, $baz ); my $results_bar = $dbh->selectall_hashref ( 'SELECT foo, bar FROM bar WHERE baz = ?', [ 'foo_id', 'bar_id' ] , {}, $baz ); my $results_moo = $dbh->selectrow_hashref ( 'SELECT x, y FROM z LIMIT 1' ); my @results_array = $dbh->selectrow_array ( 'SELECT x FROM z' ); my $associate = HTML::Template::Associate->new( { target => 'DBI', create => [ { results => $results_foo, name => 'my_loop', type => 'selectall_hashref' }, { results => $results_bar, name => 'my_other_loop', type => 'selectall_hashref' }, { results => $results_moo, type => 'selectrow_hashref', name => 'my_params' }, { results => \@results_array, type => 'selectrow_array', name => 'my_array_params' } ] } ); my $template = HTML::Template->new ( filename => 'test.tmpl', associate => [ $associate ], die_on_bad_params => 0 ); print $template->output(); #sample.tmpl <!-- TMPL_LOOP NAME="my_loop" --> Foo is:<!-- TMPL_VAR NAME="foo" --> <!-- /TMPL_LOOP --> <!-- TMPL_LOOP NAME="my_other_loop" --> Foo is:<!-- TMPL_VAR NAME="foo" --> Bar is:<!-- TMPL_VAR NAME="bar" --> <!-- /TMPL_LOOP --> x is:<!-- TMPL_VAR NAME="my_params.x" --> y is:<!-- TMPL_VAR NAME="my_params.y" --> x via $dbh->selectrow_array is:<!-- TMPL_VAR NAME="my_array_params.0 -->
This class is not intended to be used directly but rather through a HTML::Template::Associate. It provides concrete class functionality, it will take specific DBI method results and reconstruct data structure to the one appropriate for use by the HTML::Template. Supported DBI method types * selectall_hashref * selectrow_hashref * fetchall_hashref * fetchrow_hashref * selectall_arrayref * selectcol_arrayref * selectrow_array * selectrow_arrayref * fetchrow_array * fetchrow_arrayref * fetchall_arrayref
Initializes the mapper
Transform using selectall_hashref return format.
Transform using selectrow_hashref return format.
Transform using selectall_arrayref return format.
Transform using selectcol_arrayref return format.
If you find any please report to author.
See License.
Alex Pavlovic alex.pavlovic@taskforce-1.com http://www.taskforce-1.com
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of the license can be found in the LICENSE file included with this module.
HTML::Template::Associate HTML::Template::Associate::FormValidator perl(1).
1 POD Error
The following errors were encountered while parsing the POD:
You forgot a '=back' before '=head1'
To install HTML::Template::Associate, copy and paste the appropriate command in to your terminal.
cpanm
cpanm HTML::Template::Associate
CPAN shell
perl -MCPAN -e shell install HTML::Template::Associate
For more information on module installation, please visit the detailed CPAN module installation guide.