$dbhost = "localhost:3306";
$dbuser = "root";
$dbpassword = "gpc1111";
$dbname = "graduateserver";
$cn = mysql_connect($dbhost,$dbuser,$dbpassword) or die("connect error");
mysql_select_db($dbname,$cn) or die("db error");
mysql_query("set names utf8");
$query = mysql_query("select username from user where user_name = '$_POST[login_name]'");
mysql_num_rows( $query ) or die('用户名不存在');
$query = mysql_query("select username,user_password from user where user_name = '$_POST['login_name']' and user_password = '$_POST[login_password]'");
mysql_num_rows( $query ) or die('密码错误不存在');
echo "login succeed";
mysql_query("select * from user where user_name = "$_POST['login_name']"");
"$_POST['login_name']"");
name']"");
""
提示第9行,应该是这行代码:
$query = mysql_query("select * from user where user_name = "$_POST['login_name']"");
$query = mysql_query( 这里应该是查询语句【一个字符串】 );
所以,错误是没有连接符。
正确的是:
$query = mysql_query(” select * from user where user_name = ‘“.$_POST['login_name']."' ");
注意,上面的 . 是连接符;
一般user_name都是字符串类型,所以sql语句中要加单引号 ’ 。