一个基于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 "htmlbody 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"bfont 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"";

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