here is full scrip with html source

#!"C:\xampp\perl\bin\perl.exe"

use DBI;
use CGI;

$cgi = CGI->new(); 
$db ="datab";
$usr ="root";
$pwd ="";
$host ="localhost";


$dbh = DBI->connect("DBI:mysql:$db:$host", $usr, $pwd {
   AutoCommit => 0,
    RaiseError => 1,
} )   or die $DBI::errstr;

my $username = $cgi->param('username');
my $password = $cgi->param('password');

my $sth = $dbh->prepare("select id from mysql_auth where username = ? 
+AND password=?");
$sth->execute($username, $password);
 if ($x = $sth->fetchrow()) {
     $sth->finish();
     $cookie = $cgi->cookie(-name=>'id', -value=>$username);
     print $cgi->redirect(-location=>"welcome.pl", -cookie=>$cookie);
}
 else {
 print $cgi->redirect("wrong_username or password.pl");
 }

print "Content-type: text/html\n\n";
print <<START_HTML;
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http:/
+/www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<p>username 
  <input type="text" name="username" />
</p>
<p>password 
  <input type="password" name="password" />
</p>
<p>
  <input type="submit" name="button"  value="Submit" />
</p>
</body>
</html>

START_HTML

[download]

In reply to Re^11: cookie problem by bigup401
in thread cookie problem by bigup401

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.