title: import excel using chunck filter php
body: <p>I have tried to import excel using PHP excel Library. It is working for small data .But it is not working with excel containing more than 30000 rows .I have tried increase memory limit and execution time.It is also taking long time.
  here is my code</p>
  <pre><code>ini_set('upload_max_filesize', '64M');
  ini_set('memory_limit', '4096M');
  ini_set('max_execution_time', 0);
  ini_set('max_input_time', -1);
   
  $fileName = $_FILES[&quot;production&quot;][&quot;tmp_name&quot;];
  $objPHPExcel = PHPExcel_IOFactory::load($fileName);
  $phpspreadsheet = $objPHPExcel-&gt;getSheet(0);
                   
  $total_data = $phpspreadsheet-&gt;getHighestRow();
  //echo $chunkSize;
  // exit;
  $highest_column = $phpspreadsheet-&gt;getHighestColumn();
  
  for ($row = 2 ; $row &lt;= $total_data; $row++) {
      $productionDataAll = $phpspreadsheet-&gt; rangeToArray ('A' . $row . ':' . $highest_column . $row, NULL, TRUE, FALSE);
                          
      $line           =htmlentities($productionDataAll[0][0]);
      $workedorder    =htmlentities($productionDataAll[0][1]);
      $modelnumber    =htmlentities($productionDataAll[0][2]);
      $revision       =htmlentities($productionDataAll[0][3]);
      if(!empty($productionDataAll[0][4])){
          $serialnumber = htmlentities($productionDataAll[0][4]);
      }else{
          $serialnumber='';
      }
      $lpn            = htmlentities($productionDataAll[0][5]);
      $shift          = htmlentities($productionDataAll[0][6]);
      $datecreated    = htmlentities($productionDataAll[0][7]);
      $datecompleted  = htmlentities($productionDataAll[0][8]);
      $repairflag     = htmlentities($productionDataAll[0][9]);
      $date=date(&quot;Y-m-d&quot;, strtotime( '-1 days' ) );
      $skeydate       = date(&quot;Ymd&quot;, strtotime( '-1 days' ) );
      $skey           = $skeydate.$line;
      $importproduction = importproduction(
                                      $mysql_connectionLinkLocal, 
                                      $line, 
                                      $workedorder, 
                                      $modelnumber, 
                                      $revision,
                                      $serialnumber,
                                      $lpn,
                                      $shift,
                                      $repairflag,
                                      $date,
                                      $skey,
                                      $datecreated,
                                      $datecompleted); 
  }    
  </code></pre>
  <p>I have tried to use chunck filter . But it is not working .How to add  chunck filter with above code ?</p>