为什么我的PHP程序同一段程序设置 显示 1000条可以正常显示。显示全部 大概 1800条左右就一片空白,请助!!

解决方案 »

  1.   

    是不是超时,加上 set_time_limit(0); 看看
      

  2.   

    $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>
      

  3.   

    这么长阿,调试不停的调试……
    在任何地方加入 exit('调试');
    数据据库查询完毕的时候/模版替换过程中/……
    总之先看看,到底执行到哪有问题
      

  4.   

    晕,一般是你程序问题
    先echo下你是否有查询结果,再ech下能否显示,再往模板里放
      

  5.   

    执行了多少时间,如果没有改配置,默认执行时间是30sset_time_limit
      

  6.   

    顺便帮我解决这个问题,谢谢了先(特级)
    http://topic.csdn.net/u/20081015/11/b8a41991-407d-43b8-8fb9-7ddddcb8888a.html
      

  7.   

    顺便帮我解决这个问题,谢谢了先(特级)
    http://topic.csdn.net/u/20081015/11/b8a41991-407d-43b8-8fb9-7ddddcb8888a.html