<?php
class Make
{
public static function make_csv($query, $filename = '')
{
global $dbh;
if ($filename == '') {
$filename = date('Y-m-d-H-i-s') . '.csv';
}
$stmt = $dbh->prepare($query);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
if ($result) {
header('Content-Type: text/csv');
header('Content-Disposition: attachment;filename=' . $filename);
if ($stmt->rowCount() > 0) {
$fp = fopen('php://output', 'w');
foreach ($result as $value) {
fputcsv($fp, $value);
}
return true;
} else {
return false;
}
fclose($fp);
} else {
return false;
}
}
public static function make_pdf($title, $hstring, $style, $html)
{
$html = <<<EOT
$style
$html
EOT;
}
}