douwen3965 2016-10-19 03:49 采纳率: 0%
浏览 39

导出Csv文件留下三个空行

i have a working export csv file code which have 3 blank lines before my header row. how do i remove the blank lines? so the header will be at the top.

include("global.php");

$Rid = $_SESSION['Rid'];

if(isset($_REQUEST['Rid']))
    $Rid = $_REQUEST['Rid'];
else
    $Rid = "";

$filename = "$Rid.csv";
$fp = fopen('php://output', 'w');

$header=array("DATE","REFNUMBER","MODEL","DESC","CODE","BAL","QTY");

header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);
fputcsv($fp, $header);

$query = "SELECT requisition_tb.daterequested , 
                 requisition_tb.refnumber ,
                 allinvty3.ecr_desc,
                 allinvty3.ite_desc,
                 requisition_tb.itemcode ,
                 requisition_tb.onhand , 
                 requisition_tb.qty 
          from requisition_tb 
     INNER JOIN allinvty3 on requisition_tb.itemcode = allinvty3.in_code 
          where requisition_tb.refnumber='".$Rid."' 
          ORDER BY allinvty3.ecr_desc ASC";

$result = mysql_query($query);
while($row = mysql_fetch_row($result)) {
    fputcsv($fp, $row);
}
?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 matlab中使用gurobi时报错
    • ¥15 WPF 大屏看板表格背景图片设置
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭
    • ¥15 2020长安杯与连接网探
    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
    • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
    • ¥16 mybatis的代理对象无法通过@Autowired装填
    • ¥15 可见光定位matlab仿真
    • ¥15 arduino 四自由度机械臂