重新敲的代码,却不能连接数据库了总显示如下的错误
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\php\log\loginok.php on line 20Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\php\log\loginok.php on line 22
登陆失败!点击返回<?php
session_start();if($_GET['action'] == "logout"){
unset($_SESSION['username']);
unset($_SESSION['userid']);
exit('注销成功!<a href="javascript:history.back(-1);">点击返回</a>');
}if(isset($_POST['submit']) == ""){
exit('非法访问!!');
}$uername = htmlspecialchars(trim($_POST['username']));
$pwd = MD5(trim($_POST['pwd']));include('conn.php');$mql="select userid from users where username ='$useranme' and pwd='$pwd' limit 1";
$check_user =mysql_query($mql,$conn);
if($result =mysql_fetch_array($check_user)){
$_SESSION['useranme'] = $username;
$_SESSION['userid'] = $result['$userid'];
echo $username,'欢迎到来!<a href="my.php">用户中心</a>';
echo '<a href="index.php">点击进入主页</a><a href="loginok.php"></a>';
exit();
}else{
echo '登陆失败!点击<a href="javascript:history.back(-1);">返回</a>';
}?>连接数据库
<?php
$conn=mysql_connect("localhost","root","137733");
if(!$conn){
die("连接数据库失败:".mysql_error());
}mysql_select_db("hexie",$conn);
mysql_query("set character set 'utf8'");
mysql_query("set names 'utf8'");
?>
PHPMySQL
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\php\log\loginok.php on line 20Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\php\log\loginok.php on line 22
登陆失败!点击返回<?php
session_start();if($_GET['action'] == "logout"){
unset($_SESSION['username']);
unset($_SESSION['userid']);
exit('注销成功!<a href="javascript:history.back(-1);">点击返回</a>');
}if(isset($_POST['submit']) == ""){
exit('非法访问!!');
}$uername = htmlspecialchars(trim($_POST['username']));
$pwd = MD5(trim($_POST['pwd']));include('conn.php');$mql="select userid from users where username ='$useranme' and pwd='$pwd' limit 1";
$check_user =mysql_query($mql,$conn);
if($result =mysql_fetch_array($check_user)){
$_SESSION['useranme'] = $username;
$_SESSION['userid'] = $result['$userid'];
echo $username,'欢迎到来!<a href="my.php">用户中心</a>';
echo '<a href="index.php">点击进入主页</a><a href="loginok.php"></a>';
exit();
}else{
echo '登陆失败!点击<a href="javascript:history.back(-1);">返回</a>';
}?>连接数据库
<?php
$conn=mysql_connect("localhost","root","137733");
if(!$conn){
die("连接数据库失败:".mysql_error());
}mysql_select_db("hexie",$conn);
mysql_query("set character set 'utf8'");
mysql_query("set names 'utf8'");
?>
PHPMySQL
前加入 var_dump($conn);
贴出结果
��NULL
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in D:\php\log\loginok.php on line 21Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\php\log\loginok.php on line 23
登陆失败!点击返回
这就表示你的 conn.php 根本不和你的程序文件在同一目录下
$check_user =mysql_query($mql);
点击返回'); } if(isset($_POST['submit']) == ""){ exit('非法访问!!'); } $uername = htmlspecialchars(trim($_POST['username'])); $pwd = MD5(trim($_POST['pwd'])); include('conn.php'); $mql="select userid from users where username ='$useranme' and pwd='$pwd' limit 1"; $check_user =mysql_query($mql,$conn); if($result =mysql_fetch_array($check_user)){ $_SESSION['useranme'] = $username; $_SESSION['userid'] = $result['$userid']; echo $username,'欢迎到来!用户中心'; echo '点击进入主页'; exit(); }else{ echo '登陆失败!点击返回'; } ?>
貌似是php以第一个出现的>结束而不是?>