<?phpob_start();
 include '../includes/connection.php';

ini_set('max_execution_time', 3000000);
//ini_set('memory_limit','2048M');
ini_set('memory_limit', '-1');
error_reporting(E_ALL);
date_default_timezone_set('Europe/London');

$from_date = $_REQUEST['from_date'];
$to_date = $_REQUEST['to_date'];

    $tablename = "table"; //table name
    $rows_per_page =5; //Total number of records to present in each page
    
    //DB connection
    
    
    //Queries
    $querycount = "SELECT count(*) FROM client_consignment";
    $query = "SELECT * FROM client_consignment inner join  client_consignment_packages on client_consignment.client_consignment_id  =  client_consignment_packages.client_consignment_id where ( ship_date between '2014-09-01' and '2015-01-01')";
    
    //For page count
    $result = mysql_query($querycount);
    $query_data = mysql_fetch_row($result);
    $numrows = $query_data[0];
    $lastpage      = ceil($numrows/$rows_per_page); //Calculate total number of files to be generated
    $pageno = 1; //intialize page as 1
    
    //Generating files in CSV format
    for($i=1; $i<=$lastpage; $i++) {
        
        //Fixing limit
        $limit = 'LIMIT ' .($pageno - 1) * $rows_per_page .',' .$rows_per_page;
        $filename = "master_data_" . $i . ".csv";
        $fp = fopen($filename, "w");
        
        $res = mysql_query("$query $limit");
        
        // fetch a row and write the column names out to the file
        $row = mysql_fetch_assoc($res);
        $line = "";
        $comma = "";
        foreach($row as $name => $value) {
        $line .= $comma . '"' . str_replace('"', '""', $name) . '"';
        $comma = ",";
        }
        $line .= "\n";
        fputs($fp, $line);
        
        // remove the result pointer back to the start
        mysql_data_seek($res, 0);
        
        // and loop through the actual data
        while($row = mysql_fetch_assoc($res)) {
        
        $line = "";
        $comma = "";
        foreach($row as $value) {
        $line .= $comma . '"' . str_replace('"', '""', $value) . '"';
        $comma = ",";
        }
        $line .= "\n";
        fputs($fp, $line);
        }
        $pageno = $pageno+1; //count page number for next file generation
        
    }
    fclose($fp);

?>