<script language="vbs">
<!--
function funsubmit()
if T1.value <> "" and T2.value <> "" then
Dim rs,conn,sql
...
sql = "select * from table where username ='" & Trim(T1.value) & "' and userpassword ='" & Trim(T2.value) & "'"
rs.open sql,conn ...
if not rs.eof then
alert("通过验证,登录!")
form1.submit()
else
msgbox "用户名密码输入错误,请重新输入!"
T1.value=""
T2.value=""
end if
else
msgbox "请输入用户名和密码!"
end if
end function
-->
</script><form name=form1 method=post action=a.asp onsubmit="funsubmit()">
请输入用户名:<input name=T1 size=20>
请输入密码:<input name=T2 size=20>
<p><input type=submit></p>try~~~
<!--
function funsubmit()
if T1.value <> "" and T2.value <> "" then
Dim rs,conn,sql
...
sql = "select * from table where username ='" & Trim(T1.value) & "' and userpassword ='" & Trim(T2.value) & "'"
rs.open sql,conn ...
if not rs.eof then
alert("通过验证,登录!")
form1.submit()
else
msgbox "用户名密码输入错误,请重新输入!"
T1.value=""
T2.value=""
end if
else
msgbox "请输入用户名和密码!"
end if
end function
-->
</script><form name=form1 method=post action=a.asp onsubmit="funsubmit()">
请输入用户名:<input name=T1 size=20>
请输入密码:<input name=T2 size=20>
<p><input type=submit></p>try~~~
username=request.form("username")
password=request.form("password")
sql="select user_name,user_psw,user_str,user_ok from [user] where user_name='"&username&"'"
Set conn=Server.CreateObject("ADODB.Connection")
application("cvec")="dsn=cvec;uid=sa;pwd=password"
conn.open application("cvec")
Set rs=Server.CreateObject("ADODB.recordset")
rs.Open sql,conn
if rs.eof then
response.write"用户名错误,请核对后重新输入!"
session("error")=session("error")+1
rs.close
set rs=nothing
conn.close
set conn=nothing
Response.End
end if
if password<>trim(rs("user_psw")) then
response.write"密码错误,请核对后重新输入!"
session("error")=session("error")+1
rs.close
set rs=nothing
conn.close
set conn=nothing
Response.End
end if
if rs("user_ok")=0 then
response.redirect"master/nook.asp"
end if
session("username")=rs("user_name")
if rs("user_str")=0 then
response.redirect"index-r.asp"
end ifresponse.redirect"master/main.asp"
rs.close
set rs=nothing
%>
//连接数据库
$con =mysql_connect("localhost","root","" ) or die("无法连接到数据库!");
mysql_select_db("数据库名",$con)or die("无法选择数据库!");
$query="select * from 表名 where name='$username' and pwd='$password'";
$result=mysql_query("$query",$con);
$r=mysql_fetch_row($result);
if($r[1])
//check password
{
session_start(); session_register('user');
$user=$username;if(session_is_registered('user'))
require ("正确.php"); }
else
require ("错误.php");
//关闭数据库
mysql_close($con);
?>
login.php
<form name="frm" method="post" action="check.php">
<table width="100%" border="0" cellspacing="0" cellpadding="1" class="TitleColor">
<tr style="vertical-align: top">
<td> <table width="100%" border="0" cellspacing="0" cellpadding="5" class="sx"> <tr>
<td width="28%" align="right" class="style2">用户登陆 </td>
<td width="72%"> <span class="style6">用户名:</span>
<input name="username" type="text" size="15" maxlength="15" >
<span class="style6"> 密码:</span>
<input name="password" type="password" size="15" maxlength="15" >
<input name="submit" type="submit" value="进入" ></td>
</tr>
</table></td> </tr>
</table>
<td align="center" width="97%" height="53"> <div align="center">
<p> </p>
</div></td>
</form>