<?php
$servername = "--";
$username = "---";
$password = "--";
$dbname = "--";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
} else {
echo '连接成功!<br>';
}
echo "userSex:".$_COOKIE['userSex'].'<br>';//从登陆页面获取
echo 'testTime:'.$_COOKIE['testTime'];//从登陆页面获取
/*
if( $_COOKIE['userSex']=='male'){
echo $_COOKIE['userSex'];
}
echo '<br>';
echo 'userSex'. $_COOKIE['userSex'];
if($_COOKIE['userSex']=='female'){
echo $_COOKIE['userSex'];
}
*/
$userName = $_COOKIE['userName'];
$userPassword = $_COOKIE['userPassword'];
$sql = "SELECT * FROM user_table WHERE userName='{$userName}' and userPassword='{$userPassword}'";//php的双引号里面可以放变量
$result = $conn->query($sql);
$row=$result->fetch_assoc();
if ($result->num_rows > 0) {
setcookie('cautionWord', '健康开心每一天');
setcookie('userRight', 'normalRight');
setcookie('userSex', $row['userSex']);
setcookie('testTime', $row['testTime'] + 1);
//make sure the time of test
$testTime = $_COOKIE['testTime'];
$sql = "UPDATE user_table SET testTime='{$testTime}' WHERE userName='{$userName}'";//insert the testTime
$result = $conn->query($sql);
//echo 'testTime:'.$tesTime;
$userName = $_COOKIE['userName'];
echo 'userName:' . $userName;
$sql = "UPDATE user_table SET testTime='{$testTime}' WHERE userName='{$userName}'";//insert the testTime
if ($result = $conn->query($sql)) {
echo 'insert successfully';
} else {
echo 'please insert again.';
}
}else{
echo 'there is no such customer!';
}
?>
登陆页面登陆之后,进入这个页面,原本是想要testTime加1就可以了,但是但先是 +2 ,然后再登陆一次,又是 -1,被整晕了