table.php
来自「程序脚本为PHP+MYSQL」· PHP 代码 · 共 179 行
PHP
179 行
<?php
session_start();
include("checks.php");
include("../inc/conn.php");
include("../inc/base_status.inc.php");
$_SESSION["menus"]="报表首页";
$sqlp=mysql_query("select * from ptime where sign='4'",$conn);
$opstate=mysql_result($sqlp,0,"opstate");
if($opstate==1)
{
$sqg=" where sign<>'1'";
}else $sqg="";
$sql=mysql_query("select * from results $sqg order by open_date desc",$conn);
$sqlt=mysql_query("select * from member_cut where user_account='admin' and sign<>'0' order by sign asc",$conn);
$sqlp=mysql_query("select * from results where sign<>'1' order by open_date desc",$conn);
$deleted=mysql_result($sqlp,0,"deleted");
$datesp=mysql_result($sqlp,0,"dates");
?>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css/css.CSS" rel="stylesheet" type="text/css">
<title><?=$titles?></title>
<style type="text/css">
<!--
body {
margin-left: 0px;
}
-->
</style>
</head>
<body oncontextmenu="return false" onselectstart="return false"
onkeydown="return (event.ctrlKey && event.keyCode == 78) ? false : true"
ondragstart="return false" onmouseover="window.status=''; return true">
<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#6a9bd8">
<tr>
<td width="9"> </td>
<form name="form1">
<td width="518" height="20" class="fw12">报表管理(搜寻)</td>
<td width="264" class="fw12"><div align="right"> </div></td>
</form>
<td width="10"> </td>
</tr>
</table>
<br>
<table width="797" height="125" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="125" valign="top"><table width="470" height="140" border="0" cellpadding="0" cellspacing="1" class="t12">
<form name="form2" method="post" action="table_manage_search.php">
<tr>
<td height="23" class="t11"><div align="center" class="fw12">
<div align="left">公司</div>
</div></td>
<td class="t15"> </td>
</tr>
<tr>
<td width="82" class="t11"><div align="left" class="fw12">报表类型</div></td>
<td width="385" class="t15"><select name="bill_type" id="bill_type">
<option value="1" selected>总账</option>
<option value="2">分类账</option>
</select></td>
</tr>
<tr>
<td class="t11"><div align="left" class="fw12">下注种类</div></td>
<td class="t15"><select name="down_type" id="down_type">
<option value="all" selected>全部</option>
<?php while($rowc=mysql_fetch_array($sqlt))
{ if($rowc["cut_unit"]=="特码A")
{
$ms="特码";
}else $ms=$rowc["cut_unit"];
echo "<option value='".$rowc["sign"]."'>".$ms."</option>";
}
?>
</select>
<span class="fred12"> </span></td>
</tr>
<tr>
<td class="t11"><div align="left" class="fw12">开始日期</div></td>
<td class="t15"><select name="start_time_y" id="start_time_y">
<?php for($y=2006;$y<=2020;$y++)
{
if($y==date(Y))
{$se="selected";
}else $se="";
echo "<option value='".$y."' ".$se.">".$y."</option>";
}
?>
</select>
<span class="fblue12">年</span> <select name="start_time_m" id="start_time_m">
<?php for($m=1;$m<=12;$m++)
{ if(strlen($m)==1)
{ $mm="0".$m;
}else $mm=$m;
if($m==date(m))
{$se="selected";
}else $se="";
echo "<option value='".$mm."' ".$se.">".$mm."</option>";
}
?>
</select>
<span class="fblue12">月</span> <select name="start_time_d" id="start_time_d">
<?php for($d=1;$d<=31;$d++)
{ if(strlen($d)==1)
{ $dd="0".$d;
}else $dd=$d;
if($d==date(d))
{$se="selected";
}else $se="";
echo "<option value='".$dd."' ".$se.">".$dd."</option>";
}
?>
</select>
<span class="fblue12">日</span> </td>
</tr>
<tr>
<td height="20" class="t11"><span class="fw12">结束日期</span></td>
<td class="t15"><select name="end_time_y" id="end_time_y">
<?php for($y=2006;$y<=2020;$y++)
{
if($y==date(Y))
{$se="selected";
}else $se="";
echo "<option value='".$y."' ".$se.">".$y."</option>";
}
?>
</select>
<span class="fred12">年</span>
<select name="end_time_m" id="select3">
<?php for($m=1;$m<=12;$m++)
{ if(strlen($m)==1)
{ $mm="0".$m;
}else $mm=$m;
if($m==date(m))
{$se="selected";
}else $se="";
echo "<option value='".$mm."' ".$se.">".$mm."</option>";
}
?>
</select>
<span class="fred12">月</span>
<select name="end_time_d" id="select4">
<?php for($d=1;$d<=31;$d++)
{ if(strlen($d)==1)
{ $dd="0".$d;
}else $dd=$d;
if($d==date(d))
{$se="selected";
}else $se="";
echo "<option value='".$dd."' ".$se.">".$dd."</option>";
}
?>
</select>
<span class="fred12">日</span> </td>
</tr>
<tr>
<td height="20" class="t11"><span class="fw12">期数</span></td>
<td class="t15"><select name="date_num" id="date_num">
<option value="no" selected>请选择期数</option>
<?php
while($row=mysql_fetch_array($sql))
{
echo "<option value='".$row["dates"]."' >".$row["dates"]."期 ".$row["open_date"]."</option>";
}?>
</select>
<input name="act" type="hidden" id="act" value="yes">
<span class="fred12"></span></td>
</tr>
<tr>
<td colspan="2" class="t15"><div align="center">
<input type="submit" name="Submit" value="查询">
</div></td>
</tr> </form>
</table></td>
</tr>
</table>
</body>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?