Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

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

by kiat (Vicar)
on Nov 25, 2003 at 13:25 UTC ( [id://309887]=note: print w/replies, xml ) Need Help??


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

Thanks, Brad!

I was referring to storing just the content (minus the html) in the database.

To reiterate your points: It's pretty the normal thing to do these days to store content in the database and have a perl script pull out the content and display it via HTML:Template.

Is that right?

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

Replies are listed 'Best First'.
Re: Re: Re: pulling content from db - is it a good idea?
by bradcathey (Prior) on Nov 25, 2003 at 13:53 UTC
    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://309887]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (3)
As of 2024-04-24 21:05 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found