php登入驗證及代碼實現含資料庫設計親測有效

最後更新：2014-08-31 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

標籤：php 密碼 mysql

深夜調代碼試過無數種方法終於見了成效

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

資料庫設計如下

php登入驗證及代碼實現含資料庫設計親測有效

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More