Ok, I'm going to break this apart into different sections so that someone may can help
me figure out what i want to do/how to do it a little better...
Goal : User enters information into a form.pl and the form.pl process's logon
information from a mysql database and sends an email with the information entered if
the logon information is correct.
Information Entered : Customer Number, Password, Name, Email Address, Message
Logon Information Verified *using DBI* : Customer Number, Password
current code i'm trying to peice together
~~~~~~~~ web form for entering customer number/password ~~~~~~~~
use CGI qw/:standard/;
print header,
start_html('Enter Information'),
h1('Enter Information'),
start_form,
"Customer Number : ",textfield('custnum'),p,
"Password : ",password_field('passwdx1'),p,
submit,
end_form,
hr;
if (param()) {
print "Customer Number Entered : ",em(param('custnum')),p,
"Password Entered : ",em(param('passwdx1')),
hr;
}
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~ DBI code for connecting to the database ~~~~~~~~
use DBI;
my $dbh = DBI->connect( "dbi:mysql:nextek", "root", "" )
or die "Can't connect to MySQL Database: $DBI:errstr\n";
$dbh->disconnect( );
exit;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ok, this leads to the part i dont know how to do .... I dont know how to compare the
values from the web portion of this code, passwdx1 and custnum to the values in the
mysql database and respond if they are correct or incorrect, and how to peice the DBI
code and the Web code all together in one file so that it works as one...
If anyone can please help me with this it'd be VERY much appreacited, i'm learning
this to accomplish a small task for our office, its my first step into perl and so far
i see i'm enjoying it alot, but have alot of learning to do and really want to get
this done..
I appreacite any help.
Thanks,
Koie Smith