阅读内容 

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

[日期:2006-02-22] 来源:不详  作者:佚名 [字体: ]
 

<?

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

file name: login.PHP3

Login Check

编码: PHP 4

作者: Kevin Lee < webwing@21cn.com >

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>

阅读:
录入:

推荐 】 【 打印
相关新闻      
本文评论       全部评论
发表评论
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款


点评: 字数
姓名:
Advertisement
内容查询


Advertisement