📄 display_contact.php
字号:
<? ob_start(); ?>
<?
include "Sysconf.php";
$user_name=$_COOKIE["username"];
$contact = $_REQUEST["all_contact"];
$num_per_page = 10;
$rel=$_COOKIE["rel"];
$Relation=array('jiaren'=>'家人','tongshi'=>'同事','haoyou'=>'好友','tongxue'=>'同学');
$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");
$pagenum=$_GET["pagenum"];//接收从下边链接传来的值
if(!isset($pagenum)|| $pagenum==0) $pagenum=1;//默认第一页
$start=($pagenum-1)*$num_per_page ;//起始点
$sql_user_id="select user_id from user_base_information where user_name='$user_name' ;";
$result_user_id=mysql_query($sql_user_id);
$local_id=mysql_result($result_user_id,0,"user_id");
/////////////////////////////功能代码 ////////////////////////////
if($contact=="suoyou")
{
setcookie("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>";
/*
$sql0 ="select contact_id from contact_man where local_id=$local_id;";
$result0 = mysql_query($sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
//echo $n."yeshu ="."$num"."*****";
//不支持IN语句,先把子查询的结果弄出来,用数组存着.
$sql1 ="select contact_id from contact_man where local_id= '$local_id' 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($contact=="tongshi")
{
setcookie("rel","同事");
$sql0 ="select contact_id from contact_man where local_id= '$local_id' and relation = '$contact';";
$result0 = mysql_db_query('post_information',$sql0);
$n = mysql_num_rows($result0); // 总记录个数
$num=ceil($n/$num_per_page );//总页数
//echo $n."yeshu ="."$num"."*****";
//不支持IN语句,先把子查询的结果弄出来,用数组存着.
$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($contact=="jiaren")////////////////////从家人开始均为粘贴的代码(家人,同学,好友)/////////////
{
setcookie("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 );//总页数
//echo $n."yeshu ="."$num"."*****";
//不支持IN语句,先把子查询的结果弄出来,用数组存着.
$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 "</center></table>";
}
else
if($contact=="tongxue")
{
setcookie("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 );//总页数
//echo $n."yeshu ="."$num"."*****";
//不支持IN语句,先把子查询的结果弄出来,用数组存着.
$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($contact=="haoyou")
{
setcookie("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 );//总页数
//echo $n."yeshu ="."$num"."*****";
//不支持IN语句,先把子查询的结果弄出来,用数组存着.
$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>";
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -