📄 inc46.php
字号:
<?php
require_once('conn.php');
session_start();
if (empty($_SESSION['web']))
{
header("Location: index2.php");
}
?>
<HTML>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Manager System 2007</title>
<script Language="JavaScript" src="no-copying2.js"></script>
<style type="text/css">
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
TD {
font-family:Arial;
font-size:12px
}
A:link {
COLOR: #0000FF; TEXT-DECORATION: none
}
A:visited {
COLOR: #0000FF; TEXT-DECORATION: none
}
A:hover {
COLOR: #0000FF; TEXT-DECORATION: underline
}
A:active {
COLOR: #0000FF; TEXT-DECORATION: underline
}
</style>
<style type="text/css">
#Lay {
position:absolute;
width:200px;
height:115px;
z-index:1;
}
</style>
</head>
<center>
<table width="880" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="34">
报表 </td>
</tr>
</table>
<table width="880" border="0" cellpadding="4" cellspacing="1" bgcolor="#000066">
<tr>
<td align="center" bgcolor="#375d9e"><font color="#FFFFFF">编号</font></td>
<td align="center" bgcolor="#375d9e"><font color="#FFFFFF">时间</font></td>
<td align="center" bgcolor="#375d9e"><font color="#FFFFFF">期数</font></td>
<td align="center" bgcolor="#375d9e"><font color="#FFFFFF">帐号</font></td>
<td width="200" align="center" bgcolor="#375d9e"><font color="#FFFFFF">类别</font></td>
<td width="200" align="center" bgcolor="#375d9e"><font color="#FFFFFF">详细</font></td>
<td align="center" bgcolor="#375d9e"><font color="#FFFFFF">注额</font></td>
<td align="center" bgcolor="#375d9e"><font color="#FFFFFF">结果</font></td>
</tr>
<?php
//单个会员
$exec3="Select * from z where name='".$_GET['name']."' and qi='#".$_GET['qi']."' order by id";
mysql_query("set names gbk");
$resu3=mysql_query($exec3);
$jinz=0;
$i=1;
while($rs3=mysql_fetch_object($resu3))
{
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><?php Echo $i;?>
<a href="qingchuz.php?id=<?php Echo $rs3->id;?>&name=<?php Echo $_GET['name'];?>&qi=<?php Echo $_GET['qi'];?>" onClick="return confirm('确定要清除吗?');" style="color:#CC0000">清除记录</a></td>
<td align="center" bgcolor="#FFFFFF"><?php Echo $rs3->shi;?></td>
<td align="center" bgcolor="#FFFFFF"><?php Echo $rs3->qi;?></td>
<td align="center" bgcolor="#FFFFFF"><?php Echo $rs3->name;?></td>
<td align="center" bgcolor="#FFFFFF">
<?php Echo $rs3->s;?>
<font color="#FF0000"><?php Echo $rs3->c;?>/<?php Echo $rs3->c2;?></font><br>
<?php Echo $rs3->sn;?>
</td>
<td align="center" bgcolor="#FFFFFF">
<script>drawstart('<?php Echo $rs3->sz;?>');</script>
@
<font color="#FF0000"><?php Echo $rs3->p;?></font>
</td>
<td align="center" bgcolor="#FFFFFF"><?php Echo $rs3->jin;?></td>
<td align="center" bgcolor="#FFFFFF">
<?php Echo $rs3->jie;?>
<font color="#FF0000">/</font>
<?php Echo $rs3->jie2;?></td>
</tr>
<?php
$jinz=$jinz+$rs3->jin;
$jiez=$jiez+$rs3->jie;
$jie2z=$jie2z+$rs3->jie2;
$i=$i+1;
}
?>
<tr>
<td bgcolor="#d7d7d7"> </td>
<td bgcolor="#d7d7d7"> </td>
<td bgcolor="#d7d7d7"> </td>
<td bgcolor="#d7d7d7"> </td>
<td bgcolor="#d7d7d7"> </td>
<td bgcolor="#d7d7d7"> </td>
<td align="center" bgcolor="#d7d7d7">
<strong style="color:#FF0000"><?php Echo $jinz;?></strong></td>
<td align="center" bgcolor="#d7d7d7">
<strong style="color:#FF0000"><?php Echo $jiez;?> / <?php Echo $jie2z;?></strong><br>
<strong style="color:#FF0000">结果:<?php Echo ($jiez+$jie2z);?></strong></td>
</tr>
</table>
<?php
$exec="Select * from sz";
mysql_query("set names gbk");
$resu=mysql_query($exec);
$rs=mysql_fetch_object($resu);
$qi2=$rs->qi;
$shi2=$rs->shi;
$oo2=$rs->oo;
$content2=$rs->content;
?>
<?php
$as="#".$_GET['qi'];
if ($as==$qi2)
{
$exec="update edu set yu=(edu-".$jinz.") where name='".$_GET['name']."'";
mysql_query("set names gbk");
mysql_query($exec);
}
?>
<br>
<br>
</center>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -