I don't see how using Access and ASP is easier than MySQL and Perl/PHP. Plus, this should depend on whether the OP's friend is using this on a Windows host or a *NIX host (the latter of which is probably more likely).
Lothar, the way this works is there are two files that must be created: the HTML file (which displays the form), and the Perl/PHP file (which takes the data from the form and puts it into a database or somewhere else--for this, I'd say a text file would be fine). If you want to use a database, you'll also need to create one, but again I think it's absolutely unnecessary for a script this simple. Incidentally, the HTMl file and Perl/PHP file can be combined into one, so let me write that up real quick.
Put this on your webserver somewhere and give it an extension of cgi (e.g. "form.cgi"):
Here's a link to the source that's properly formatted:
http://eudean.com/form.txt
--------------------------------------------------------
#!/usr/bin/perl
use CGI;
my $cgi = new CGI;
print $cgi->header;
print <<END;
<html><head><title>Information Form</title></head>
<body>
END
my $file = "records.txt";
if ($cgi->param('submit')) {
if (-s $file > 100000000) {
print "Too many records.";
} else {
open(FH, ">>$file");
print FH join("\n", "Name: " . $cgi->param('name'), "Address: " . $cgi->param('address'), "Phone: " . $cgi->param('phone'), "E-mail: " . $cgi->param('email'), "Interest: " . $cgi->param('interest')) . "\n\n";
close(FH);
chmod 0700, $file;
print "Thank you for responding. If you've expressed interest, we may contact you in the future.";
}
} else {
my $url = $cgi->url(-relative=>1);
print <<END;
<form action="$url" method="POST">
<table>
<tr><td>Name:</td><td><input type="text" name="name"></input></td></tr>
<tr><td>Address:</td><td><input type="text" name="address"></input></td></tr>
<tr><td>Phone:</td><td><input type="text" name="phone"></input></td></tr>
<tr><td>E-mail:</td><td>input type="text" name="email"></input></td></tr>
<tr><td>Are you interested in ...?</td><input type="radio" name="interest" value="Yes">Yes</input> <input type="radio" name="interest" value="No">No</input></td></tr>
</table>
<input type="submit" name="submit" value="Submit"></input> <input type="reset" value="Reset"></input>
END
}
print "</body></html>";
------------------------------------------------------------
You may have to chmod the file to be executable (you can do this typing "chmod 755 form.cgi" at the command prompt, or if you're using FTP, you can probably right-click the file and set all of the executable permissions to "on").
Whenever someone submits this form, a new entry will be made in a file called "records.txt". You can just download this file through FTP and look at it to see who's responded. For a small application like this, I feel this is more convenient than a database. I've set a filesize limit on the file to about 10MB, so if you're expecting a lot of responses (as in hundreds of thousands), you may increase that size.
Facebook
Twitter