Example #1
0
    // disposition / encoding on response body
    header("Content-Disposition: attachment;filename={$filename}");
    header("Content-Transfer-Encoding: binary");
}
// ****************************************************************
// access check
include "includes/startloggedinadmin.inc.php";
require_once "classes/constants.class.php";
//require_once "classes/template.class.php";
//require_once "classes/templatehelper.class.php";
require_once "classes/db.class.php";
require_once "classes/sessionhelper.class.php";
//require_once "classes/jswriter.class.php";
//require_once "classes/validationhelper.class.php";
require_once "classes/bookingshelper.class.php";
if (!SessionHelper::isMaster()) {
    die("You don't belong here!");
}
$db = new Db();
$q = "\nSELECT \n\tb.first_name AS first_name,\n\tb.last_name AS last_name,\n\tb.email AS email\nFROM\n\tbookings b\nGROUP BY \n\temail\nORDER BY \n\temail\n";
//pr($q); // exit();
$rows = $db->getRowsByQuery($q);
$rows2 = array();
foreach ($rows as $row) {
    $rows2[] = array("name" => $row["first_name"], "surname" => $row["last_name"], "email" => $row["email"]);
}
unset($rows);
//pr($rows2); exit;
// ********************* export it now *****************9
download_send_headers("aps_emails_export_" . date("Y-m-d") . ".csv");
echo array2csv($rows2);