📄 display_contact.php
字号:
echo "</tr>";
}
echo "</table></center>";
}
else if($rel=="所有"){
// 直接从上面粘贴的代码，没改动。
$sql0= "select user_name,relation
from user_base_information nature join contact_man
on user_id = contact_id
and local_id = $local_id;";
//执行sql
$result0=mysql_query($sql0);
//结果包括2个域：名字和关系
//结果的总行数为：
$n=mysql_num_rows($result0);
//总页数为：
$num=ceil($n/$num_per_page );
////////////////////////
// echo "*****$n****$num****";
///////////////////////////
$sql= "select user_name,relation,contact_id
from user_base_information nature join contact_man
on user_id = contact_id
and local_id = $local_id
limit $start,$num_per_page;";
//执行
$result=mysql_query($sql);
//取结果的总行数
$num_rows=mysql_num_rows($result);
//取结果的域
$m = mysql_num_fields($result);
// echo "***************$num_rows***********$m***";
//for循环处理每一行,输出
echo "<center><table border='0'>";
echo "<tr><td align=center><img src= moren/button2o.jpg></td>
<td align=center>   <img src= moren/button_relation.jpg>   </td>
<td align=center><img src= moren/button5o.jpg></td>
</tr>";
for($i=0;$i<$num_rows;$i++){
$A=mysql_fetch_row($result);//取一行
echo "<tr>";
for($j=0;$j<$m-1;$j++){//输出前2个域 if($j==1){ $t=$A[$j]; echo "<td align=center>$Relation[$t]</td>"; }
else
echo "<td align=center>$A[$j]</td>";
}
$delete=$A[2].";$A[1]"; //$A[2]为contact_id,[1]为关系relation.
// echo $delete;
echo "<td align=center><a href=delete_contact.php?name=$delete>删除</td>";
echo "</tr>";
}
echo "</table>";
/*
$sql_id="select user_id from user_base_information where user_name='$user_name';";
$result=mysql_query($sql_id);
$user_id=mysql_result($result,0,"user_id");
$sql0 ="select contact_id from contact_man where local_id=$user_id;";
$sql0 ="select contact_id from contact_man where local_id='$user_id';";
$result0 = mysql_query($sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
$sql1 ="select contact_id from contact_man where local_id='$user_id' limit $start,$num_per_page ;";
$result1 = mysql_query($sql1);
$num_rows = mysql_num_rows($result1);
echo "<center><table border='0'>";
echo "<tr><th align=center>   <img src= moren/button2o.jpg>   </td>
<td align=center>   <img src= moren/button5o.jpg>   </td>
</tr>";
for($i=0;$i<$num_rows ;$i++){//子查询有N行,对每行的结果要查询一次.
$subA = mysql_fetch_row($result1);//子查询结果的一行.
$sql = "select user_name from user_base_information
where user_id in ($subA[0]); ";//$subA[0]中存放contact_id
$result=mysql_query($sql); //// 一行
$A=mysql_fetch_row($result); //// 一行
$m = mysql_num_fields($result); // 有多少列
echo "<tr>";
for($j=0;$j<$m;$j++)
{
echo "<td align=center>".$A[$j]."</td>";
echo "<td align=center><a href=delete_contact.php?name=$subA[0]>删除</td>";
}
echo "</tr>";
}
echo "</center></table>";
*/
}else if($rel=="同事"){
$sql0 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ';";
$result0 = mysql_query($sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
$sql1 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact '
limit $start,$num_per_page ;";
$result1 = mysql_query($sql1);
$num_rows = mysql_num_rows($result1);
echo "<center><table border='0'>";
echo "<tr><td align=center>   <img src= moren/button2o.jpg>   </td>
<td align=center>   <img src= moren/button5o.jpg>   </td>
</tr>";
for($i=0;$i<$num_rows ;$i++){//子查询有N行,对每行的结果要查询一次.
$subA = mysql_fetch_row($result1);//子查询结果的一行.
$sql = "select user_name from user_base_information
where user_id in ($subA[0]); ";//$subA[0]中存放contact_id
$result=mysql_query($sql); //// 一行
$A=mysql_fetch_row($result); //// 一行
$m = mysql_num_fields($result); // 有多少列
echo "<tr>";
for($j=0;$j<$m;$j++)
{
echo "<td align=center>".$A[$j]."</td>";
$delete=$subA[0].";同事";
echo "<td align=center><a href=delete_contact.php?name=$delete>删除</td>";
}
echo "</tr>";
}
echo "</table></center>";
}else if($rel=="家人"){
$sql0 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ';";
$result0 = mysql_query($sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
$sql1 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ' limit $start,$num_per_page ;";
$result1 = mysql_query($sql1);
$num_rows = mysql_num_rows($result1);
echo "<center><table border='0'>";
echo "<tr><td align=center><img src= moren/button2o.jpg></td>
<td align=center><img src= moren/button5o.jpg></td>
</tr>";
for($i=0;$i<$num_rows ;$i++){//子查询有N行,对每行的结果要查询一次.
$subA = mysql_fetch_row($result1);//子查询结果的一行.
$sql = "select user_name from user_base_information
where user_id in ($subA[0]); ";//$subA[0]中存放contact_id
$result=mysql_query($sql); //// 一行
$A=mysql_fetch_row($result); //// 一行
$m = mysql_num_fields($result); // 有多少列
echo "<tr>";
for($j=0;$j<$m;$j++)
{
echo "<td align=center>".$A[$j]."</td>";
$delete=$subA[0].";家人";
echo "<td align=center><a href=delete_contact.php?name=$delete>删除</td>";
}
echo "</tr>";
}
echo "</table></center>";
}else if($rel=="同学"){
$sql0 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ';";
$result0 = mysql_query($sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
$sql1 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ' limit $start,$num_per_page ;";
$result1 = mysql_query($sql1);
$num_rows = mysql_num_rows($result1);
echo "<center><table border='0'>";
echo "<tr><td align=center>   <img src= moren/button2o.jpg>   </td>
<td align=center>   <img src= moren/button5o.jpg>   </td>
</tr>";
for($i=0;$i<$num_rows ;$i++){//子查询有N行,对每行的结果要查询一次.
$subA = mysql_fetch_row($result1);//子查询结果的一行.
$sql = "select user_name from user_base_information
where user_id in ($subA[0]); ";//$subA[0]中存放contact_id
$result=mysql_query($sql); //// 一行
$A=mysql_fetch_row($result); //// 一行
$m = mysql_num_fields($result); // 有多少列
echo "<tr>";
for($j=0;$j<$m;$j++)
{
echo "<td align=center>".$A[$j]."</td>";
$delete=$subA[0].";同学";
echo "<td align=center><a href=delete_contact.php?name=$delete>删除</td>";
}
echo "</tr>";
}
echo "</table></center>";
}else if($rel=="好友"){
$sql0 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ';";
$result0 = mysql_query($sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
$sql1 ="select contact_id from contact_man where local_id='$local_id' and relation = '$contact ' limit $start,$num_per_page ;";
$result1 = mysql_query($sql1);
$num_rows = mysql_num_rows($result1);
echo "<center><table border='0'>";
echo "<tr><td align=center>   <img src= moren/button2o.jpg>   </td>
<td align=center>   <img src= moren/button5o.jpg>   </td>
</tr>";
for($i=0;$i<$num_rows ;$i++){//子查询有N行,对每行的结果要查询一次.
$subA = mysql_fetch_row($result1);//子查询结果的一行.
$sql = "select user_name from user_base_information
where user_id in ($subA[0]); ";//$subA[0]中存放contact_id
$result=mysql_query($sql); //// 一行
$A=mysql_fetch_row($result); //// 一行
$m = mysql_num_fields($result); // 有多少列
echo "<tr>";
for($j=0;$j<$m;$j++)
{
echo "<td align=center>".$A[$j]."</td>";
$delete=$subA[0].";好友";
echo "<td align=center><a href=delete_contact.php?name=$delete>删除</td>";
}
echo "</tr>";
}
echo "</table></center>";
}
echo "<hr>";
echo "<center>";
if($pagenum!=1)
{
echo "<a href=display_contact.php?pagenum=1>第一页</a>"."\t";
}
else
{
echo "第一页"."\t";
}
if($pagenum>1)
{
echo "<a href=display_contact.php?pagenum=".($pagenum-1).">上一页</a>"."\t";
}
else
{
echo "上一页"."\t";
}
if($pagenum<$num)
{
echo "<a href=display_contact.php?pagenum=".($pagenum+1).">下一页</a>"."\t";
}
else
{
echo "下一页"."\t";
}
if($pagenum!=$num)
{
echo "<a href=display_contact.php?pagenum=$num>最后一页</a>"."\t";
}
else
{
echo "最后一页"."\t";
}
echo "</center>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -