作者koizumisyou (不小的挑战)
看板PHP
标题[请益] 请问Array换行
时间Fri Sep 14 23:35:41 2012
感谢各位先进
已经可以输出查询之CSV
现在的问题是如何让查询结果换行？？
<?php
mysql_select_db($database_AdvList, $AdvList);
$query_Search = "$q";
$Search = mysql_query($query_Search, $AdvList) or die(mysql_error());
$row_Search = mysql_fetch_assoc($Search);
$totalRows_Search = mysql_num_rows($Search);
$F = date ('md');
$Wr=fopen("php://output","w+");
=======================================问题在下面程式
do {
$V1 = $row_Search['AdvID'];
$V2 = $row_Search['AdvName'];
$V3 = $row_Search['Maker'];
$V4 = $row_Search['AdvSize'];
$V5 = $row_Search['AppearDate'];
$V6 = $row_Search['AdvDate'];
$V7 = $row_Search['AdvTime'];
fputcsv($Wr,array("$V1","$V2","$V3","$V4","$V5","$V6","$V7","\r\n"));
} while ($row_Search = mysql_fetch_assoc($Search));
header("Content-Type: text/html; charset=utf-8");
header("Content-type: text/x-csv");
header("Content-Disposition:attachment;filename=$F.csv");
?>
======
我之前用fopen 时 "\r\n"是OK的
现在会变成
"跳一行
"
我想换行该怎麽做？？谢谢
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 60.248.100.98
※ 编辑: koizumisyou 来自: 60.248.100.98 (09/14 23:43)
1F：→ arrack:fputcsv本身就有 09/15 11:46
3F：→ arrack:写在内容里面 会被当成是内容 09/15 11:47
4F：→ koizumisyou:已解决！谢谢arrack 09/17 00:42