<?php 
 
// Load the database configuration file 
include('../inc/conn.php');
if($_POST['from']!='' && $_POST['to']!=''){
    $from=date('d-m-y', strtotime($_POST['from']));
    $to=date('d-m-y', strtotime($_POST['to'])); 
// Fetch records from database 
$query = $con->query("SELECT * FROM client_interest WHERE date between '".$from."' and '".$to."' ORDER BY id ASC"); 
 
if($query->num_rows > 0){ 
    $delimiter = ","; 
    $filename = "client-interest-data_" . date('Y-m-d') . ".csv"; 
     
    // Create a file pointer 
    $f = fopen('php://memory', 'w'); 
     
    // Set column headers 
    $fields = array('ID', 'NAME', 'EMAIL', 'PHONE', 'CITY', 'MESSAGE', 'DATE'); 
    fputcsv($f, $fields, $delimiter); 
     
    $i=0; 
    while($row = $query->fetch_assoc()){ $i++;
        $status = ($row['status'] == 1)?'Active':'Inactive'; 
        $lineData = array($i, $row['name'], $row['email'], $row['phone'], $row['city'], $row['message'], date('M d, Y', strtotime($row['date']))); 
        fputcsv($f, $lineData, $delimiter); 
    } 
     
    // Move back to beginning of file 
    fseek($f, 0); 
     
    // Set headers to download file rather than displayed 
    header('Content-Type: text/csv'); 
    header('Content-Disposition: attachment; filename="' . $filename . '";'); 
     
    //output all remaining data on a file pointer 
    fpassthru($f); 
} 
else{
    echo "<script type='text/javascript'>alert('No Record Found!');window.location=\"../contact-details.php\";</script>";
} 
exit; 
}else{
$query = $con->query("SELECT * FROM client_interest ORDER BY id ASC"); 
 
if($query->num_rows > 0){ 
    $delimiter = ","; 
    $filename = "client-interest-data_" . date('Y-m-d') . ".csv"; 
     
    // Create a file pointer 
    $f = fopen('php://memory', 'w'); 
     
    // Set column headers 
    $fields = array('ID', 'NAME', 'EMAIL', 'PHONE', 'CITY', 'MESSAGE', 'DATE'); 
    fputcsv($f, $fields, $delimiter); 
     
    $i=0; 
    while($row = $query->fetch_assoc()){ $i++;
        $status = ($row['status'] == 1)?'Active':'Inactive'; 
        $lineData = array($i, $row['name'], $row['email'], $row['phone'], $row['city'], $row['message'], date('M d, Y', strtotime($row['date']))); 
        fputcsv($f, $lineData, $delimiter); 
    } 
     
    // Move back to beginning of file 
    fseek($f, 0); 
     
    // Set headers to download file rather than displayed 
    header('Content-Type: text/csv'); 
    header('Content-Disposition: attachment; filename="' . $filename . '";'); 
     
    //output all remaining data on a file pointer 
    fpassthru($f); 
}else{
    echo "<script type='text/javascript'>alert('No Record Found!');window.location=\"../contact-details.php\";</script>";
} 
exit;
}
?>