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 width:350px; height:400px; 16 } 17 .py 18 { 19 margin:8px 0px 0px 0px; 20 width:350px; height:35px; 21 } 22 .py:hover 23 { 24 background-color:#639; 25 color:#FFF; 26 cursor:pointer; 27 } 28 .img 29 { 30 width: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>