Re: Web Tools
От | J J |
---|---|
Тема | Re: Web Tools |
Дата | |
Msg-id | 370E3A18.2F302134@hotmail.com обсуждение исходный текст |
Ответ на | Web Tools ("Ronald L. Chichester" <complaw@hal-pc.org>) |
Список | pgsql-general |
Ronald L. Chichester wrote: > Hi: > > I want to use PostgreSQL as a database engine for a web-based intranet > (using Apache on Linux). Is there a repository of CGI examples that I > could use, or are there some software tools that could take out some of > the time and grunt work? > > Thanks in advance, > > Ron Chichester This uses the built in "print a HTML table row" function: #!/usr/bin/perl -w use Pg; use CGI; $wp = new CGI; $custname = uc $wp->param('custname'); print $wp->header; print $wp->start_html(-author=>"jj"); $conn = Pg::connectdb("dbname = john"); if ($conn->status != PGRES_CONNECTION_OK) { die("Can't connect"); } $res = $conn->exec("select * from workorder where name like '%$custname%'"); #fout, header, align, standard, html3, expanded, pager, fieldSep, tableOpt, caption, ... $res->print (STDOUT, "", "", 0, 1, 0, 0, "|", "border=1", "Customers"); print $wp->end_html;
В списке pgsql-general по дате отправления: