<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {font-size: x-large}
-->
</style>
</head><body><form action="" method="get">
<table width="850" border="1" align="center">
<tr onMouseOver="this.style.backgroundColor='#8CF9EE'" onMouseOut="this.style.backgroundColor=''">
<td width="10%"><div align="center" >本机号码</div></td>
<td width="9%"><div align="center" >序号</div></td>
<td width="12%"><div align="center">发话终端</div></td>
<td width="21%"><div align="center">对方号码</div></td>
<td width="17%"><div align="center">通话类型</div></td>
<td width="7%"><div align="center">市话费</div></td>
<td width="10%"><div align="center">长话费</div></td>
<td width="14%"><div align="center">总费用</div></td>
</tr>
<?php
include("db.php");$biaoming=$_POST[biaoming];
echo '<div align="center" class="STYLE1">'.$biaoming.'月中不符清单</div>';
$sql="select a.my_tel,a.my_tel_id,a.zongduan,a.out_tel,a.leixing,a.money_1,a.money_2,a.money_all
from tel200802 a left join tel b on a.out_tel=b.tel_no
where b.tel_no is null and a.money_all<>0 and a.leixing not like '%温馨家园%' and yue=$biaoming
order by a.my_tel,a.my_tel_id,a.out_tel";
$result=mysql_query($sql);
while ($myarray=mysql_fetch_array($result))
{
echo '<tr>';//onMouseOver="this.style.backgroundColor=\'#8CF9EE\'" onMouseOut="this.style.backgroundColor=\'\'"
echo '<td width="10%"><div align="center">'.$myarray['0'].'</div></td>';
echo '<td width="9%"><div align="center">'.$myarray['1'].'</div></td>';
echo '<td width="12%"><div align="center">'.$myarray['2'].'</div></td>';
echo '<td width="21%"><div align="center">'.$myarray['3'].'</div></td>';
echo '<td width="17%"><div align="center">'.$myarray['4'].'</div></td>';
echo '<td width="7%"><div align="center">'.$myarray['5'].'</div></td>';
echo '<td width="10%"><div align="center">'.$myarray['6'].'</div></td>';
echo '<td width="14%"><div align="center">'.$myarray['7'].'</div></td>';
echo '</tr>';
}
?>
</table>
</form>
<form name="form1" method="post" action="out_yue.php">
<label>
<div align="center">
<input name="biaoming" type="hidden" value="<? echo "$biaoming";?>" />
<input type="submit" name="Submit" value="导出数据为exl">
</div>
</label>
</form><? mysql_close($link);?>
<? mysql_close($result);?>
</body>
</html>不知道为什么一运行这个页面就很卡IE经常使用率高达90% 多~! 有人知道为什么吗? 是数据库原因吗还是?
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
.STYLE1 {font-size: x-large}
-->
</style>
</head><body><form action="" method="get">
<table width="850" border="1" align="center">
<tr onMouseOver="this.style.backgroundColor='#8CF9EE'" onMouseOut="this.style.backgroundColor=''">
<td width="10%"><div align="center" >本机号码</div></td>
<td width="9%"><div align="center" >序号</div></td>
<td width="12%"><div align="center">发话终端</div></td>
<td width="21%"><div align="center">对方号码</div></td>
<td width="17%"><div align="center">通话类型</div></td>
<td width="7%"><div align="center">市话费</div></td>
<td width="10%"><div align="center">长话费</div></td>
<td width="14%"><div align="center">总费用</div></td>
</tr>
<?php
include("db.php");$biaoming=$_POST[biaoming];
echo '<div align="center" class="STYLE1">'.$biaoming.'月中不符清单</div>';
$sql="select a.my_tel,a.my_tel_id,a.zongduan,a.out_tel,a.leixing,a.money_1,a.money_2,a.money_all
from tel200802 a left join tel b on a.out_tel=b.tel_no
where b.tel_no is null and a.money_all<>0 and a.leixing not like '%温馨家园%' and yue=$biaoming
order by a.my_tel,a.my_tel_id,a.out_tel";
$result=mysql_query($sql);
while ($myarray=mysql_fetch_array($result))
{
echo '<tr>';//onMouseOver="this.style.backgroundColor=\'#8CF9EE\'" onMouseOut="this.style.backgroundColor=\'\'"
echo '<td width="10%"><div align="center">'.$myarray['0'].'</div></td>';
echo '<td width="9%"><div align="center">'.$myarray['1'].'</div></td>';
echo '<td width="12%"><div align="center">'.$myarray['2'].'</div></td>';
echo '<td width="21%"><div align="center">'.$myarray['3'].'</div></td>';
echo '<td width="17%"><div align="center">'.$myarray['4'].'</div></td>';
echo '<td width="7%"><div align="center">'.$myarray['5'].'</div></td>';
echo '<td width="10%"><div align="center">'.$myarray['6'].'</div></td>';
echo '<td width="14%"><div align="center">'.$myarray['7'].'</div></td>';
echo '</tr>';
}
?>
</table>
</form>
<form name="form1" method="post" action="out_yue.php">
<label>
<div align="center">
<input name="biaoming" type="hidden" value="<? echo "$biaoming";?>" />
<input type="submit" name="Submit" value="导出数据为exl">
</div>
</label>
</form><? mysql_close($link);?>
<? mysql_close($result);?>
</body>
</html>不知道为什么一运行这个页面就很卡IE经常使用率高达90% 多~! 有人知道为什么吗? 是数据库原因吗还是?
解决方案 »
- 远程抓取EMS信息,验证码无效,请指教
- LAMP 技术践行者的15课(2)
- 简单数据库定义问题
- 用函数eregi取出的数组,怎么只能取出两个元素?
- 弹出窗口的问题,有没有办法,让弹出的窗口右上角没有最小化、最大化、关闭三个按钮?呢
- php可以操作word文档吗
- PHP中怎么用SQL把一些数据资料导出到本地电脑呢
- 哇哇哇哇哇哇~~~我要失业了~~~谁来救我呀~~~
- 计数器出现的位置如何设定?
- 搞笑php的广告,为了php的发展,大家快来接龙啊!!!!!!!!!!我先来一句:php,地球人都~知道。
- session的问题。希望大家帮忙。绝望中
- 第一个php程序连接mysql遇到问题,请大虾给我指点迷津!
1.是否可以分成很多表(比如100条记录一个表)
2.优化HTML代码
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title> 无标题文档 </title>
<style type="text/css">
<!--
.STYLE1 {font-size: x-large}
-->
</style>
</head> <body>
<table width="850" border="1" align="center">
<col width="10%" align="center"/>
<col width="9%" align="center"/>
<col width="12%" align="center"/>
<col width="21%" align="center"/>
<col width="17%" align="center"/>
<col width="7%" align="center"/>
<col width="10%" align="center"/>
<col width="14%" align="center"/>
<tr onMouseOver="this.style.backgroundColor='#8CF9EE'" onMouseOut="this.style.backgroundColor=''">
<td width="10%">本机号码</td>
<td width="9%">序号</div> </td>
<td width="12%">发话终端</td>
<td width="21%">对方号码</td>
<td width="17%">通话类型</td>
<td width="7%">市话费</td>
<td width="10%">长话费</td>
<td width="14%">总费用</td>
</tr>
<?php
include("db.php"); $biaoming=$_POST[biaoming];
echo ' <div align="center" class="STYLE1"> '.$biaoming.'月中不符清单 </div> ';
$sql="select a.my_tel,a.my_tel_id,a.zongduan,a.out_tel,a.leixing,a.money_1,a.money_2,a.money_all
from tel200802 a left join tel b on a.out_tel=b.tel_no
where b.tel_no is null and a.money_all <> 0 and a.leixing not like '%温馨家园%' and yue=$biaoming
order by a.my_tel,a.my_tel_id,a.out_tel"; $outString = "";$result=mysql_query($sql);
while ($myarray=mysql_fetch_array($result))
{
$outString .= '
<tr>
<td>'.$myarray[0].'</td>
<td>'.$myarray[1].'</td>
<td>'.$myarray[2].'</td>
<td>'.$myarray[3].'</td>
<td>'.$myarray[4].'</td>
<td>'.$myarray[5].'</td>
<td>'.$myarray[6].'</td>
<td>'.$myarray[7].'</td>
</tr>';
}
echo $outString;
?>
</table>
</body>
</html>
我就是这个意思表是指的table(哎,语文学得不好,没有想到这个地方的"表"这么让人容易想到数据表),分开表格来显示,这样显示快些.
$outString = "";$result=mysql_query($sql);
while ($myarray=mysql_fetch_array($result))
{
$outString .= '
<tr>
<td>'.$myarray[0].'</td>
<td>'.$myarray[1].'</td>
<td>'.$myarray[2].'</td>
<td>'.$myarray[3].'</td>
<td>'.$myarray[4].'</td>
<td>'.$myarray[5].'</td>
<td>'.$myarray[6].'</td>
<td>'.$myarray[7].'</td>
</tr>';
}
echo $outString;
中$OUTSTRING 的意思 具体起到什么样的作用了
2. 查询是否分页
3. 输出HTML时循环效率
2. 查询是否分页
3. 输出HTML时循环效率