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

　2007-11-11 16:04:36　来源：WEB开发网　　　

核心提示：<?/**file name: login.php3Login Check编码： PHP 4作者： Kevin Lee < webwing@21cn.com >Database: MySQL(和PHP搭配之最佳组合)，Host: localhost Database : mydbTable struc

<?

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

file name: login.php3

Login Check

编码： PHP 4

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

Database: MySQL(和PHP搭配之最佳组合)。

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(和PHP搭配之最佳组合)_pconnect("localhost", "root", "");

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

$result = MySQL(和PHP搭配之最佳组合)_db_query("mydb",$sql);

$row = MySQL(和PHP搭配之最佳组合)_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>" ;

}

?>



<html>

<head>

<title>系统登陆</title>

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

<style type="text/css">



</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 "</script> \n";

exit;

}

?>

Example:

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



<html>

<head></head>

<body>

Success! You have pass the checking.

</body>

<html>