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


<?

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

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>

 

本文作者:



相关阅读:
AJAX请求类
基于jquery点击自以外任意处,关闭自身的代码
js实现页面打印功能实例代码(附去页眉页脚功能代码)
.NET中的Parameters
把vbscript发挥到它的极限应用之一(数组)!!!
抠出Windows 2003中的IIS6安装程序
用MySQL函数清除字符串首尾空白字符的方法
用CSS3伪类target如何制作tab选项卡效果
Linux文件系统x挂载工具--autofs介绍
500内部错误,asp日志报告“不允许的父路径”
ubuntu下无法用date函数设置时间的问题解决
Windows Server 2008 SP2即将发布
WordPress教程:query_posts()
HTML5中 b 和 i 标签将语义化
快速导航

Copyright © 2016 phpStudy |