dede导出keywords表数据

<?php
/**
 * 导出keywords表数据
 */
require_once(dirname(__FILE__)."/dede/include/common.inc.php");
/*$dsn = "mysql:host=localhost;dbname=数据库名称";
$pdo = new PDO($dsn,'用户名','密码');
$res = $pdo->query("SELECT * FROM `dede_archives`");
$data = $res->fetchAll(PDO::FETCH_ASSOC);
print_r($data);die;*/
$sql = "SELECT * FROM `dede_keywords`";
$dsql->SetQuery($sql);
$dsql->Execute();
$list = [];
while($row = $dsql->GetArray()){
    $list[] = $row;
}
// 下载
set_time_limit(0);
ini_set('memory_limit', '256M');
//下载csv的文件名
$fileName = 'dede_keywords.csv';
//设置header头
header('Content-Description: File Transfer');
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="' . $fileName . '"');
header('Expires: 0');
header('Cache-Control: must-revalidate');
header('Pragma: public');
//打开php数据输入缓冲区
$fp = fopen('php://output', 'a');
$heade = ['aid', 'keyword', 'rank', 'sta', 'rpurl'];
//将数据编码转换成GBK格式
mb_convert_variables('GBK', 'UTF-8', $heade);
//将数据格式化为CSV格式并写入到output流中
fputcsv($fp, $heade);
//如果在csv中输出一个空行，向句柄中写入一个空数组即可实现
foreach ($list as $value) {
    //将数据编码转换成GBK格式
    mb_convert_variables('GBK', 'UTF-8', $value);
    $data['aid'] = $value['aid'];
    $data['keyword'] = $value['keyword'];
    $data['rank'] = $value['rank'];
    $data['sta'] = $value['sta'];
    $data['rpurl'] = $value['rpurl'];
    fputcsv($fp, $data);
    //将已经存储到csv中的变量数据销毁，释放内存
    unset($value);
}
//关闭句柄
fclose($fp);