📄 leasehouse.asp
字号:
<!--#include file="tools.asp"-->
<html><head><title>出租房信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><link href="images/zzz.css" type="text/css" rel="stylesheet">
<script language="Javascript" src="function/function.js"></script>
<script language="JavaScript">
<!--
function SnR_MarkIE(theURL,theName,alertMsg) { //v3.0.3
var agt = navigator.userAgent.toLowerCase();
var is_win = ((agt.indexOf("win")!= -1) || (agt.indexOf("16bit")!= -1));
var is_win95 = ((agt.indexOf("win95")!= -1) || (agt.indexOf("windows 95")!= -1));
var is_win16 = ((agt.indexOf("win16")!= -1) || (agt.indexOf("16bit")!= -1) || (agt.indexOf("windows 3.1")!= -1) || (agt.indexOf("windows 16-bit")!= -1) );
var is_win31 = ((agt.indexOf("windows 3.1")!= -1) || (agt.indexOf("win16")!= -1) || (agt.indexOf("windows 16-bit")!= -1));
var is_win98 = ((agt.indexOf("win98")!= -1) || (agt.indexOf("windows 98")!= -1));
var is_winnt = ((agt.indexOf("winnt")!= -1) || (agt.indexOf("windows nt")!= -1));
var is_win32 = (is_win95 || is_winnt || is_win98 || (agt.indexOf("win32")!= -1) || (agt.indexOf("32bit")!= -1));
//Error Causing Element from above line: ((is_major >= 4) && (navigator.platform == "Win32")) ||
var is_Mac = (agt.indexOf("mac") != -1);
if (document.all && (is_win32)) { //IE Windows Only
window.external.AddFavorite(theURL,theName);
}
else { // all others
alert(alertMsg);
}
}
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function s1_onchange() {
window.location=window.s1.value
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && document.getElementById) x=document.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
function MM_showHideLayers() { //v3.0
var i,p,v,obj,args=MM_showHideLayers.arguments;
for (i=0; i<(args.length-2); i+=3) if ((obj=MM_findObj(args[i]))!=null) { v=args[i+2];
if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v='hide')?'hidden':v; }
obj.visibility=v; }
}
//-->
</script>
</head>
<body text="#000000" bgColor="#ffffff" leftMargin="0" topMargin="0" onload="MM_preloadImages('images/kk2.gif')">
<!--#include file="title.asp"-->
<table class="shuang" cellSpacing="0" cellPadding="0" width="778" align="center" background="images/bg4.gif" border="0"><!--整体的大表格-->
<tbody>
<tr>
<td vAlign="bottom" width="193" height="23">
<table height="19" cellSpacing="0" cellPadding="0" width="180" align="center" background="images/bg2.gif" border="0">
<tbody>
<tr>
<td width="60" height="11"> </td>
<td vAlign="center" width="76" height="11">
<div class="zzz" align="center">房 源 搜 索</div></td>
<td width="44" height="11"> </td></tr></tbody></table>
</td>
<td vAlign="center" width="5" rowSpan="2"> </td>
<td vAlign="top" width="580" rowSpan="2">
<table class="shuang" cellSpacing="0" cellPadding="0" width="575" align="center" background="images/bg4.gif" border="0">
<tr>
<td vAlign="top" width="575"><table cellSpacing="1" cellPadding="1" width="575" bgColor="#666666" border="0">
<tbody>
<%
strsql="select hasimage,ctel,hid,mem.uid id,houseaddress,hall,room,price,mem.uname,mem.tel from tbllease house join tblmembers mem on house.uid=mem.uid order by hid desc"
uid=trim(Request.QueryString("uid"))
if uid<>"" then
strsql="select hasimage,ctel,hid,mem.uid id,houseaddress,hall,room,price,mem.uname,mem.tel from tbllease house join tblmembers mem on house.uid=mem.uid where house.uid=" & sqlstr(uid) & " order by hid desc"
end if
set rsd=server.CreateObject("adodb.recordset")
%>
<tr>
<td class="zzz" bgColor="#ffcc66" width="25%" align="center"><p align="center">地址</td>
<td class="zzz" bgColor="#ffcc66" width="12%" align="center">房型</td>
<td class="zzz" bgColor="#ffcc66" width="11%" align="center">价格(/套)</td>
<td class="zzz" bgColor="#ffcc66" width="23%" align="center">电话</td>
<td class="zzz" bgColor="#ffcc66" width="29%" align="center">中介公司</td>
</tr>
<%
rsd.Open strsql,conn,adOpenStatic
page=trim(Request.QueryString("page"))
if page="" or not(isnumeric(page)) then page=1
page=cint(page)
rsd.PageSize=30
rsd.CacheSize=30
cpage=rsd.PageCount
rsd.AbsolutePage=page
do until rsd.EOF or i>30
%>
<tr>
<td class="zzz" width="25%" bgColor="#eeeeee" height="20"><a href="showlhouse.asp?hid=<%=rsd("hid")%>"><%=rsd("houseaddress")%></a>
<%
if rsd("hasimage")=1 then
istrsql="select * from tblimages where hid=" & rsd("hid") & " and tblname='l'"
set irsd=server.CreateObject("adodb.recordset")
irsd.Open istrsql,conn
%>
<a href="mimages/<%=irsd("imgname")%>" target="_blank"><img src="images/fx.gif" border="0" WIDTH="49" HEIGHT="13"></a>
<%set irsd=nothing%>
<%end if%>
</td>
<td class="zzz" width="12%" bgColor="#eeeeee" height="15" align="center"><%=rsd("room")%>室<%=rsd("hall")%>厅</td>
<td class="zzz" width="11%" bgColor="#eeeeee" height="15" align="right"><%=formatnumber(rsd("price"),0)%></td>
<td class="zzz" width="23%" bgColor="#eeeeee" height="15" align="center">
<%if isnull(rsd("ctel")) or rsd("ctel")="" then
Response.Write rsd("tel")
else
Response.Write rsd("ctel")
end if
%>
</td>
<td class="zzz" width="29%" bgColor="#eeeeee"><a href="showmember.asp?uid=<%=rsd("id")%>"><%=rsd("uname")%></a></td>
</tr>
<%
rsd.MoveNext
i=i+1
if rsd.EOF then
exit do
end if
%>
<tr bgColor="#ffffff">
<td class="zzz" width="25%" height="20"><a href="showlhouse.asp?hid=<%=rsd("hid")%>"><%=rsd("houseaddress")%></a>
<%
if rsd("hasimage")=1 then
istrsql="select * from tblimages where hid=" & rsd("hid") & " and tblname='l'"
set irsd=server.CreateObject("adodb.recordset")
irsd.Open istrsql,conn
%>
<a href="mimages/<%=irsd("imgname")%>" target="_blank"><img src="images/fx.gif" border="0" WIDTH="49" HEIGHT="13"></a>
<%set irsd=nothing%>
<%end if%>
</td>
<td class="zzz" width="12%" align="center"><%=rsd("room")%>室<%=rsd("hall")%>厅</td>
<td class="zzz" width="11%" align="right"><%=formatnumber(rsd("price"),0)%></td>
<td class="zzz" width="23%" align="center">
<%if isnull(rsd("ctel")) or rsd("ctel")="" then
Response.Write rsd("tel")
else
Response.Write rsd("ctel")
end if
%>
</td>
<td class="zzz" width="29%"><a href="showmember.asp?uid=<%=rsd("id")%>"><%=rsd("uname")%></a></td>
</tr>
<%
rsd.MoveNext
i=i+1
loop
rsd.Close
set rsd=nothing
%>
<tr>
<td class="zzz" width="100%" bgColor="#eeeeee" height="20" align="right" colspan="5">
<table cellSpacing="0" cellPadding="0" width="570" align="center" border="0" height="10">
<tbody>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -