find('h3>a')->texts(); //获取搜索结果标题列表
//$links = $ql->find('h3>a')->attrs('href'); //获取搜索结果链接列表
//print_r($titles);
//print_r($links);
//die();
$wd = $_REQUEST['wd'];
if (!$wd) {
?>
find("#rs > table");
$tableRows = $table->find('tr')->map(function ($row) {
return $row->find('th')->texts()->all();
});
$data = $tableRows->all();
$_result = [];
foreach ($data as $item) {
foreach ($item as $value) {
$_result[] = $value;
}
}
$result[] = [
'keyword' => $key,
'related_keywords' => $_result
];
}
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$row = 1;
foreach ($result as $key => $item) {
$sheet->setCellValueByColumnAndRow(1, $row++, $item['keyword']);
foreach ($item['related_keywords'] as $related_keyword) {
$sheet->setCellValueByColumnAndRow(2, $row++, $related_keyword);
}
$row++;
}
$writer = new Xlsx($spreadsheet);
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header('Content-Disposition:attachment;filename="相关搜索词.xlsx"');
header("Content-Transfer-Encoding:binary");
$writer->save('php://output');
$spreadsheet->disconnectWorksheets();
}