登录页:login.php
1 <?php
2 //登录
3 if(!isset($_POST['submit'])){exit('非法访问!');}
4 $username = $_POST['adname'];
5 $password = $_POST['adpass'];
6 //包含数据库连接文件
7 include('conn.php');
8 //检测用户名及密码是否正确
9 $check_query = mysql_query("select * from admin where ad_name='$username' and ad_code='$password' limit 1");
10 if($result = mysql_fetch_array($check_query)){
11 //登录成功
12 session_start();
13 $_SESSION['username'] = $username;
14 $_SESSION['userid'] = $result['ad_id'];
15 echo $username,' 欢迎你!进入 <a href="my.php">用户中心</a><br />';
16 echo '点击此处 <a href="login.html">注销</a> 登录!<br />';
17 exit;
18 } else {
19 exit('登录失败!点击此处 <a href="javascript:history.back(-1);">返回</a> 重试');
20 }
21 //注销登录
22 if($_GET['action'] == "logout"){
23 unset($_SESSION['userid']);
24 unset($_SESSION['username']);
25 echo '注销登录成功!点击此处 <a href="login.html">登录</a>';
26 exit;
27 }
28 ?>
$_POST["a"]:获取post提交的数据a的值
mysql_query("select * from admin where ad_name='$username' and ad_code='$password' limit 1");执行一条MySQL查询
mysql_fetch_array($check_query):获取根据如上数据表查询的一行信息