/
browse_fri.php
181 lines (180 loc) · 8.77 KB
/
browse_fri.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
<?php session_start(); include "Conn/conn.php"; include "check_login.php"; ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="CSS/style.css" rel="stylesheet">
<title>浏览我的朋友</title>
</head>
<script src=" JS/menu.JS"></script>
<script language="javascript">
function fri_chk(){
if(confirm("确定要删除选中的朋友吗？一旦删除将不能恢复！")){
return true;
}else
return false;
}
</script>
<body>
<div class=menuskin id=popmenu
onmouseover="clearhidemenu();highlightmenu(event,'on')"
onmouseout="highlightmenu(event,'off');dynamichide(event)"
style="Z-index:100;position:absolute;"> </div>
<TABLE width="757" cellPadding=0 cellSpacing=0 style="WIDTH: 755px" align="center">
<TBODY>
<TR> <TD style="VERTICAL-ALIGN: bottom; HEIGHT: 6px" colSpan=3> <TABLE
style="BACKGROUND-IMAGE: url( images/f_head.jpg); WIDTH: 760px; HEIGHT: 154px"
cellSpacing=0 cellPadding=0> <TBODY>
<TR>
<TD height="110" colspan="6"
style="VERTICAL-ALIGN: text-top; WIDTH: 80px; HEIGHT: 115px; TEXT-ALIGN: right"></TD>
</TR>
<TR>
<TD height="29" align="center" valign="middle"> <TABLE style="WIDTH: 580px" VERTICAL-ALIGN: text-top; cellSpacing=0 cellPadding=0 align="center">
<TBODY>
<TR align="center" valign="middle">
<TD style="WIDTH: 100px; COLOR: red;">欢迎您: <?php echo $_SESSION[username]; ?> </TD>
<TD style="WIDTH: 80px; COLOR: red;"><a href="index.php">博客首页</a></TD>
<TD style="WIDTH: 80px; COLOR: red;"><a onmouseover=showmenu(event,productmenu) onmouseout=delayhidemenu() class='navlink' style="CURSOR:hand" >文章管理</a></TD>
<TD style="WIDTH: 80px; COLOR: red;"><a onmouseover=showmenu(event,Honourmenu) onmouseout=delayhidemenu() class='navlink' style="CURSOR:hand">图片管理</a></TD>
<TD style="WIDTH: 90px; COLOR: red;"><a onmouseover=showmenu(event,myfriend) onmouseout=delayhidemenu() class='navlink' style="CURSOR:hand" >朋友圈管理</a> </TD>
<?php
if($_SESSION[fig]==1){
?>
<TD style="WIDTH: 80px; COLOR: red;"><a onmouseover=showmenu(event,myuser) onmouseout=delayhidemenu() class='navlink' style="CURSOR:hand" >管理员管理</a></TD>
<?php
}
?>
<TD style="WIDTH: 80px; COLOR: red;"><a href="safe.php">退出登录</a></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD colSpan=3 valign="baseline" style="BACKGROUND-IMAGE: url( images/bg.jpg); VERTICAL-ALIGN: middle; HEIGHT: 450px; TEXT-ALIGN: center"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="451" align="center" valign="top"><br>
<table width="640" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="613" height="16" align="right" valign="top"> </td>
<br> <?php if ($page=="") {$page=1;}; ?>
</tr>
<tr>
<td height="292" align="center" valign="top" bordercolor="#D6E7A5">
<table width="600" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#9CC739" bgcolor="#FFFFFF">
<tr align="left" colspan="2" >
<td width="390" height="25" colspan="3" valign="top" bgcolor="#EFF7DE"> <span class="i_table"><span class="tableBorder_LTR"> 浏览我的朋友</span></span> </td>
</tr>
<?php
if ($page){
$page_size=2; //每页显示2条记录
$query="select count(*) as total from tb_friend where username='$_SESSION[username]' order by id desc";
$result=mysql_query($query); //查询总的记录条数
$message_count=mysql_result($result,0,"total"); //为变量赋值
$page_count=ceil($message_count/$page_size); //根据记录总数除以每页显示的记录数求出所分的页数
$offset=($page-1)*$page_size; //计算下一页从第几条数据开始循环
for ($i=1; $i<2; $i++){ //计算每页显示几行记录信息
if ($i==1){
$sql=mysql_query("select * from tb_friend where username='$_SESSION[username]' order by id desc limit $offset, $page_size");
$result=mysql_fetch_array($sql);
}
do{
?>
<tr>
<td height="140" align="center" valign="top" ><table width="500" border="1" align=center cellpadding=3 cellspacing=2 bordercolor="#FFFFFF" bgcolor="#FFFFFF" class=i_table>
<tr bgcolor="#FFFFFF">
<td width=13% align="center" valign=middle> 编
号</td>
<td width=8% align="left"><?php echo $result[id]; ?></td>
<td width=10% align="center">姓
名</td>
<td width=13% align="left"><?php echo $result[name]; ?></td>
<td width=13% align="center"><span class="f_one">性
别</span></td>
<td width=9% align="left"><?php
if($result[regsex]==0){
echo "保密";
}
if($result[regsex]==1){
echo "男";
}
if($result[regsex]==2){
echo "女";
}
?></td>
<td width=15% align="center">生
日</td>
<td width=19% align="left"><?php echo $result[bir]; ?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width=13% align="center" valign=middle>所在城市</td>
<td colspan="3" align="left"><?php echo $result[city]; ?></td>
<td align="center">家庭住址</td>
<td colspan="3" align="left"><?php echo $result[address]; ?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center">邮政编码</td>
<td colspan="2" align="left"><?php echo $result[postcode]; ?></td>
<td align="center">家庭电话</td>
<td colspan="4" align="left"><?php echo $result[tel]; ?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center">e-mail</td>
<td colspan="7" align="left"><?php echo $result[email]; ?></td>
</tr>
<tr bgcolor="#FFFFFF">
<td align="center" valign=middle>手机号码</td>
<td colspan="3" align="left"><?php echo $result[handset]; ?></td>
<td align="center">QQ号</td>
<td colspan="2" align="left"><?php echo $result[QQ]; ?></td>
<td align="left">
<?php
if (isset($_SESSION[username])){
?>
<a href="del_friend.php?friend_id=<?php echo $result[id]?>"><img src="images/A_delete.gif" width="52" height="16" alt="删除朋友信息" onClick="return fri_chk();"></a>
<?php
}
?>
</td>
</tr>
</table>
</td>
</tr>
<?php
}while($result=mysql_fetch_array($sql));
?>
</table>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr bgcolor="#EFF7DE">
<td> 页次：<?php echo $page;?>/<?php echo $page_count;?>页
记录：<?php echo $message_count;?> 条 </td>
<td align="right" class="hongse01">
<?php
if($page!=1)
{
echo "<a href=browse_fri.php?page=1>首页</a> ";
echo "<a href=browse_fri.php?page=".($page-1).">上一页</a> ";
}
if($page<$page_count)
{
echo "<a href=browse_fri.php?page=".($page+1).">下一页</a> ";
echo "<a href=browse_fri.php?page=".$page_count.">尾页</a>";
}
}
}
?>
</td>
</tr>
</table></td>
</tr>
</table>
<br></td>
</tr>
</table></TD>
</TR>
</TBODY>
</TABLE>
</body>
</html>