我花了相当长的时间试图弄清楚为什么这段代码不能工作。登录后(在使用post将数据发送到此php文档的html页面上),它会显示:“无法选择数据库!!”(不带引号)。请帮帮我!谢谢!
<?php
$host="localhost";
$username="root";
$password="";
$db_name="firstTestLogins";
$tbl_name="members";
mysql_connect("$host", "$username, $password") or die("cannot connect to the database!!");
mysql_select_db("firstTestLogins") or die("cannot select the database!!");
$username=$_POST['username'];
$password=$_POST['password'];
$username=stripslashes($username);
$password=stripslashes($password);
$username=mysql_real_escape_string($username);
$password=mysql_real_escape_string($password);
$password = md5($password);
echo "This is a debug statement. User = $username and password = $password <br><br><br>";
if(!($sql="SELECT * FROM $tbl_name WHERE username = '$username' and password = '$password")) {die(mysql_error());}
$result = mysql_query($sql);
$test3 = mysql_num_rows(/*$result*/mysql_query($sql));
echo "$test3";
if(mysql_num_rows(/*$result*/mysql_query($sql))) { //should be true because only one row should match the user and pass
$_SESSION['username'] =1;
$_SESSION['password'] =1;
header("location:login_success.php");
}
else {
echo "The incorrect username or password was inserted";
}
?>发布于 2010-11-21 19:44:11
这是错误的:
mysql_connect("$host", "$username, $password");它需要是
mysql_connect($host, $username, $password);通过输出mysql_error(),您将看到确切的问题。
mysql_select_db("firstTestLogins")
or die("cannot select the database! ".mysql_error());发布于 2010-11-21 19:48:38
请将代码更改为:
mysql_select_db("firstTestLogins") or die("cannot select the database!!");至:
mysql_select_db("firstTestLogins") or die(mysql_error());这将帮助您找出为什么MYSQL不能选择数据库
发布于 2010-11-21 19:45:34
除了有关选择数据库的注释之外:
if(!($sql="SELECT * FROM $tbl_name WHERE username = '$username' and password = '$password")) {die(mysql_error());} 如果没有设置$sql字符串,那么使用mysql_error进行测试是愚蠢的……这不会生成mysql错误
你的$sql中还缺少一个结束语
$sql="SELECT * FROM $tbl_name WHERE username = '$username' and password = '$password'";
$result = mysql_query($sql);
if(!$result)
die(mysql_error());https://stackoverflow.com/questions/4237627
复制相似问题