<?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; } }