获取不到用户名和密码呀???请高手指点一二,谢谢谢谢!!!!

[worksworks]

$dbh=mysql_connect('192.168.6.13','jiatu','123456');
if(!$dbh){
echo "没连接到数据库".strval($dbh);
exit;
}
else{
echo "连接成功";
}
$name=$_POST["logname"];
$pwd=$_POST["logpwd"];
$query="select u_id,u_pwd from users where u_id='$name' and u_pwd='$pwd'";
$rsh=mysql_db_query('paper',$query,$dbh);
$row=mysql_fetch_array($rsh);
if($row["u_id"]!=$name){
echo "没有该用户";
mysql_free_result($rsh);
mysql_close($dbh);
exit;
}else
if($row["u_pwd"]!=$pwd){
echo "密码不正确";
mysql_free_result($rsh);
mysql_close($dbh);
exit;
}

[worksworks]

指点指点了,初学php,请多多指教!!

[worksworks]

指教一下了,在线等!!急急急!!谢谢!!!!

[bigluckyfox]

$query="select u_id,u_pwd from users where u_id='$name' and u_pwd='$pwd'";

这句有问题哦

我把我写的一段贴给你看看吧

[bigluckyfox]

<?php

//DataBase Info
$dbhost = "localhost"; // DB Host
$dbuser = "root"; // DB User
$dbpasswd = ""; // DB User Password
$dbname = "cms"; // DB Name

$username=$_POST['username'];
$password=$_POST['password'];
$password=md5($password);
$sql = "SELECT * FROM $tb_admin WHERE username='$username'";
$result = mysql_db_query($dbname, $sql);
$objresult = mysql_fetch_object($result);
$user_password = $objresult->password;

if ($username=="" || $password==""):
echo "用户名或密码不能为空";
echo "<br><a href=javascript:history.back(1)>点击这里返回</a><br>";
exit;
elseif ($user_password == ""):
echo "用户名错误";
echo "<br><a href=javascript:history.back(1)>点击这里返回</a><br>";
exit;
elseif ($password != $user_password):
echo "密码错误";
echo "<br><a href=javascript:history.back(1)>点击这里返回</a><br>";
exit;
elseif ($password != $user_password):
echo "密码错误";
echo "<br><a href=javascript:history.back(1)>点击这里返回</a><br>";
exit;
endif;
?>

[worksworks]

多谢了!!! :-)