按照地区,年龄,性别,个人标签,搜索好友。轮流显示广告信息(可以关闭)。。 后台数据库采用垂直分割。
发布交友信息的表单见: 点击打开链接
搜索好友的表单代码:
<html>
<head>
<style type="text/css">
*{margin:0px; padding:0px;}
div#layout{margin-left:415px; margin-top:5px; width:700px; }
div#user{ border:1px solid #cde6c7;background-color:#918597;}
div#info{position:relative; top:-146px; left: 200px;}
p#name{margin-top:-3px;}
p{margin-top: 12px; color:#56452d; }
p#intro{margin-bottom:12px;}
span{color:#6950a1;margin-left:30px;}
span#image02{position: relative; top:-222px; left:530px;}
span#image01{position: relative; top:-240px; left:530px;}
div#ads_area{position:fixed; z-index:2; margin-left:50px; margin-top:250px;}
</style>
<script type="text/javascript">
//创建XHR
function getXMLHttpRequest()
{
var xmlhttp=null;
if(window.ActiveXObject)
{
xmlhttp = new ActiveXObject("Microsoft.XMLHttp");
}
else
{
xmlhttp=new XMLHttpRequest();
}
return xmlhttp;
}
/*
*广告模块
*/
function removeAds()
{
var div = document.getElementById("ads_area");
if(div.childNodes.length > 0)
{
div.removeChild(div.firstChild);
}
}
var timeout_id;
function closeAds()
{
clearTimeout(timeout_id);
removeAds();
}
function randomAds()
{
removeAds();
var xmlhttp = getXMLHttpRequest();
var url = "/ciba/niujin-beta/friend/randomAds.process.php";
//根据当前时间的秒数,对3取摩,进而轮流显示三个广告
var current_date = new Date();
var data = "?ads_num="+current_date.getSeconds()%3;
//alert(url+data);
if(xmlhttp)
{
xmlhttp.open("get", url+data, true);
xmlhttp.onreadystatechange = function()
{
if(xmlhttp.readyState == 4 && xmlhttp.status == 200)
{
var res = xmlhttp.responseText;
var ads_info = eval("("+res+")");
//alert(ads_info.shutdown_link);
var image_link = ads_info.image_link;
var ads_link = ads_info.ads_link;
var shutdown_link = ads_info.shutdown_link;
var div = document.createElement("div");
//创建链接
var a_link = document.createElement("a");
a_link.setAttribute("href", ads_link);
a_link.setAttribute("target", "__blank");
//创建图片
var img_link = document.createElement("img");
img_link.setAttribute("src", image_link);
img_link.setAttribute("title", "加盟QQ 330454419");
img_link.setAttribute("style", "height:250px; width:190px;");
//创建关闭按钮
var logo_link = document.createElement("img");
logo_link.setAttribute("style", "height:15px; width:15px;position:relative; top:-235px; left:-15px; z-index:3;")
logo_link.setAttribute("title", "点击关闭广告");
logo_link.setAttribute("onclick", "closeAds()");
a_link.appendChild(img_link);
div.appendChild(a_link);
div.appendChild(logo_link);
document.getElementById("ads_area").appendChild(div);
}
}
xmlhttp.send(null);
}
timeout_id = setTimeout("randomAds()", 5000);
}
window.onload = function()
{
randomAds();
}
</script>
<head>
<body bgcolor="#RGB(67,65,65)">
<img src="../image/addfriend.jpg" style='margin-left: 400px; margin-top:1px;'>
<div id="ads_area">
</div>
<div id="layout">
<?php
require_once "sql.tool.php";
$cityname = $_GET['cityname'];
$sql = new Sql();
$items = $sql->getCity($cityname);
foreach($items as $item)
{
/* echo "<div id='user'>";
echo "<p><span>姓名</span><span>{$item[0]}</span><p>";
echo "<p><span>性别</span><span>{$item[1]}</span><p>";
echo "<p><span>年龄</span><span>{$item[2]}</span><p>";
echo "<p><span>QQ号</span><span>{$item[3]}</span><p>";
echo "<p><span>住址</span><span>{$item[4]}</span><p>";
echo "<p><span>标签</span><span>{$item[5]}</span><p>"; */
if(strlen($item[6]) > 80)
{
echo "<div id='user' style='width:680px; height: 240px;'>";
echo "<p><span>姓名</span><span>{$item[0]}</span><p>";
echo "<p><span>性别</span><span>{$item[1]}</span><p>";
echo "<p><span>年龄</span><span>{$item[2]}</span><p>";
echo "<p><span>QQ号</span><span>{$item[3]}</span><p>";
echo "<p><span>住址</span><span>{$item[4]}</span><p>";
echo "<p><span>标签</span><span>{$item[5]}</span><p>";
echo "<p><span>宣言</span><span>{$item[6]}</span><p>";
echo "<p><span id='image01'><img src='".$item[7]."' /></span><p>";
}
else
{
echo "<div id='user' style='width:680px; height: 220px;'>";
echo "<p><span>姓名</span><span>{$item[0]}</span><p>";
echo "<p><span>性别</span><span>{$item[1]}</span><p>";
echo "<p><span>年龄</span><span>{$item[2]}</span><p>";
echo "<p><span>QQ号</span><span>{$item[3]}</span><p>";
echo "<p><span>住址</span><span>{$item[4]}</span><p>";
echo "<p><span>标签</span><span>{$item[5]}</span><p>";
echo "<p><span>宣言</span><span>{$item[6]}</span><p>";
echo "<p><span id='image02'><img src='".$item[7]."' /></span><p>";
}
echo "</div>";
echo "<br /><br />";
}
?>
</div>
</body>
</html>