使用PHP从MySql数据库生成Excel工作表

问题描述：

I'm new to PHP. I'm using the following code to generate an excel sheet from Mysql database using PHP.

<?php
    include("../Connection/Connection.php");
    $db_con=new Connection();
    $db_con->get_connection();  //Opens a database connection. This function is contained in the  Connection.php which is included above.

    $result = mysql_query("SELECT * FROM country");
    if (!$result) die('Couldn\'t fetch records');
    $num_fields = mysql_num_fields($result);
    $headers = array();

    for ($i = 0; $i < $num_fields; $i++) 
    {
        $headers[] = mysql_field_name($result , $i);
    }

    $fp = fopen('php://output', 'w');
    if ($fp && $result)
    {
            header('Content-Type: text/csv');
            header('Content-Disposition: attachment; filename="export.csv"');
            header('Pragma: no-cache');
            header('Expires: 0');
            fputcsv($fp, $headers);

            while ($row = mysql_fetch_array($result)) 
            {
                 fputcsv($fp, array_values($row));
            }
            die;
     }
?>

The above code is working and it generates the specified file export.csv but the problem is that it generates each column from MySql in this file twice. In other words, each column is duplicated twice (headers displayed are not duplicated though). What is wrong with this code? What changes should be made so that it displays each column exactly once?

我是PHP的新手。我正在使用以下代码使用PHP从Mysql数据库生成excel表。 p>

 ＆lt;？php 
 include（“../ Connection / Connection.php”  ）; 
 $ db_con = new Connection（）; 
 $ db_con-＆gt; get_connection（）;  //打开数据库连接。 这个函数包含在上面包含的Connection.php中。
 
 $ result = mysql_query（“SELECT * FROM country”）; 
 if（！$ result）die（'couldn \ tt tetch records'）  ; 
 $ num_fields = mysql_num_fields（$ result）; 
 $ headers = array（）; 
 
 for（$ i = 0; $ i＆lt; $ num_fields; $ i ++）
 {
 $ headers [  ] = mysql_field_name（$ result，$ i）; 
} 
 
 $ fp = fopen（'php：// output'，'w'）; 
 if（$ fp＆amp;＆amp; $ result）\  n {
 header（'Content-Type：text / csv'）; 
 header（'Content-Disposition：attachment; filename =“export.csv”'）; 
 header（'Pragma：no-cache'）  ; 
 header（'Expires：0'）; 
 fputcsv（$ fp，$ headers）; 
 
 while（$ row = mysql_fetch_array（$ result））
 {
 fputcsv（$ fp，array_values（  $ row））; 
} 
 die; 
} 
？＆gt; 
  code>  pre> 
 
 上面的代码正常工作，它会生成指定的文件 export.csv  code>但问题是它是一般的 从这个文件中的MySql中每列两次。 换句话说，每列重复两次（显示的标题不会重复）。 这段代码有什么问题？ 应该进行哪些更改，以便它只显示一列？ p> 
  div>

答

Use mysql_fetch_row instead.

mysql_fetch_array fetches an array with BOTH string indexes and numeric indexes, so each value is fetched twice. Your code would work with either mysql_fetch_assoc or mysql_fetch_row.

使用PHP从MySql数据库生成Excel工作表

相关推荐