Help! DBI Pg problems.

Поиск
Список
Период
Сортировка
От Kevin Lo
Тема Help! DBI Pg problems.
Дата
Msg-id 36A00A43.8818D61E@ms11.hinet.net
обсуждение исходный текст
Список pgsql-interfaces
Дерево обсуждения 
Hi,

I'm trying to use Postgres DBI, which is Pg, to write a simple cgi script.
But I encounter a problem, hope anyone can tell me how to do, thanks.

For example:
I have two input forms in ex.html, which names are 'id' and 'student'.
I want to insert them into 'course' table in student database by using Pg.
The script I wrote as following:

#!/usr/local/bin/perl
require 'forms-lib.pl';/* this script gets form values in HTML that I input */
use DBI;
print "Content-type: text/html\n\n";
print "<HTML>\n";
print "<HEAD>\n";
print "<TITLE>Data inserted</TITLE>\n";
print "</HEAD>\n";
%input = &GetFormInput();
$v1 = $input{'id'};
$v2 = $input{'student'};
$dbh = DBI->connect("dbi:Pg:dbname=student") or die $DBI::errstr;
$sth = $dbh->prepare("insert into course values('$v1', '$v2')")
     or die $DBI::errstr;
$sth->execute or  die $DBI::errstr;
print "<BODY>\n";
print "<H1>Data inserted!</H1>\n";
print "</BODY>\n";
print "</HTML>\n";

After executing this script, I just see brower's title "Data inserted",
I can't see "Data inserted!" in HTML and can't insert values into 'course'
table. I don't know how to do, would anyone tell me, thanks in advance.

Best regards,
Kevin.

В списке pgsql-interfaces по дате отправления: