- 论坛徽章:
- 0
|
rt,意图是从param获取用户名和密码并到事先准备好的mysql里去验证,但是却总是无法得到正确的输出,程序如下,请大家帮忙看看到底是哪儿的问题捏,谢谢~~~
#!/usr/bin/perl -w
use strict;
use CGI qw(:standard);
use DBI;
my $name=param('logname');
my $pass=param('logpass');
print header();
my $dbh=DBI->;connect('DBI:mysql:mydata', 'root', 'root') or die "Cannot connect to database:" . DBI->;errstr;
my $sth=$dbh->;prepare("select * from log_db where name=$name and pass=$pass" ;
$sth->;execute() or die "error:" . $sth->;errstr;
if ($sth) {
print "Ok, you've logged in!!!";
} else {
print "You have typed wrong name or pass!!!";
}
$dbh->;disconnect; |
|