php登录验证及代码实现 含数据库设计 亲測有效

深夜调代码 试过无数种方法最终见了成效

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>username</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");
?>



数据库设计 例如以下


原文地址:https://www.cnblogs.com/yutingliuyl/p/6868494.html