<?php<br />/**<br /> * 使用者管理<br /> * 2011/8/22<br /> * kcj<br /> *<br /> * */<br />include "isLogin.php";<br />include "../conn/conn.php";<br />$sql="select * from user";<br />$rst=mysql_query($sql);<br />$totalnum=mysql_num_rows($rst);<br />$pagesize=5;<br />$page=$_GET['page'];<br />if($page==''){<br />$page=1;<br />}<br />$begin=($page-1)*$pagesize;<br />$pagecount=ceil($totalnum/$pagesize);<br />?></p><p><html><br /><head><br /><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><br /><title>無標題文檔</title><br /><meta name="Author" content="kcj" /><br /><meta name="Keywords" content="php,kcj" /><br /><link rel="stylesheet" type="text/css" href="style/lampcms.css"><br /><script src="javascript/common0.js"></script><br /><script type="text/javascript"><br /> var checkall=document.getElementsByName("dell[]");<br /> function select(){ //全選<br /> for(var $i=0;$i<checkall.length;$i++){<br /> checkall[$i].checked=true;<br /> }<br /> }<br /> function fanselect(){ //反選<br /> for(var $i=0;$i<checkall.length;$i++){<br /> if(checkall[$i].checked){<br /> checkall[$i].checked=false;<br /> }else{<br /> checkall[$i].checked=true;<br /> }<br /> }<br /> }<br /> function noselect(){ //全不選<br /> for(var $i=0;$i<checkall.length;$i++){<br /> checkall[$i].checked=false;<br /> }<br /> }</p><p></script></p><p></head><br /><body><br /><div id="main"><br /> 後台管理->系統管理使用者<br /> <form method="post" action="" onsubmit="return confirm('你確定要刪除選中項嗎?')" ><br /><div class="msg-box"><br /><ul class="viewmess"><br /><li class="dark-row"><br /><span class="list_width width_font">使用者名稱</span><br /><span class="list_width width_font" style="width:200px">備忘名</span><br /><span class="list_width width_font">註冊時間</span><br /><span class="list_width width_font">操 作</span><br /></li><br /> <?php</p><p> if(isset($_POST['dell'])){ //大量刪除<br /> $ids=$_POST['dell'];<br /> $ids=implode(",", $ids); //implode函數 把數組元素組合為一個字串。<br /> $sql="delete from user where id in ($ids)";<br /> mysql_query($sql);<br /> }</p><p> if(isset($_GET['del'])){<br /> $id=$_GET['del'];<br /> $sql="delete from user where id=".$id;<br /> mysql_query($sql);<br /> }</p><p> $sql="select * from user order by id limit $begin,$pagesize";<br /> $rst=mysql_query($sql);<br /> while ($row=mysql_fetch_array($rst)){</p><p> ?><br /><li class="light-row" style="padding-top:2px; padding-bottom:2px"></p><p><span class="list_width" style="width:200px"><?php if($row['id']!=1){?><input type="checkbox" name="dell[]" value="<?php echo $row['id']?>"><?php }?><br /><?php echo $row['username']?></span><br /><span class="list_width"><?php echo $row['rname']?></span><br /> <span class="list_width"><?php echo substr($row['ctime'],0,10)?></span><br /><span class="list_width" style="width:160px;"></p><p>【<a href="editUser.php?edit=<?php echo $row['id']?>">修改</a>】<br /> <?php if($row['id']!=1){?><br />【<a onclick="return confirm('確定要刪除使用者<?php echo $row['username']?>嗎？')" href="listUser.php?del=<?php echo $row['id']?>">刪除</a>】<br /><?php<br /> }<br />?><br /></span><br /><?php<br /> }<br />?></p><p><li class="dark-row"><br /><span class="col_width" style="margin-left:15px;width:240px"><br /><a href="javascript:select()">全選</a>/<a href="javascript:fanselect()">反選</a>/<a href="javascript:noselect()">全不選</a> 選中項: </p><p><input name="dels" type="image" title="刪除" value="delete" src="images/delete.gif"> <br /> </span><br /><span class="right"><br />共 <b><?php echo $totalnum?></b> 個使用者,共<?php echo $pagecount;?>頁<br /><a href="<?php echo $_SERVER['PHP_SELF']."?page=1"?>">首頁</a></p><p><a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?php if($page<1) echo $page-1;else echo $page=1;?>">上一頁</a><br /><?php<br />for($i=1;$i<=$pagecount;$i++){ //$i<=$pagecount(必須是<=)<br />echo "<a href=".$_SERVER['PHP_SELF']."?page=$i".">[".$i."]</a>";<br />}</p><p>?><br /><a href="<?php echo $_SERVER['PHP_SELF']?>?page=<?PHP if($page<$pagecount-1) echo $page+1; else echo $pagecount;?>">下一頁</a><br /><a href="<?php echo $_SERVER['PHP_SELF']."?page={$pagecount}"?>">尾頁</a><br /></span><br /></li><br /></ul><br /></div><br /> </form><br /></div><br /></body><br /></html>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
