<?php
require_once "../include/function.php";(替换成conn.asp)
if(!empty($_GET['qr']))
{
$sql = "update web_user set lmzt=2 where id=".$_GET['qr'];
if(mssql_query($sql))
{
echo "<script>location.href='user.asp';</script>";
}
}
$sql = "select * from web_user where lmfrom is not NULL order by id desc";
$re = mssql_query($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style></head><body>
<table width="100%" border="0" cellspacing="1" cellpadding="5" bgcolor="#C0C0C0">
<tr>
<td align="center" bgcolor="#F7F7F7">编号</td>
<td align="center" bgcolor="#F7F7F7">用户名</td>
<td align="center" bgcolor="#F7F7F7">学校</td>
<td align="center" bgcolor="#F7F7F7">学校用户ID</td>
<td align="center" bgcolor="#F7F7F7">注册IP</td>
<td align="center" bgcolor="#F7F7F7">状态</td>
</tr>
<?php
while($rs = mssql_fetch_object($re)) {
?>
<tr>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->id; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->username; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->lmfrom; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->lmuid; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->lmip; ?></td>
<td align="center" bgcolor="#F7F7F7">
<?php
if($rs->lmzt == 1) echo "<a href='?qr=".$rs->id."'>未确认</a>";
if($rs->lmzt == 2) echo "已确认";
?>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
require_once "../include/function.php";(替换成conn.asp)
if(!empty($_GET['qr']))
{
$sql = "update web_user set lmzt=2 where id=".$_GET['qr'];
if(mssql_query($sql))
{
echo "<script>location.href='user.asp';</script>";
}
}
$sql = "select * from web_user where lmfrom is not NULL order by id desc";
$re = mssql_query($sql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style></head><body>
<table width="100%" border="0" cellspacing="1" cellpadding="5" bgcolor="#C0C0C0">
<tr>
<td align="center" bgcolor="#F7F7F7">编号</td>
<td align="center" bgcolor="#F7F7F7">用户名</td>
<td align="center" bgcolor="#F7F7F7">学校</td>
<td align="center" bgcolor="#F7F7F7">学校用户ID</td>
<td align="center" bgcolor="#F7F7F7">注册IP</td>
<td align="center" bgcolor="#F7F7F7">状态</td>
</tr>
<?php
while($rs = mssql_fetch_object($re)) {
?>
<tr>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->id; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->username; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->lmfrom; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->lmuid; ?></td>
<td align="center" bgcolor="#F7F7F7"><?php echo $rs->lmip; ?></td>
<td align="center" bgcolor="#F7F7F7">
<?php
if($rs->lmzt == 1) echo "<a href='?qr=".$rs->id."'>未确认</a>";
if($rs->lmzt == 2) echo "已确认";
?>
</td>
</tr>
<?php } ?>
</table>
</body>
</html>
<%
dim para
para=trim(request("qr"))
if(para<>"") then
sql="update web_user set lmzt=2 where id="¶
conn.execute(sql)
response.Write("<script>location.href='user.asp'; </script>")
end if
sql="select * from web_user where lmfrom is not NULL order by id desc";
set rs=conn.execute(sql)
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档 </title>
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style> </head> <body>
<table width="100%" border="0" cellspacing="1" cellpadding="5" bgcolor="#C0C0C0">
<tr>
<td align="center" bgcolor="#F7F7F7">编号 </td>
<td align="center" bgcolor="#F7F7F7">用户名 </td>
<td align="center" bgcolor="#F7F7F7">学校 </td>
<td align="center" bgcolor="#F7F7F7">学校用户ID </td>
<td align="center" bgcolor="#F7F7F7">注册IP </td>
<td align="center" bgcolor="#F7F7F7">状态 </td>
</tr>
<%
if not rs.eof then
do while not rs.eof
%>
<tr>
<td align="center" bgcolor="#F7F7F7"><%=rs("id")%></td>
<td align="center" bgcolor="#F7F7F7"><%=rs("username")%></td>
<td align="center" bgcolor="#F7F7F7"><%=rs("lmfrom")%> </td>
<td align="center" bgcolor="#F7F7F7"><%=rs("lmuid")%> </td>
<td align="center" bgcolor="#F7F7F7"><%=rs("lmip")%></td>
<td align="center" bgcolor="#F7F7F7">
<%
if rs("lmzt")=1 then
response.Write("<a href='?qr="&rs("id")&"'>未确认 </a>")
end if
if rs("lmzt")=2 then
response.Write("已确认")
end if
%> </td>
</tr>
<%
rs.movenext
loop
else
%>
<tr>
<td colspan="6" align="center" bgcolor="#F7F7F7">没有记录</td>
</tr>
<%
end if
rs.close
set rs=nothing
set conn=nothing
%>
</table>
</body>
</html>