user_report.php
上传用户:m68239277
上传日期:2014-10-12
资源大小:824k
文件大小:4k
源码类别:

Web服务器

开发平台:

PHP

  1. <?php 
  2. session_start();
  3. include("../inc/conn.php");
  4. include("check.php");
  5. $user=$_SESSION["user"];
  6. include("../inc/base_status.inc.php");
  7. $menu="查看用户公告";
  8. mysql_query("update online set title='$menu' where user_account='$user'",$conn);
  9. $sq="where sign='2' or users='$user'";
  10. $pagesize=15;
  11. $sqlc=mysql_query("select count(*) from report $sq",$conn);
  12. $myrow=mysql_fetch_array($sqlc);
  13. $numrows=$myrow[0];
  14. $pages=intval($numrows/$pagesize);
  15. if ($numrows%$pagesize) $pages++;
  16. if (isset($_GET['page'])) 
  17. $page=intval($_GET['page']);
  18. }
  19. else{
  20. $page=1;
  21. }
  22. $offset=$pagesize*($page - 1); 
  23. $sql=mysql_query("select * from report $sq order by time desc limit $offset,$pagesize",$conn); 
  24. ?>
  25. <head>
  26. <link href="../css/css2.CSS" rel="stylesheet" type="text/css">
  27. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  28. <script language="JavaScript" type="text/JavaScript">
  29. <!--
  30. function MM_jumpMenu(targ,selObj,restore){ //v3.0
  31.   eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
  32.   if (restore) selObj.selectedIndex=0;
  33. }
  34. //-->
  35. </script>
  36. <style type="text/css">
  37. <!--
  38. body {
  39. margin-left: 10px;
  40. }
  41. -->
  42. </style></head>
  43. <body><br>
  44. <table width="90%" border="0" cellpadding="0" cellspacing="0"  >
  45.   <tr>
  46.     <td><table width="100%" height="94" border="0" cellpadding="0" cellspacing="1" class="t12">
  47.         <tr class="t11">
  48.           <td height="21" colspan="3">
  49.             <table width="100%" border="0" cellspacing="0" cellpadding="0">
  50.               <tr>
  51.                 <td width="80%"><strong><span class="fw12">公告</span></strong></td>
  52.                 <td width="20%"><div align="center"></div></td>
  53.               </tr>
  54.             </table></td>
  55.         </tr>
  56.         <tr class="t12">
  57.           <td height="23"><div align="center" class="fw12">序号</div></td>
  58.           <td width="503"><div align="left" class="fw12">公告内容</div></td>
  59.           <td width="134" valign="middle"><div align="center" class="fw12">时间</div>            <div align="center" class="fw12"></div></td>
  60.         </tr><?php $i=0;
  61.  while($rs=mysql_fetch_array($sql))
  62. { $i++;?>
  63.         <tr class="t17">
  64.           <td width="63" height="24"><div align="center"><?=$i?></div></td>
  65.           <td><?=$rs["report_content"]?>   </td>
  66.           <td align="center" valign="middle"><?=$rs["time"]?>             </td>
  67.         </tr><? }?>
  68.         <tr> 
  69.           <td height="21" colspan="3" class="t11"><table width="100%" border="0" cellspacing="0" cellpadding="0">
  70.                 <tr>
  71.                   <form name="form1">
  72.                     <td> <? 
  73. $fp="report_manage.php";
  74. $first=1;
  75. $prev=$page-1;
  76. $next=$page+1;
  77. $last=$pages;
  78. if ($page>1)
  79. {
  80. echo "<a href='".$fp."?page=".$first."' class='aw'>第一页</a>&nbsp;&nbsp;";
  81. echo "<a href='".$fp."?page=".$prev."' class='aw'>上一页</a>&nbsp;&nbsp;";
  82. }else
  83. {
  84.  echo "<font color='#ffffff'>第一页&nbsp;&nbsp;上一页</font>&nbsp;&nbsp;";
  85. }
  86. if ($page<$pages)
  87. {
  88. echo "<a href='".$fp."?page=".$next."' class='aw'>下一页</a>&nbsp;&nbsp;";
  89. echo "<a href='".$fp."?page=".$last."' class='aw'>最终页</a>&nbsp;&nbsp;";
  90. } else
  91. {
  92.  echo "<font color='#ffffff'>下一页&nbsp;&nbsp;最终页</font>&nbsp;&nbsp;";
  93. }
  94. $nums=$pagesize*$pages;
  95. ?><span class="fw12"> 页次:</span>
  96.                       <select name="menu1" onChange="MM_jumpMenu('self',this,0)">
  97.                         <?php for ($i=1;$i<=$pages;$i++) 
  98. {
  99. if($page==$i)
  100. { $se="selected";
  101. }else $se="";
  102.                        echo "<option value='".$fp."?page=".$i."' ".$se.">".$i."</option>"; 
  103.    }
  104.         ?>
  105.                       </select>
  106. </td>
  107.                   </form>
  108.                   <td><div align="right"><span class="fw12">共 <strong><?=$pages?></strong> 页</span><span class="fw12">&nbsp;&nbsp;</span></div></td>
  109.                 </tr>
  110.               </table></td>
  111.         </tr>
  112.        
  113.     </table></td>
  114.   </tr>
  115. </table>
  116. </body>