Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: Re: pulling content from db - is it a good idea?

by bradcathey (Prior)
on Nov 25, 2003 at 13:53 UTC ( [id://309893]=note: print w/replies, xml ) Need Help??


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."

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://309893]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others perusing the Monastery: (7)
As of 2024-04-23 11:51 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found