Integrating Databases and Templates to Buils Sites - Questions about how to do the above

They have: 2 posts

Joined: Apr 1999

Does any body know of a program that allows you to build a website from templates with integration with a database?

I'll explain exactly what I want to do:

For my news section I want to be able to keep the main text of my articles in html (this is so that I can have hyperlinks) in a database, either mySQL or flatfile.

Then I create my templates for my different sections and put a tag/script/whatever I need to do to, so that my main body can be inserted as well as wherever else I want to put in such as header/footers with ssi's.

Then, I press build and I get my whole site is built. This way I have static pages for indexing and faster user access then dynamically building all the content.

The program/cgi/perl script should run on Linux.

I am a complete beginner so anything should be explained using the KISS* system pretty please.

*keep it simple stupid Smiling

They have: 5,633 posts

Joined: Jan 1970

this is one of the simpliest things you can do with perl!
it only needs a html-form to put your contents in and a perl-script writing these and the rest (head, foot) in a .html file, done! Smiling
if i were you, i'd either learn to program in perl or ask somebody to do this for me...
but it's not that different and will, no matter if you intend to program or not, have to learn some basics about perl to configure your scripts to your system!
cu
patrick

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.