in reply to Re: Re: pulling content from db - is it a good idea?
in thread pulling content from db - is it a good idea?

Yup, common as dirt. There are several Tutorials here at the Monastery. Here's a taste of how it works:

The HTML (has to be saved with .tmpl extension):
<tr> <td><span class="header"> <!-- placeholder --> <tmpl_var name=listfor>'s List </span> </td> </tr> <tr> <td> <!-- placeholder --> <tmpl_var name="list"> </td> </tr>
The Perl:
use HTML::Template; #tell H-T what page to display $template = HTML::Template -> new(filename => "displaylists.tmpl"); + #connect to DB, SELECT, etc. then... @data = $sth->fetchrow_array(); #assign data to placeholders $template ->param(listfor => $data[1], list=> $data[2]); print "Content-type: text/html\n\n"; print $template->output; #display html
It's pretty easy once you get the hang of it. And the HTML designers will appreciate not having their design packed away in some Perl script.

—Brad
"A little yeast leavens the whole dough."