yhgl.php

论坛管理系统php＋mysql

<?php include "hyyz.php";
if ($record==1) {?>
<style type="text/css">
<!--
a:link {
	color: #000000;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
}
a:hover {
	text-decoration: none;
}
a:active {
	text-decoration: none;
	color: #000000;
}
.style4 {font-size: 13px;
	font-family: "宋体";
	font-weight: normal;
}
.style5 {font-size: 12px}
-->
</style><table width="590" border="0" cellpadding="0" cellspacing="0" bgcolor="#EFF3FF">
  <tr>
    <td width="90" height="30">&nbsp;</td>
    <td width="90">用户管理</td>
    <td width="90">&nbsp;</td>
    <td width="110">&nbsp;</td>
    <td width="40">&nbsp;</td>
    <td width="100">&nbsp;</td>
    <td width="70">&nbsp;</td>
  </tr>
  <tr align="center">
    <td height="30" class="style4">用户名</td>
    <td class="style4">真实姓名</td>
    <td colspan="2" class="style4">地址</td>
    <td class="style4">性别</td>
    <td class="style4">电话</td>
    <td class="style4">是否删除</td>
  </tr>
  <?php 
  if($page){
     $page_size=15;
	 $query="select count(*) total from hw_user where id";
	 $result=mysql_query($query);
	 $message_count=mysql_result($result,0,"total");
	 $page_count=ceil($message_count/$page_size);
	 $offset=($page-1)*$page_size;
	 $query="select * from hw_user where id order by id desc limit $offset,$page_size";
	 $result=mysql_query($query);
	 if($result){
	 while($myrow=mysql_fetch_array($result)){
  ?>
  <tr align="center" onMouseMove="this.bgColor='#D7F2FF'" onMouseOut="this.bgColor='#FFD9D9'">
    <td height="30"><span class="style5"><?php echo $myrow[username];?></span></td>
    <td class="style5"><?php echo $myrow[zsxm];?></td>
    <td colspan="2" class="style5"><?php echo $myrow[lxdz];?></td>
    <td class="style5"><?php echo $myrow[sex];?></td>
    <td class="style5"><?php echo $myrow[lxdh]?></td>
    <td><a href="delete.php?lmbs=<?php echo urlencode(用户管理);?>&id=<?php echo $myrow[id];?>" class="style5">删除</a></td>
  </tr>
  <?php }}}?>
  <tr>
    <td height="30" colspan="7"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr class="style4">
        <td width="50%" class="#ff0000">&nbsp;&nbsp;页次：<font class="#ff0000"><?php echo $page;?></font> / <font class="#ff0000"><?php echo $page_count;?> </font>页 记录：<font class="#ff0000"><?php echo $message_count;?> </font>条&nbsp; </td>
        <td width="39%" class="#ff0000"> 分页：
            <?php
			    $lm=urlencode($lmbs);
       	        $xsoudh="lmbs=$lm";
				$next=$ljjl*10;
				$n=$ljjl-1;
				$m=$ljjl+1;	
                $prev_page=$page-10;						
					if ($ljjl==0){
                    echo "<img src=\"images/02.jpg\" width=\"8\" height=\"9\" title=\"首页\">";					
					}else
					{
                     echo "<a href='$PATH_INFO?vv=0&ljjl=0&page=1&$xsoudh'><img src=\"images/02.jpg\" width=\"8\" height=\"9\" border=\"0\" title=\"首页\"></a>&nbsp;";
					 $ccc=$vv-10;
                     echo "<a href='$PATH_INFO?vv=$ccc&ljjl=$n&page=$prev_page&$xsoudh' class=\"heise01\"><img src=\"images/01.jpg\" width=\"8\" height=\"9\" title=\"上十页\"></a>";
					}?>
            <?php	
 		        for ($j=1;$j<=$page_count;$j++) {
				       $pnext=$next+$j;
				       if ($mm==10){
					       break;
					   }
						if ($mm>$page_count){
							break;
						}
						if ($page_count-$vv<10){
	  						if ($mm>=$page_count-$vv){
								break;
							}									
						}
						?>
            <?php
                        echo "<a href='$PATH_INFO?vv=$vv&ljjl=$ljjl&page=$pnext&$xsoudh' class=\"huise01\"> $pnext </a>";											
              	        $mm=$mm+1;						
	     	     }
				 ?>
        </td>
        <td width="11%">
          <?php
				$vv=$vv+$mm;
				       if ($page_count-$vv<=0){
	                       echo "<img src=\"images/03.jpg\" width=\"8\" height=\"9\" title=\"尾页\">";					
					   }else{
	                       echo "<a href='$PATH_INFO?vv=$vv&ljjl=$m&page=$pnext&$xsoudh' class=\"huise01\"><img src=\"images/03.jpg\" width=\"8\" height=\"9\" title=\"下十页\"></a>";														
					   }
                if ($message_count==0){
					     echo "<font class=\"huise01\">没有记录!</font>";
				}
?>
        </td>
      </tr>
    </table></td>
  </tr>
</table>
<?php }else{
include "yzdl.php";
}
?>