| From: | Kevin Lo <jwlo(at)ms11(dot)hinet(dot)net> |
|---|---|
| To: | pgsql-interfaces(at)postgreSQL(dot)org |
| Subject: | Help! DBI Pg problems. |
| Date: | 1999-01-16 03:40:52 |
| Message-ID: | 36A00A43.8818D61E@ms11.hinet.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edmund Mergl | 1999-01-16 07:08:03 | Re: make test fails for DBD::Pg |
| Previous Message | jerome | 1999-01-15 17:22:28 | pgaccess connection failed |