CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: Intermediate:
Database driven websites with Perl

 



andrew_b
stranger

Jul 25, 2002, 10:02 AM

Post #1 of 2 (509 views)
Database driven websites with Perl Can't Post

I'd like to start a discussion about how people are creating database driven websites using Perl.

I've been writing Perl CGI scripts that query a database with form posted data and return dynamic content. I have a project coming up where *all* of the pages will contain dynamic content.

I am especially interested in techniques that separate HTML from code. (I currently use HTML::Template which does a nice job of this.)

Are people using mod_perl for this?


Paul
Enthusiast

Jul 25, 2002, 4:35 PM

Post #2 of 2 (502 views)
Re: [andrew_b] Database driven websites with Perl [In reply to] Can't Post

>>
Are people using mod_perl for this?
<<

Yep, I'm nearing the end of a help desk project to be located at supportsql.com, the helpdesk is fully OO with custom modules such as a template parser, SQL module, tar module, dumper module and much more...its around 1.2MB in size and 2.8MB including images.

It has been tested with mod_perl 1.26 and works well (v. quick)....it requires Apache::DBI for persistent database connections.

The template parser is very advanced allowing great flexibility when retrieving things from the database...eg...

my $arrayref = $sth->fetchall_arrayref({});

...I just need to put:

<%loop tag_name%>
<%endloop%>

...into my template and pass $arrayref into my parser and all the output is produced dynamically.

Inside that loop I can put any html or mysql column names and the output is dynamically generated.


(This post was edited by RedRum on Jul 25, 2002, 4:37 PM)

 
 


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives