1<?
2/******************************************************
3file name: login.php3
4Login Check
5编码： PHP 4
6作者： Kevin Lee < [email protected] >
7Database: MySQL。
8Host: localhost Database : mydb
9Table structure for table 'user'
10\--------------------------------------------------------
11CREATE TABLE user (
12id smallint(6) NOT NULL auto_increment,
13user varchar(12) NOT NULL,
14passwd varchar(12) NOT NULL,
15name varchar(20),
16email varchar(30),
17level char(1),
18status char(1),
19UNIQUE id (id)
20);
21\--------------------------------------------------------
22
23
24*******************************************************/
25?>
26<script language="javascript">
27function back(){
28history.back();
29}
30function winclose(){
31setTimeout("self.close()",10000);
32}
33</script>
34<?
35$db_id = mysql_pconnect("localhost", "root", "");
36$sql="select id, user, passwd from user where user='".$name."' and passwd='".$pwd."'";
37$result = mysql_db_query("mydb",$sql);
38$row = mysql_fetch_array($result);
39$id = $row[id] ;
40
41if ($id!="") {
42session_start();
43session_register("yn");
44$yn="yes" ;
45echo "<html>
46<body onload='\"javascript:winclose()\"'>";
47echo "你已经成功登陆。。。"."<p>";
48echo "<center>"."窗口10秒钟后自动关闭"."</center>";
49echo "</p></body>
50";
51
52}
53else {
54echo "帐号或密码错误！！！";
55echo "
56<p>";
57echo "<center>";
58echo "<a href='\"#\"' onclick='\"javascript:back()\"'>back</a>";
59echo "</center>" ;
60}
61?>
62
63<!--
64file name: login.htm
65\-->
66<html>
67<head>
68<title>系统登陆</title>
69<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
70<style type="text/css">
71<!--
72.css1 { font-size: 10pt; color: #FFCC66}
73\-->
74</style>
75</head>
76<body bgcolor="#ffffff" leftmargin="0" topmargin="0">
77<form action="login.php3" method="post">
78<table bgcolor="#ffffff" border="1" bordercolor="navajowhite" height="106" style="WIDTH: 210px" width="210">
79<tr bgcolor="#0000ff">
80<td colspan="4">
81<div align="center"><b><font color="#ffffff" face="楷体_GB2312">系统登陆</font></b></div>
82</td>
83</tr>
84<tr bgcolor="#f9fde1" bordercolor="#cccccc">
85<td class="css1" width="71">
86<div align="center">用户帐号</div>
87</td>
88<td align="middle" colspan="3">
89<input name="name" size="14"/>
90</td>
91</tr>
92<tr bgcolor="#f9fde1" bordercolor="#cccccc">
93<td class="css1" width="71">
94<div align="center">用户密码</div>
95</td>
96<td align="middle" colspan="3">
97<input name="pwd" size="14" type="password"/>
98</td>
99</tr>
100<tr bgcolor="#f9fde1" bordercolor="#cccccc">
101<td colspan="4" height="26" style="HEIGHT: 26px">
102<div align="center">
103<input height="20" name="Submit1" style="FONT-SIZE: smaller; HEIGHT: 22px" type="submit" value=" 登 陆 "/>
104</div>
105</td>
106</tr>
107</table>
108</form>
109</body>
110</html>
111<?
112/************************
113file name: login_chk.php3
114************************/
115if ($yn!="yes") {
116
117echo "<script language=\"javascript\">\n";
118echo "<!-- \n";
119echo "history.back () ;\n";
120echo "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";
121echo "--> \n";
122echo " \n";
123exit;
124}
125?>
126
127Example:
128<? require("login_chk.php3"); ?>
129<!--file name: sample.php3-->
130<html>
131<head></head>
132<body>
133Success! You have pass the checking.
134</body>
135<html></html></html></p>
一个基于mysql的登陆验证程序
comments powered by Disqus