php登录验证及代码实现 含数据库设计 亲测有效
来源：程序员人生 发布时间：2014-09-03 05:34:48 阅读次数：3355次
深夜调代码 试过无数种方法终于见了成效
login.php内容如下
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>管理员后台登录 </title>
<!-- CSS -->
<!-- Reset Stylesheet -->
<link rel="stylesheet" href="resources/css/reset.css" type="text/css" media="screen" />
<!-- Main Stylesheet -->
<link rel="stylesheet" href="resources/css/style.css" type="text/css" media="screen" />
<!-- Invalid Stylesheet. This makes stuff look pretty. Remove it if you want the CSS completely valid -->
<link rel="stylesheet" href="resources/css/invalid.css" type="text/css" media="screen" />
<!-- Javascripts -->
<!-- jQuery -->
<script type="text/javascript" src="resources/scripts/jquery-1.3.2.min.js"></script>
<!-- jQuery Configuration -->
<script type="text/javascript" src="resources/scripts/simpla.jquery.configuration.js"></script>
<!-- Facebox jQuery Plugin -->
<script type="text/javascript" src="resources/scripts/facebox.js"></script>
<!-- jQuery WYSIWYG Plugin -->
<script type="text/javascript" src="resources/scripts/jquery.wysiwyg.js"></script>
</head>
<body id="login">
<div id="login-wrapper" class="png_bg">
<div id="login-top">
<h1>管理员后台登录</h1>
<!-- Logo (221px width) -->
<a href="#"><img id="logo" src="resources/images/logo.png" alt="Simpla Admin logo" /></a> </div>
<!-- End #logn-top -->
<div id="login-content">
<form action="login_1.php" method = "POST">
<fieldset>
<p>
<label>用户名</label>
<input class="text-input" type="text" name = "loginName"/>
</p>
<div class="clear"></div>
<p>
<label>密码</label>
<input class="text-input" type="password" name = "loginPwd"/>
</p>
<div class="clear"></div>
<p id="remember-password">
<input type="checkbox" />
记住我 </p>
<div class="clear"></div>
<p>
<input id = "loginbtn" class="button" type="submit" value="登入" name = "submit" />
</p>
</fieldset>
</form>
</div>
<!-- End #login-content -->
</div>
<!-- End #login-wrapper -->
</body>
</html>
login_1.php内容如下
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php
error_reporting(0);
if(!isset($_POST['submit'])){
exit('非法访问!');
}
$name=$_POST['loginName'];
$password=$_POST['loginPwd'];
include('connect.php');
if($name && $password){
echo "come in";
$sql="select * from admin where adName='$name' and adPwd='$password' ";
$res=mysql_query($sql);
echo "$res";
echo "$name";
$test=mysql_fetch_array($res);
if($test && strcmp($name,'admin')==0){
header("location:index.php");
echo "finally";
exit;
}else{
echo "fail to login";
exit;
}
mysql_free_result($res);
mysql_close($conn);
}
?>
connect.php内容如下
<?php
$conn=mysql_connect('localhost','root','') or die("连接失败".mysql_error());
mysql_select_db('door',$conn) or die("选择数据库失败".mysql_error());
mysql_query("set names gb2312");
?>
数据库设计 如下
生活不易，码农辛苦
如果您觉得本网站对您的学习有所帮助,可以手机扫描二维码进行捐赠
62$TI.jpg)
