----小弟实在烦闷,自己写的东西短时间内都看蒙了,但是运行出来的效果还是行的!
但是用什么方法可以使代码的本身量少点、但是不影响效果啊!???谢谢系统原因紧上传部分代码!----------------
<?php include_once('conn.php');
$select = $_POST['select0']."-".$_POST['select1']."-".$_POST['select2']; echo "<a href='index.php'>返回首页</a>  "; echo "<table border='1'cellpadding='0' cellspacing='0'>";
echo "<tr><td colspan='7' align='center'>大一区</td></tr>";
echo "<tr><td align='center'>区域名称</td>
<td align='center'>门店名称</td>
<td align='center'>销售金额</td>
<td align='center'>夜班销售金额</td>
<td align='center'>速食金额</td>
<td align='center'>速食+业绩</td>
<td align='center'>出表日期</td></tr>";
function __get($sql1){
if(isset($this->$sql1)) {
return($this->$property_name);
}
else {
return(NULL);
}
} $sql1 = "Select * from $DB_TBLName where qu_id = 'GD0101' and time = '$select' order by qu_id asc, name asc"; $result1 = @mysql_query($sql1,$Connect) or die(mysql_error());
while ($row1 = mysql_fetch_array($result1))
{
$T1 = $row1['sell']+$row1['snack'];
echo "<tr>";
echo "<td align = 'center' >{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T1}</td>
<td align = 'center' >{$row['time']}</td>";
}
//输出大一区1区的各销售额 echo "<tr bgcolor='gray'>";
echo "<td>大一区1区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0101' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0101' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0101' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
//输出大一区2区
$sql = "Select * from $DB_TBLName where qu_id='GD0102' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error()); while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>"; }
echo "<tr bgcolor='gray'>";
echo "<td>大一区2区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0102' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0102' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0102' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
//显示大一区3区
$sql = "Select * from $DB_TBLName where qu_id='GD0103' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>"; }
//-----------------分界线--------------------------->
echo "<tr bgcolor='gray'>";
echo "<td>大一区3区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0103' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0103' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0103' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>"; echo "</tr>";
//输出大一区4区
$sql = "Select * from $DB_TBLName where qu_id='GD0104' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>";
}
//-----------------分界线--------------------------->
echo "<tr bgcolor='gray'>";
echo "<td>大一区4区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0104' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0104' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0104' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
//输出大一区5区
$sql = "Select * from $DB_TBLName where qu_id='GD0105' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>";
}
//-----------------分界线--------------------------->
echo "<tr bgcolor='gray'>";
echo "<td>大一区5区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0105' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0105' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0105' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
echo "</table>";
mysql_close();?>
但是用什么方法可以使代码的本身量少点、但是不影响效果啊!???谢谢系统原因紧上传部分代码!----------------
<?php include_once('conn.php');
$select = $_POST['select0']."-".$_POST['select1']."-".$_POST['select2']; echo "<a href='index.php'>返回首页</a>  "; echo "<table border='1'cellpadding='0' cellspacing='0'>";
echo "<tr><td colspan='7' align='center'>大一区</td></tr>";
echo "<tr><td align='center'>区域名称</td>
<td align='center'>门店名称</td>
<td align='center'>销售金额</td>
<td align='center'>夜班销售金额</td>
<td align='center'>速食金额</td>
<td align='center'>速食+业绩</td>
<td align='center'>出表日期</td></tr>";
function __get($sql1){
if(isset($this->$sql1)) {
return($this->$property_name);
}
else {
return(NULL);
}
} $sql1 = "Select * from $DB_TBLName where qu_id = 'GD0101' and time = '$select' order by qu_id asc, name asc"; $result1 = @mysql_query($sql1,$Connect) or die(mysql_error());
while ($row1 = mysql_fetch_array($result1))
{
$T1 = $row1['sell']+$row1['snack'];
echo "<tr>";
echo "<td align = 'center' >{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T1}</td>
<td align = 'center' >{$row['time']}</td>";
}
//输出大一区1区的各销售额 echo "<tr bgcolor='gray'>";
echo "<td>大一区1区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0101' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0101' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0101' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
//输出大一区2区
$sql = "Select * from $DB_TBLName where qu_id='GD0102' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error()); while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>"; }
echo "<tr bgcolor='gray'>";
echo "<td>大一区2区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0102' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0102' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0102' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
//显示大一区3区
$sql = "Select * from $DB_TBLName where qu_id='GD0103' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>"; }
//-----------------分界线--------------------------->
echo "<tr bgcolor='gray'>";
echo "<td>大一区3区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0103' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0103' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0103' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>"; echo "</tr>";
//输出大一区4区
$sql = "Select * from $DB_TBLName where qu_id='GD0104' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>";
}
//-----------------分界线--------------------------->
echo "<tr bgcolor='gray'>";
echo "<td>大一区4区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0104' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0104' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0104' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
//输出大一区5区
$sql = "Select * from $DB_TBLName where qu_id='GD0105' and time = '$select' order by qu_id asc, name asc"; $result = @mysql_query($sql,$Connect) or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
$T = $row['sell']+$row['snack'];
echo "<tr>";
echo "<td align = 'center'>{$row['qu_name']}</td>
<td align = 'center' width='150'>{$row['name']}</td>
<td align = 'center' >{$row['sell']}</td>
<td align = 'center' >{$row['night']}</td>
<td align = 'center' >{$row['snack']}</td>
<td align = 'center' >{$T}</td>
<td align = 'center' >{$row['time']}</td>";
}
//-----------------分界线--------------------------->
echo "<tr bgcolor='gray'>";
echo "<td>大一区5区</td><td align='center'>合计</td>";
$sql = mysql_query("SELECT SUM(sell) FROM $DB_TBLName where qu_id='GD0105' and time = '$select'");
$row = mysql_fetch_array($sql);
$A=$row[0];
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(night) FROM $DB_TBLName where qu_id='GD0105' and time = '$select'");
$row = mysql_fetch_array($sql);
echo "<td align = 'center'>$row[0]</td>"; $sql = mysql_query("SELECT SUM(snack) FROM $DB_TBLName where qu_id='GD0105' and time = '$select'");
$row = mysql_fetch_array($sql);
$B=$row[0];
echo "<td align = 'center'>$row[0]</td>";
$C = $A + $B;
echo "<td align='center'>$C</td>";
echo "</tr>";
echo "</table>";
mysql_close();?>
然后index.php包含你的静态部分,静态部分在输出部分把你的变量做输出就可以!