php练习
<head> <style type="text/css"> .test { width:200px; height:50px; float:left; } </style> </head>
<body> <div class="test">AA</div> <div class="test">BB</div> <div class="test">CC</div> <div class="test">DD</div> <div class="test">EE</div> <div class="test">FF</div> <div style="clear:both"></div> <div style="width:100px; height:100px; background-color:#03C">TEST</div> </body>
<style type="text/css"> * { margin:0px auto; padding:0px; } .hy { width:200px; height:50px; margin-top:5px; } .hy:hover { background-color:#60C; cursor:pointer; color:white; } .pic { width:50px; height:50px; float:left; } .nk { height:50px; width:130px; float:left; margin-left:20px; line-height:50px; vertical-align:middle; } </style> </head> <body>
<?php
$uid = "18653378660"; //登录者
?>
<?php
//1.造连接对象 $db = new MySQLi("localhost","root","123","weixin"); //2.判断连接是否出错 !mysqli_connect_error() or die("连接失败!"); //3.写SQL语句 $sql = "select Friends from Friends where Uid='{$uid}'"; //4.执行SQL语句 $result = $db->query($sql); //5.从结果集中读取数据 $attr = $result->fetch_all(); //var_dump($attr); //循环读取好友的用户名 foreach($attr as $v) { $fuid = $v[0]; //好友用户名 //根据好友的用户名去查Users表查出昵称和头像 $sqlu = "select NickName,Pic from Users where Uid='{$fuid}'"; $r = $db->query($sqlu); $attru = $r->fetch_row(); echo "<div class='hy' onclick='Select(this)'> <div class='pic'><img src='{$attru[1]}' width='50' height='50' /></div> <div class='nk'>{$attru[0]}</div> </div>"; }
?>
</body> <script type="text/javascript"> function Select(aa) { //清除原选中状态 var div = document.getElementsByClassName("hy"); for(var i=0; i<div.length;i++) { div[i].style.backgroundColor = "white"; div[i].style.color = "#000000"; } //设置选中 aa.style.backgroundColor = "#60C"; aa.style.color = "white"; } </script>
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步