php - 将文件从数据库导出到csv时，它在表列名称的行中显示内容

Question

将文件导出到 csv 时，我的内容被添加到列名称的同一行中。我希望内容位于相应列的下方。代码如下

     <?php
        $filename = "file.csv";
        $fp = fopen('php://output', 'w');           
        header('Content-type: application/csv');
        header('Content-Disposition: attachment; filename='.$filename);
        $headerLine = 'Sr. No,Name,DOB,Address';
        fwrite($fp, $headerLine);
         $query = "select * from registratin";
        $result = mssql_query($query);
        $i = 1;
        while($row = mssql_fetch_row($result)) {
          $row = array_merge(array($i), $row);
          fputcsv($fp, $row);
          $i++;
        }

      ?>

Answer 1

简单如下即可，无需数组合并

<?php
        $filename = "file.csv";
        $fp = fopen('php://output', 'w');           
        header('Content-type: application/csv');
        header('Content-Disposition: attachment; filename='.$filename);
        $headerLine = 'Sr. No,Name,DOB,Address';
        fputcsv($fp, explode(",",$headerLine); // adding heading
        $query = "select * from registratin";
        $result = mssql_query($query);
        $i = 1;
        while($row = mssql_fetch_row($result)) {
          //$row = array_merge(array($i), $row); ***no need***
          fputcsv($fp, $row);
          $i++;
        }
        fclose($fp);

?>