PHPスクリプト/CSV形式でダウンロード

CSV形式でダウンロード †

パート1 †

<?php
header("Content-Type: application/octet-stream");
header("Content-Disposition: attachment; filename=output.csv");

@ini_set("include_path",ini_get("include_path"));
require_once("DB.php");
$db = DB::connect('mysql://ユーザ名:パスワード@localhost/DB名');
if (PEAR::isError($db)) {
    die($db->getMessage());
}
$sql = 'select * from logs;';

$res = $db->query($sql);
while ($row = $res->fetchRow(DB_FETCHMODE_ASSOC)){
        print $row[host].",".$row[program].",".$row[msg]."\n";
}
$res->free();
exit;

?>

パート2 †

<?php
$file_location = DATA_PATH . $filepath;
$filesize = filesize($file_location);
header ("Accept-Ranges: none");
header ("Content-Length: $filesize");
if(strstr($HTTP_USER_AGENT, "MSIE")){
	header("Content-Type: $filemime");
}elseif($fileext == 'txt'){
	header("Content-Type: application/octet-stream");
}else{
	header("Content-Type: $filemime");
}
header("Content-Disposition: attachment; filename=$filename1");
mb_http_output("pass");
$fp=fopen("$file_location","rb");
@fpassthru($fp);
//		fclose($fp);
exit;
?>

エクスポート †

mb_http_output('pass');
Header('Content-Disposition: attachment; filename="'."t_between_ken.csv" . '"');
Header('Content-Type: text/plain');
Header('Content-Type: text/plain');