From: | Kevin Lo <jwlo(at)ms11(dot)hinet(dot)net> |
---|---|
To: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Postgres' DBI(Pg) problems. |
Date: | 1999-01-15 18:08:54 |
Message-ID: | 369F8436.E841EB2B@ms11.hinet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Silvio Emanuel Barbosa de Macedo | 1999-01-15 18:41:34 | Query is too long |
Previous Message | Memphisto | 1999-01-15 14:10:18 | Representation of big integer numbers. |