代码求简化-PHP Tutorial-php.cn

Table of Contents

回复讨论(解决方案)

Home

Backend Development

PHP Tutorial

代码求简化

Jun 23, 2016 pm 01:59 PM

	<form class="f"action="wel.php" method="get">		<input class="inp" type="text" name="mindate" value="<?php echo $mindate ?>" onfocus="HS_setDate(this)" readonly="readonly"/>至        <input class="inp" type="text" name="maxdate" value="<?php echo $maxdate ?>" onfocus="HS_setDate(this)" readonly="readonly"/>		<input class="sub" type="submit" value="统计"/>	</form>

Copy after login

<?php$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='新增' and `area`='城南东'";$cndx=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='续费' and `area`='城南东'";$cndf=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='升兆' and `area`='城南东'";$cnds=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='免费' and `area`='城南东'";$cndm=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='新增' and `area`='城南西'";$cnxx=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='续费' and `area`='城南西'";$cnxf=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='升兆' and `area`='城南西'";$cnxs=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='免费' and `area`='城南西'";$cnxm=mysql_result(mysql_query($sql),0);

Copy after login

 <tr>    <td>城南东</td>    <td><?php echo $cndx;?></td>    <td><?php echo $cndf;?></td>    <td><?php echo $cnds;?></td>    <td><?php echo $cndm;?></td>  </tr>  <tr>    <td>城南西</td>    <td><?php echo $cnxx;?></td>    <td><?php echo $cnxf;?></td>    <td><?php echo $cnxs;?></td>    <td><?php echo $cnxm;?></td>  </tr>

Copy after login

回复讨论(解决方案)

查询那块写成函数不是更好点吗

$sql = "SELECT area, type, count(*) AS count FROM `khxx` WHERE dates>=‘$mindate’ and dates

$sql = "SELECT area, type, count(*) AS count FROM `khxx` WHERE dates>=‘$mindate’ and dates 主要是
我的table 是固定了不知道怎么写在td中如果没有就显示 0

想把相应的值显示在固定了的表格中的单元格中

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn