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

*CSV形式でダウンロード [#j377d361]

**パート1 [#xbba35c1]
 <?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 [#n0c43a9a]
 <?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;
 ?>

**エクスポート [#j5307ff2]
 mb_http_output('pass');
 Header('Content-Disposition: attachment; filename="'."t_between_ken.csv" . '"');
 Header('Content-Type: text/plain');
 Header('Content-Type: text/plain');