涓�涓熀浜巑ysql鐨勭櫥闄嗛獙璇佺▼搴�
|
<? /****************************************************** 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 "<!-- "; echo "history.back () ; "; 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") "; echo "--> "; echo "</script> "; exit; } ?> Example: <? require("login_chk.php3"); ?> <!--file name: sample.php3--> <html> <head></head> <body> Success! You have pass the checking. </body> <html> 源代码网供稿. |
