关于PHP 空白页的问题 为什么我的PHP程序同一段程序设置 显示 1000条可以正常显示。显示全部 大概 1800条左右就一片空白,请助!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是不是超时,加上 set_time_limit(0); 看看 $sql = "select e.companycode,e.employeeName,e.Sex,e.age ,e.Birthday,e.Education,e.Nation,e.HouseHoldPlace,e.DeformityClass,e.MarryStatus,e.InCorpTime,e.OffCorpTime,e.worksatation,e.IdentyCode,e.FamilyPhone,e.DeformityCode,e.orderid,e.new_flag,e.dimission_flag,HopeDuteCount,ActualDuteCount,BasicSalary,Prize,OvertimeSalary,HopeGetSalary,ActualGetSalary,OtherInCome,OtherDeduct,AgedInsurance,MedicalInsurance,CompoInsurance,OutworkInsurance,ProcreateInsurance,wxhj=(AgedInsurance+MedicalInsurance+CompoInsurance+OutworkInsurance+ProcreateInsurance),InsuranceCode from cdb_employeeinfo{$y}{$m} e left join cdb_salarydute{$y}{$m} s on e.identycode=s.identycode and e.companycode=s.companycode left join cdb_insurance{$y}{$m} i on e.identycode=i.identycode and e.companycode=i.companycode where e.companyid='$sacw_companyid' order by e.orderid,e.employeeid,e.IdentyCode"; $dcount = 1; $query = &$db->Execute($sql); while (!$query->EOF) { $print['number'] = $dcount; $print['employeeName'] = $query->fields[1]?$query->fields[1]:' '; $print['Sex'] = $query->fields[2]?$query->fields[2]:' '; $print['Age'] = $query->fields[3]?$query->fields[3]:' '; $print['Birthday'] = $query->fields[4]?$query->fields[4]:' '; $print['Education'] = $query->fields[5]?$query->fields[5]:' '; if($print['Education']=='还未选择') { $print['Education']=''; } $print['Nation'] = $query->fields[6]?$query->fields[6]:' '; $print['HouseHoldPlace'] =$query->fields[7]?$query->fields[7]:' '; $print['DeformityClass'] =$query->fields[8]?$query->fields[8]:' '; $print['MarryStatus'] =$query->fields[9]?$query->fields[9]:' '; $print['InCorpTime'] =$query->fields[10]?$query->fields[10]:' '; $print['OffCorpTime'] =$query->fields[11]?$query->fields[11]:' '; if($print['OffCorpTime']=='4000-1-1') { $print['OffCorpTime']=' '; } $print['worksatation'] =$query->fields[12]?$query->fields[12]:' '; $print['IdentyCode'] =$query->fields[13]?$query->fields[13]:' '; $print['FamilyPhone'] =$query->fields[14]?$query->fields[14]:' '; $print['DeformityCode'] =$query->fields[15]?$query->fields[15]:' '; $print['orderid'] =$query->fields[16]?$query->fields[16]:' '; $print['new_flag'] =$query->fields[17]?$query->fields[17]:' '; $print['dimission_flag'] =$query->fields[18]?$query->fields[18]:' '; $print['HopeDuteCount'] =$query->fields[19]?$query->fields[19]:' '; $print['ActualDuteCount'] =$query->fields[20]?$query->fields[20]:' '; $print['BasicSalary'] =$query->fields[21]?$query->fields[21]:' '; $print['Prize'] =$query->fields[22]?$query->fields[22]:' '; $print['OvertimeSalary'] =$query->fields[23]?$query->fields[23]:' '; $print['HopeGetSalary'] =$query->fields[24]?$query->fields[24]:' '; $print['ActualGetSalary'] =$query->fields[25]?$query->fields[25]:' '; $print['OtherInCome'] =$query->fields[26]?$query->fields[26]:' '; $print['OtherDeduct'] =$query->fields[27]?$query->fields[27]:' '; $print['AgedInsurance'] =$query->fields[28]?$query->fields[28]:' '; $print['MedicalInsurance'] =$query->fields[29]?$query->fields[29]:' '; $print['CompoInsurance'] =$query->fields[30]?$query->fields[30]:' '; $print['OutworkInsurance'] =$query->fields[31]?$query->fields[31]:' '; $print['ProcreateInsurance'] =$query->fields[32]?$query->fields[32]:' '; $print['wxhj'] =$query->fields[33]?$query->fields[33]:' '; if($dcount % 20 == '1' &&$dcount!=1) { $print['printbreak'] = '1'; }else { $print['printbreak'] = '0'; } $print_list[] = $print; $dcount++; $query->MoveNext(); } include template('print'); 模版部份<table> <!--{loop $print_list $key $print}--> <tr <!--{if '1'==$print['printbreak']}-->style="page-break-after:always;" <!--{/if}--> > <TD style="border:black solid;border-width:0 1 1 1"><!--{$print['number']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['employeeName']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['Sex']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['Age']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['Birthday']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['Education']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['Nation']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['HouseHoldPlace']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['DeformityClass']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['MarryStatus']}--> </TD> <TD style="white-space:nowrap;" <!--{if '1'==$print['new_flag']}-->bgcolor=#808080<!--{/if}-->><!--{if '1'==$print['new_flag']}--><font color=#ffffff><!--{/if}--><!--{$print['InCorpTime']}--> </TD> <TD style="white-space:nowrap;"<!--{if '1'==$print['dimission_flag']}-->bgcolor=#808080<!--{/if}-->><!--{if '1'==$print['dimission_flag']}--><font color=#ffffff><!--{/if}--><!--{$print['OffCorpTime']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['worksatation']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['IdentyCode']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['FamilyPhone']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['DeformityCode']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['orderid']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['HopeDuteCount']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['ActualDuteCount']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['BasicSalary']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['Prize']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['OvertimeSalary']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['HopeGetSalary']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['ActualGetSalary']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['OtherInCome']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['OtherDeduct']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['AgedInsurance']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['MedicalInsurance']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['CompoInsurance']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['OutworkInsurance']}--> </TD> <TD style="white-space:nowrap;display:none"><!--{$print['ProcreateInsurance']}--> </TD> <TD style="white-space:nowrap;"><!--{$print['wxhj']}--> </TD> </tr> <!--{/loop}--> </table> 这么长阿,调试不停的调试……在任何地方加入 exit('调试');数据据库查询完毕的时候/模版替换过程中/……总之先看看,到底执行到哪有问题 晕,一般是你程序问题先echo下你是否有查询结果,再ech下能否显示,再往模板里放 执行了多少时间,如果没有改配置,默认执行时间是30sset_time_limit 顺便帮我解决这个问题,谢谢了先(特级)http://topic.csdn.net/u/20081015/11/b8a41991-407d-43b8-8fb9-7ddddcb8888a.html 顺便帮我解决这个问题,谢谢了先(特级)http://topic.csdn.net/u/20081015/11/b8a41991-407d-43b8-8fb9-7ddddcb8888a.html WAMPSERVER2.2 能不能服务器用。 PHP 复制图片问题 php文件调用js文件里的方法? 有没php读写txt的代码,分页 关于include_once的效率问题 请问类似于“姓”这样的汉字编码是那种编码格式啊? [复合查询]PHP中的数据集问题 帮帮我吧。。我刚看PHP。 精确检测email的正确性!! 问题在哪?解决给分! 求 php 显示flash幻灯广告代码 如何保存table里边的内容通过PHP
$dcount = 1;
$query = &$db->Execute($sql);
while (!$query->EOF)
{
$print['number'] = $dcount;
$print['employeeName'] = $query->fields[1]?$query->fields[1]:' ';
$print['Sex'] = $query->fields[2]?$query->fields[2]:' ';
$print['Age'] = $query->fields[3]?$query->fields[3]:' ';
$print['Birthday'] = $query->fields[4]?$query->fields[4]:' ';
$print['Education'] = $query->fields[5]?$query->fields[5]:' ';
if($print['Education']=='还未选择') {
$print['Education']='';
}
$print['Nation'] = $query->fields[6]?$query->fields[6]:' ';
$print['HouseHoldPlace'] =$query->fields[7]?$query->fields[7]:' ';
$print['DeformityClass'] =$query->fields[8]?$query->fields[8]:' ';
$print['MarryStatus'] =$query->fields[9]?$query->fields[9]:' ';
$print['InCorpTime'] =$query->fields[10]?$query->fields[10]:' ';
$print['OffCorpTime'] =$query->fields[11]?$query->fields[11]:' ';
if($print['OffCorpTime']=='4000-1-1') {
$print['OffCorpTime']=' ';
}
$print['worksatation'] =$query->fields[12]?$query->fields[12]:' ';
$print['IdentyCode'] =$query->fields[13]?$query->fields[13]:' ';
$print['FamilyPhone'] =$query->fields[14]?$query->fields[14]:' ';
$print['DeformityCode'] =$query->fields[15]?$query->fields[15]:' ';
$print['orderid'] =$query->fields[16]?$query->fields[16]:' ';
$print['new_flag'] =$query->fields[17]?$query->fields[17]:' ';
$print['dimission_flag'] =$query->fields[18]?$query->fields[18]:' '; $print['HopeDuteCount'] =$query->fields[19]?$query->fields[19]:' ';
$print['ActualDuteCount'] =$query->fields[20]?$query->fields[20]:' ';
$print['BasicSalary'] =$query->fields[21]?$query->fields[21]:' ';
$print['Prize'] =$query->fields[22]?$query->fields[22]:' ';
$print['OvertimeSalary'] =$query->fields[23]?$query->fields[23]:' ';
$print['HopeGetSalary'] =$query->fields[24]?$query->fields[24]:' ';
$print['ActualGetSalary'] =$query->fields[25]?$query->fields[25]:' ';
$print['OtherInCome'] =$query->fields[26]?$query->fields[26]:' ';
$print['OtherDeduct'] =$query->fields[27]?$query->fields[27]:' ';
$print['AgedInsurance'] =$query->fields[28]?$query->fields[28]:' ';
$print['MedicalInsurance'] =$query->fields[29]?$query->fields[29]:' ';
$print['CompoInsurance'] =$query->fields[30]?$query->fields[30]:' ';
$print['OutworkInsurance'] =$query->fields[31]?$query->fields[31]:' ';
$print['ProcreateInsurance'] =$query->fields[32]?$query->fields[32]:' ';
$print['wxhj'] =$query->fields[33]?$query->fields[33]:' ';
if($dcount % 20 == '1' &&$dcount!=1) {
$print['printbreak'] = '1';
}else {
$print['printbreak'] = '0';
}
$print_list[] = $print;
$dcount++;
$query->MoveNext();
}
include template('print');
模版部份<table>
<!--{loop $print_list $key $print}-->
<tr <!--{if '1'==$print['printbreak']}-->style="page-break-after:always;" <!--{/if}--> >
<TD style="border:black solid;border-width:0 1 1 1"><!--{$print['number']}-->
</TD> <TD style="white-space:nowrap;"><!--{$print['employeeName']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['Sex']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['Age']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['Birthday']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['Education']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['Nation']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['HouseHoldPlace']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['DeformityClass']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['MarryStatus']}-->
</TD>
<TD style="white-space:nowrap;" <!--{if '1'==$print['new_flag']}-->bgcolor=#808080<!--{/if}-->><!--{if '1'==$print['new_flag']}--><font color=#ffffff><!--{/if}--><!--{$print['InCorpTime']}-->
</TD>
<TD style="white-space:nowrap;"<!--{if '1'==$print['dimission_flag']}-->bgcolor=#808080<!--{/if}-->><!--{if '1'==$print['dimission_flag']}--><font color=#ffffff><!--{/if}--><!--{$print['OffCorpTime']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['worksatation']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['IdentyCode']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['FamilyPhone']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['DeformityCode']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['orderid']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['HopeDuteCount']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['ActualDuteCount']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['BasicSalary']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['Prize']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['OvertimeSalary']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['HopeGetSalary']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['ActualGetSalary']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['OtherInCome']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['OtherDeduct']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['AgedInsurance']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['MedicalInsurance']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['CompoInsurance']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['OutworkInsurance']}-->
</TD>
<TD style="white-space:nowrap;display:none"><!--{$print['ProcreateInsurance']}-->
</TD>
<TD style="white-space:nowrap;"><!--{$print['wxhj']}-->
</TD>
</tr>
<!--{/loop}-->
</table>
在任何地方加入 exit('调试');
数据据库查询完毕的时候/模版替换过程中/……
总之先看看,到底执行到哪有问题
先echo下你是否有查询结果,再ech下能否显示,再往模板里放
http://topic.csdn.net/u/20081015/11/b8a41991-407d-43b8-8fb9-7ddddcb8888a.html
http://topic.csdn.net/u/20081015/11/b8a41991-407d-43b8-8fb9-7ddddcb8888a.html