user_report.php
来自「程序脚本为PHP+MYSQL」· PHP 代码 · 共 120 行
PHP
120 行
<?php
session_start();
include("../inc/conn.php");
include("check.php");
$user=$_SESSION["user"];
include("../inc/base_status.inc.php");
$menu="查看用户公告";
mysql_query("update online set title='$menu' where user_account='$user'",$conn);
$sq="where sign='2' or users='$user'";
$pagesize=15;
$sqlc=mysql_query("select count(*) from report $sq",$conn);
$myrow=mysql_fetch_array($sqlc);
$numrows=$myrow[0];
$pages=intval($numrows/$pagesize);
if ($numrows%$pagesize) $pages++;
if (isset($_GET['page']))
{
$page=intval($_GET['page']);
}
else{
$page=1;
}
$offset=$pagesize*($page - 1);
$sql=mysql_query("select * from report $sq order by time desc limit $offset,$pagesize",$conn);
?>
<head>
<link href="../css/css2.CSS" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
<style type="text/css">
<!--
body {
margin-left: 10px;
}
-->
</style></head>
<body><br>
<table width="90%" border="0" cellpadding="0" cellspacing="0" >
<tr>
<td><table width="100%" height="94" border="0" cellpadding="0" cellspacing="1" class="t12">
<tr class="t11">
<td height="21" colspan="3">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="80%"><strong><span class="fw12">公告</span></strong></td>
<td width="20%"><div align="center"></div></td>
</tr>
</table></td>
</tr>
<tr class="t12">
<td height="23"><div align="center" class="fw12">序号</div></td>
<td width="503"><div align="left" class="fw12">公告内容</div></td>
<td width="134" valign="middle"><div align="center" class="fw12">时间</div> <div align="center" class="fw12"></div></td>
</tr><?php $i=0;
while($rs=mysql_fetch_array($sql))
{ $i++;?>
<tr class="t17">
<td width="63" height="24"><div align="center"><?=$i?></div></td>
<td><?=$rs["report_content"]?> </td>
<td align="center" valign="middle"><?=$rs["time"]?> </td>
</tr><? }?>
<tr>
<td height="21" colspan="3" class="t11"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<form name="form1">
<td> <?
$fp="report_manage.php";
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page>1)
{
echo "<a href='".$fp."?page=".$first."' class='aw'>第一页</a> ";
echo "<a href='".$fp."?page=".$prev."' class='aw'>上一页</a> ";
}else
{
echo "<font color='#ffffff'>第一页 上一页</font> ";
}
if ($page<$pages)
{
echo "<a href='".$fp."?page=".$next."' class='aw'>下一页</a> ";
echo "<a href='".$fp."?page=".$last."' class='aw'>最终页</a> ";
} else
{
echo "<font color='#ffffff'>下一页 最终页</font> ";
}
$nums=$pagesize*$pages;
?><span class="fw12"> 页次：</span>
<select name="menu1" onChange="MM_jumpMenu('self',this,0)">
<?php for ($i=1;$i<=$pages;$i++)
{
if($page==$i)
{ $se="selected";
}else $se="";
echo "<option value='".$fp."?page=".$i."' ".$se.">".$i."</option>";
}
?>
</select>
</td>
</form>
<td><div align="right"><span class="fw12">共 <strong><?=$pages?></strong> 页</span><span class="fw12"> </span></div></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?