posted September 21, 1999 04:07 PM            

I use both but I find it's easier to use PHP with mySQL for both inputting user submissions (from a form) to a database(s) as well as displaying the output, emailing it out, or using in neat ways like creating hyperlinks from certain values, etc.

There are several tutorials on this site and hotwired.com (webmonkey) that walk a newbie through it... to have you up and running in no time.

posted September 21, 1999 05:27 PM            

use DBI;
print "Content-type: text/html\n\n"; $user = "myuserid";
$database = "mydatabase";
$host = "";
$port= "3333";
$password = "mypasswd";
$driver = "mysql";
$table = "test";
$dsn = "DBI:$driver:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $user, $password);
*****HERE IS MY NEWBIE QUESTION********
$name = ???
$email = ???
*****END MY QUESTION***********

$sth = $dbh->prepare("INSERT INTO $table VALUES($name, $email)");

Thanks for your time.

posted September 23, 1999 10:38 AM            

code:

---

$temp=$ENV{'QUERY_STRING'};
@pairs=split /&/,$temp;
foreach $item(@pairs) {
	($key, $content)=split /=/,$item,2;
	$content=~tr/?/ /;
	$content=~s/%(..)/pack("c",hex($1))/ge;
	$fields{$key}=$content;
}
$name=$fields{'name'};
$email=$fields{'email'};

If your form's method=post you need to replace the first line with:

code:

---

read(STDIN,$temp,$ENV{'CONTENT_LENGHT'});