CI框架-导出csv文件
引入:
$this->load->dbutil();
$this->load->helper('file');
$this->load->helper('download');
函数:
function download() {
$query = $this->db->query("SELECT * FROM heatsys_customer");
$da ta = $this->dbutil->csv_from_result($query);
$Date = date("YmdHis");
$Filename = $Date.".csv";
force_download($Filename, $da ta);
}
编码问题:
在database目录下的DB_utility.php文件
部分源文件:
foreach ($query->result_array() as $row)
{
foreach ($row as $item)
{
$out .= $enclosure.str_replace($enclosure, $enclosure.$enclosure, $item).$enclosure.$delim;
}
$out = rtrim($out);
$out .= $newline;
}
修改文件为:
foreach ($query->result_array() as $row)
{
foreach ($row as $item)
{
$out .= $enclosure.str_replace($enclosure, $enclosure.$enclosure, iconv("UTF-8","GB2312//IGNORE",$item)).$enclosure.$delim;
}
$out = rtrim($out);
$out .= $newline;
}
$this->load->helper('file');
$this->load->helper('download');
函数:
function download() {
$query = $this->db->query("SELECT * FROM heatsys_customer");
$da
$Date = date("YmdHis");
$Filename = $Date.".csv";
force_download($Filename, $da
}
编码问题:
在database目录下的DB_utility.php文件
部分源文件:
foreach ($query->result_array() as $row)
{
foreach ($row as $item)
{
$out .= $enclosure.str_replace($enclosure, $enclosure.$enclosure, $item).$enclosure.$delim;
}
$out = rtrim($out);
$out .= $newline;
}
修改文件为:
foreach ($query->result_array() as $row)
{
foreach ($row as $item)
{
$out .= $enclosure.str_replace($enclosure, $enclosure.$enclosure, iconv("UTF-8","GB2312//IGNORE",$item)).$enclosure.$delim;
}
$out = rtrim($out);
$out .= $newline;
}