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

一个基于mysql的登陆验证程序 - 应用软件 - 电脑教程网

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

日期:2006-09-12   荐:

<?/******************************************************file name: login.php3Login Check编码: PHP 4作者: Kevin Lee < [email protected] >Database: MySQL。Host: localhost Database : mydbTable 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>

标签: