// 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);