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

Reply via email to