<div class="codebody" id="code84069">
<?PHP
@MysqL_connect("localhost","root","1981427") //选择数据库之前需要先连接数据库服务器
or die("数据库服务器连接失败");
@MysqL_select_db("test") //选择数据库mydb
or die("数据库不存在或不可用");
//获取用户输入
$username = $_POST['username'];
$passcode = $_POST['passcode'];
$cookie = $_POST['cookie'];
//执行sql语句
$query = @MysqL_query("select username,userflag from users "
."where username = '$username' and passcode = '$passcode'")
or die("sql语句执行失败");
//判断用户是否存在，密码是否正确
if($row = MysqL_fetch_array($query))
{
if($row['userflag'] == 1 or $row['userflag'] == 0) //判断用户权限信息是否有效
{
switch($cookie) //根据用户的选择设置cookie保存时间
{
case 0: //保存Cookie为浏览器进程
setcookie("username",$row['username']);
break;
case 1: //保存1天
setcookie("username",$row['username'],time()+246060);
break;
case 2: //保存30天
setcookie("username",time()+30246060);
break;
case 3: //保存365天
setcookie("username",time()+365246060);
break;
}
header("location: main.PHP"); //自动跳转到main.PHP
}
else
{
echo "用户权限信息不正确";
}
}
else
{
echo "用户名或密码错误";
}
?>