function jsa_export_func()
{
$filename = home_url . "\\wp-content\\plugins\\jsa-database\\csv\\JSA-Download.csv";
$fh = fopen( $filename, 'w' ) or die("Can't open file");
global $wpdb;
$results = $wpdb->get_results( $wpdb->prepare("SELECT ID, name, postdate, posttitle, location
FROM wp_jsadb;", ARRAY_A ) );
$headerDisplayed = false;
foreach ( $results as $data ) {
if ( !$headerDisplayed ) {
fputcsv($fh, array_keys($data));
$headerDisplayed = true;
}
fputcsv($fh, $data);
}
fclose($fh);
exit();
echo '<br/>' . "Right click and Save Target As: " . '<a href=" ' . $filename . ' " target="_blank">[DOWNLOAD CSV]</a>';
}