//快速导出csv
$file = '国家简码' . time(). '.csv';
header("Content-type:text/csv");
header("Content-Disposition:attachment;filename=".$file);
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
$top = "序号(ID),二位简码,国家英文名,国家中文名,创建人,创建时间,状态\n";
echo mb_convert_encoding($top, "CP936", "UTF-8"); //cp936就是指系统里第936号编码格式，也就是GB2312
$sql = "select * from country";
$data = db()->fetchAll($sql);
if (!empty($data)) {
foreach ($data as $key=>$item) {
$str = trim($item['id']) . ",";
$str .= trim($item['country_acronym_two']) . ",";
$str .= trim($item['country_name_en']) . ",";
$str .= trim($item['country_name_cn']) . ",";
$str .= $item['create_user'] . ",";
$str .= $item['create_time'] . ",";
$str .= ($item['status'] == 1) ? '启用,' : '禁用,';
$str .= "\n";
echo mb_convert_encoding($str, "CP936", "UTF-8");
unset($str);
}
}
//快速导出csv到服务器
$sql = "select * from teble_name";
$data = db()->fetchAll($sql);
if (!empty($data)) {
$header = array_keys($data['0']); //头部列
$fp = fopen('f:/test.csv', 'w');
fputcsv($fp,$header);
foreach ($data as $key => $val) {
fputcsv($fp, array_values($val)); //数据列
}
fclose($fp);
}
echo "数据导出完毕\r\n";
