1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| else if ($formatid == 'Excel') {
if (isparam('confirmed')) {
// Export
$link = mysql_connect("localhost", "root", "") or die("Connection to DB failed");
mysql_select_db("tkm");
// Headers
header('Content-Type: application/vnd.ms-excel');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
$filename = $_SESSION['currentstudy'].'.xls';
if (PMA_USR_BROWSER_AGENT == 'IE') {
header('Content-Disposition: inline; filename="' . $filename . '"');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
} else {
header('Content-Disposition: attachment; filename="' . $filename . '"');
header('Pragma: no-cache');
}
?>
... |
Partager