export.php

<?PHP

require(__DIR__.'/lib/functions.inc.php');

global $db_handle;

if ($_POST["export"]!="") {
    header('Content-Type: text/csv');
    header('Content-Disposition: attachment;filename=tasmobackup_devices.csv');

    //SQL Query for Data
    $sql = "SELECT * FROM devices;";
    //Prepare Query, Bind Parameters, Excute Query
    $STH = $db_handle->prepare($sql);
    $STH->execute();

    //Export to .CSV
    $fp = fopen('php://output', 'w');

    // first set
    $first_row = $STH->fetch(PDO::FETCH_ASSOC);
    $headers   = array_keys($first_row);
    fputcsv($fp, $headers); // put the headers
    fputcsv($fp, array_values($first_row)); // put the first row

    while ($row = $STH->fetch(PDO::FETCH_NUM)) {
        fputcsv($fp, $row); // push the rest
    }
    fclose($fp);
}
//header("Location: settings.php");
?>