实现微信好友列表的php代码

  1 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2 <html xmlns="http://www.w3.org/1999/xhtml">
  3 <head>
  4 <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  5 <title>无标题文档</title>
  6 <style type="text/css">
  7 *
  8 {
  9     margin:0px auto;
 10     padding:0px;
 11     font-family:微软雅黑;
 12 }
 13 #list
 14 {
 15     350px; height:400px;
 16 }
 17 .py
 18 {
 19     margin:8px 0px 0px 0px;
 20     350px; height:35px;
 21 }
 22 .py:hover
 23 {
 24     background-color:#639;
 25     color:#FFF;
 26     cursor:pointer;
 27 }
 28 .img
 29 {
 30     35px; height:35px;
 31     float:left;
 32 }
 33 .nc
 34 {
 35     float:left;
 36     height:35px;
 37     margin:0px 0px 0px 20px;
 38     line-height:35px;
 39     vertical-align:middle;
 40 }
 41 </style>
 42 </head>
 43 
 44 <body>
 45 <?php
 46     $uid = "18653378660";
 47 ?>
 48 
 49 <div id="list">
 50 
 51 <?php
 52     //造连接对象
 53     $db = new MySQLi("localhost","root","123","weixin");
 54     //判断是否连接成功
 55     !mysqli_connect_error() or die("连接失败！");
 56     //写SQL语句
 57     $sql = "select Friends from friends where Uid = '{$uid}'";
 58     //执行SQL语句
 59     $result = $db->query($sql);
 60     
 61     $attr = $result->fetch_all();
 62     
 63     for($i=0;$i<count($attr);$i++)
 64     {
 65         //朋友的用户名
 66         $fuid = $attr[$i][0];
 67         
 68         //查USERS表，根据朋友的UID查出头像和昵称
 69         $sqlf = "select NickName,Pic from Users where Uid='{$fuid}'";
 70         
 71         $resultf = $db->query($sqlf);
 72         
 73         $attrf = $resultf->fetch_row();
 74         
 75         echo "<div onclick='ShowCode(this)' class='py' bs='{$fuid}'>
 76         <img class='img' src='{$attrf[1]}' />
 77         <div class='nc'>{$attrf[0]}</div>
 78         </div>";
 79         
 80     }
 81     
 82     
 83     
 84 ?>
 85     
 86 </div>
 87 <script type="text/javascript">
 88     
 89     function ShowCode(div)
 90     {
 91         var d = document.getElementsByClassName("py");
 92         for(var i=0; i<d.length;i++)
 93         {
 94             d[i].style.backgroundColor = "#FFF";
 95             d[i].style.color = "#000";
 96         }
 97         div.style.backgroundColor = "#639";
 98         div.style.color = "#FFF";
 99         
100         alert(div.getAttribute("bs"));
101     }
102     
103 </script>
104 </body>
105 </html>