<?php
include 'config.php';
global $wpdb;

    $csv_output = 'S.no, Email ID, Registration Date, Reason, Status';
    $csv_output .= "\n"; 
	
    $getDataQuery  = "SELECT id, email_id, reg_date, reason, status FROM sp_subscription";

	$getData=$db->prepare($getDataQuery);
    $getData->execute();

    $i = 1;
    if (sizeof($getData) > 0) 
    {
    while ($vd = $getData->fetch())
        {
            $status = $vd['status'];
            if($status=='1')
            {
                $text = "Active";
            }
            else if($status=='0')
            {
                $text = "Deactive";
            }
            
            $csv_output .= $i . ',';
            $csv_output .= $vd['email_id'] . ',';
            $csv_output .= $vd['reg_date'] . ',';
			$csv_output .= $vd['reason'] . ',';
            $csv_output .= $text . ',';
            $csv_output .= "\n";
            $i++;
        }
    } 
    else 
    {
        $csv_output = "No Record Found!";
    }

    $filename = "NC Subscription List";
	
	header("Content-type: application/vnd.ms-excel");
    header("Content-disposition:   filename=" . $filename . ".csv");
	print $csv_output;
	
    exit;
?>