Hi PERL Monks,
I'm new to the DBI module and new to perlmonks.org. The DBI module is really nice.
You can do Database queries with MySQL, among others, but my problem is trying to match my query values with the user input.
This is my query below, but needs help.

### DECLARE VARIABLES
my $uname = $FORM{'req_username'}; 
my $pword = $FORM{'req_password'};


### DEFINE A MySQL QUERY
my $sql = qq{SELECT * FROM $tablename 
                WHERE
                username = '$uname' 
                AND
                password = '$pword'};
my $sth = $dbh->prepare($sql);

### EXECUTE THE QUERY
$sth->execute();

### TEST THE USERNAME AND PASSWORD
if(username ne '$uname' &&  password ne '$pword') # this does not work

[download]

Where do I test the username and password validity?
my validation check that I made does not work as intended.
I need some help with validation of the login form. Can anybody help me out?

In reply to DBI & MySQL Login Test by swordfish

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.