IT技术网www.itjs.cn

当前位置:首页 > 数据库 > MySQL > 一个基于mysql的登陆验证程序

一个基于mysql的登陆验证程序

发布时间:2016-01-30 20:23 来源:未知

<?

/******************************************************

file name: login.php3

Login Check

编码: PHP 4

作者: Author

Database: MySQL。

Host: localhost Database : mydb

Table structure for table 'user'

--------------------------------------------------------

CREATE TABLE user (

id smallint(6) NOT NULL auto_increment,

user varchar(12) NOT NULL,

passwd varchar(12) NOT NULL,

name varchar(20),

email varchar(30),

level char(1),

status char(1),

UNIQUE id (id)

);

--------------------------------------------------------

*******************************************************/

?>

<script language="javascript">

function back(){

history.back();

}

function winclose(){

setTimeout("self.close()",10000);

}

</script>

<?

$db_id = mysql_pconnect("localhost", "root", "");

$sql="select id, user, passwd from user where user='".$name."' and passwd='".$pwd."'";

$result = mysql_db_query("mydb",$sql);

$row = mysql_fetch_array($result);

$id = $row[id] ;

if ($id!="") {

session_start();

session_register("yn");

$yn="yes"  ;

echo "<html><body onload=\"javascript:winclose()\">";

echo "你已经成功登陆。。。"."<p>";

echo "<center>"."窗口10秒钟后自动关闭"."</center>";

echo "</body></html>";

}

else {

echo "帐号或密码错误!!!";

echo "<P>";

echo "<center>";

echo "<a href=\"#\" onclick=\"javascript:back()\">back</a>";

echo "</center>" ;

}

?>

<!--

file name: login.htm

-->

<html>

<head>

<title>系统登陆</title>

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<style type="text/css">

<!--

.css1 {  font-size: 10pt; color: #FFCC66}

-->

</style>

</head>

<body bgcolor="#ffffff" topmargin=0 leftmargin=0>

<form method="post" action="login.php3">

<table width="210" bgcolor="#ffffff" height="106" bordercolor="navajowhite" border="1" style="WIDTH: 210px">

<tr bgcolor="#0000ff">

<td colspan="4">

<div align="center"><b><font color="#ffffff" face="楷体_GB2312">系统登陆</font></b></div>

</td>

</tr>

<tr bgcolor="#f9fde1" bordercolor="#cccccc">

<td width="71" class="css1">

<div align="center">用户帐号</div>

</td>

<td colspan="3" align=middle>

<input name="name" size="14" >

</td>

</tr>

<tr bgcolor="#f9fde1" bordercolor="#cccccc">

<td width="71" class="css1">

<div align="center">用户密码</div>

</td>

<td colspan="3" align=middle>

<input type="password" name="pwd" size="14" >

</td>

</tr>

<tr bgcolor="#f9fde1" bordercolor="#cccccc">

<td colspan="4" height="26" style="HEIGHT: 26px">

<div align="center">

<input type="submit" name="Submit1" value="  登 陆 " height="20" style="FONT-SIZE: smaller; HEIGHT: 22px">

</div>

</td>

</tr>

</table>

</form>

</body>

</html>

<?

/************************

file name: login_chk.php3

************************/

if ($yn!="yes") {

echo "<script language=\"javascript\">\n";

echo "<!-- \n";

echo "history.back () ;\n";

echo "window.open ('../login/login.htm','login','height=116,width=210,top=120,left=200,toolbar=no,menubar=no,scrobllbar=no,resizable=no,location=no,status=no')\n";

echo "--> \n";

echo "</script> \n";

exit;

}

?>

Example:

<? require("login_chk.php3"); ?>

<!--file name: sample.php3-->

<html>

<head></head>

<body>

Success! You have pass the checking.

</body>

<html>