use Win32::ODBC;
print "Content-type: text/html\n\n";
read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});
@pairs = split(/&/, $buffer);
foreach $pair (@pairs)
{
($name, $value) = split(/=/, $pair);
$value =~ tr/+/ /;
$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
$FORM{$name} = $value;
}
print "\n";
print "\n";
print "Testing Database Code\n";
print "\n";
print "\n";
$DSN="CodeTestMySQL";
if (!($db=new Win32::ODBC($DSN))) {
print "Error connecting to $DSN\n";
print "Error: " . Win32::ODBC::Error() . "\n";
}
else {
print "Information being added to the University of Minnesota Federal Small Business Self-Certification Database.
\n";
}
$currentdate = ¤tdate;
$SqlStatement = insert into people values('$FORM_DATA{'first_name'}','$FORM_DATA{'last_name'}','$currentdate');
sub currentdate {
local $currentdate = $FORM_DATA{'year'}."-".$FORM_DATA{'month'}."-".$FORM_DATA{'day'};
return $currentdate;
}
if ($db->Sql($SqlStatement)) {
print "SQL failed.\n";
print "Error: " . $db->Error() . "\n";
}