<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>VIP用户登陆</title>
</head>
<body>
<br>
<br>
<form name="loginForm" method="get" action="testpassword.php" onsubmit="return checkUser()" >
用户名:<input type="text" name="loginName"><br><br>
密码:   <input type="password" name="userPassword"><br><br>
<input type="button" value="注册" onclick="register()" style="width:60px;height:30px" >         
<input type="submit" value="登陆" style="width:60px;height:30px">
</form>
<script>
function checkUser() {
//var check=true;
var userName=document.getElementsByName('loginName')[0];
var passWord=document.getElementsByName('userPassword')[0];
if (userName.value==""){
alert('请先填写用户名');
return false;
}
if(passWord.value==""){
alert('请填写密码')
return false;
}
document.cookie='userName='+userName.value;
document.cookie='passWord='+passWord.value;
}
function register(){
window.location.href='./register.php'
}
</script>
</body>
</html>
以上是登陆页面,以下是判密码是否正确,如不正确则跳转回去。然而无论怎样都只是显示连接成功,后面的代码似乎无法运行。
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>中医九种体质问卷</title>
</head>
<?php
$servername = "l--";
$username = "---";
$password = "--;
$dbname = "------";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}else{echo '连接成功!<br>';}
//firstly we should make sure the password is right?
$userPassword=$_COOKIE['passWord'];
$userName=$_COOKIE['userName'];
echo 'username:'.$userName.'<br>';
echo 'passWord:'.$userPassword;
$sql= "SELECT * FROM user_table WHERE userName=$userPassword";//php的双引号里面可以放变量
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo $row["userPassword"]. "?<br>";
}
} else {
echo "0 结果";
}
$conn->close();
if ($row['userPassword']!= $userPassword){
header("location:./loginPage.php");
}
?>
</body>
</html>