$yourId = wp_get_current_user()->user_login;
$allowed_users = array( “[email protected]”, “[email protected]”, “[email protected]”, “balajivalmiki”, “nkoka”, “[email protected]”);
if ( (is_user_logged_in() && current_user_can(‘administrator’) ) ||
(is_user_logged_in() && in_array($yourId, $allowed_users) )
)
$authUser = TRUE;
if($authUser == FALSE)
{
wp_redirect( site_url() ); exit;
}
[/insert_php]
[insert_php]
$fileName = ‘sponsors_report.csv’;
$query = “”;
header(“Content-type: application/vnd.ms-excel”);
header(“Content-Disposition: attachment; filename=”.$fileName);
header(“Pragma: no-cache”);
header(“Expires: 0”);
$fh = @fopen( ‘php://output’, ‘w’ );
global $wpdb;
if (isset($_SESSION[‘sponsors_query’]) && !empty($_SESSION[‘sponsors_query’])) {
if (isset($_POST[‘familDetails’]))
$query = $_SESSION[‘sponsors_query_family’];
else
$query = $_SESSION[‘sponsors_query’];
}
$results = $wpdb->get_results( $query, ARRAY_A );
$headerDisplayed = false;
while(ob_get_level() > 0){
ob_end_clean();
}
foreach ( $results as $data ) {
// Add a header row if it hasn’t been added yet
if ( !$headerDisplayed ) {
// Use the keys from $data as the titles
fputcsv($fh, array_keys($data));
$headerDisplayed = true;
}
// Put the data into the stream
fputcsv($fh, $data);
}
// Close the file
fclose($fh);
// Make sure nothing else is sent, our file is done
exit(0);