chendeben
/
wangyating


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112
							<?php
set_time_limit(0);
/**
 * Created by PhpStorm.
 * User: chendeben
 * Date: 2019-01-16
 * Time: 17:06
 */
require_once('vendor/autoload.php');

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use QL\QueryList;

//$ql = QueryList::get('https://www.baidu.com/s?wd=QueryList');
//$titles = $ql->find('h3>a')->texts(); //获取搜索结果标题列表
//$links = $ql->find('h3>a')->attrs('href'); //获取搜索结果链接列表
//print_r($titles);
//print_r($links);
//die();


$wd = $_REQUEST['wd'];
if (!$wd) {
    ?>
    <!DOCTYPE html>
    <html lang="zh-cn">
    <head>
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <!-- ZUI 标准版压缩后的 CSS 文件 -->
        <link rel="stylesheet" href="//cdn.bootcss.com/zui/1.8.1/css/zui.min.css">

        <!-- ZUI Javascript 依赖 jQuery -->
        <script src="//cdn.bootcss.com/zui/1.8.1/lib/jquery/jquery.js"></script>
        <!-- ZUI 标准版压缩后的 JavaScript 文件 -->
        <script src="//cdn.bootcss.com/zui/1.8.1/js/zui.min.js"></script>
    </head>
    <body>
    <br>
    <br>
    <br>
    <br>
    <form method="post" action="">
        <div class="container">
            <div class="row">
                <div class="col-md-9">
                <textarea style="height: 300px;" class="form-control" rows="3" placeholder="请输入关键词，一行一个" name="wd"></textarea>
                </div>
            </div>
            <div class="row" style="margin-top: 5px;">
                <div class="col-md-2 col-md-offset-8">
                    <input type="submit"  class="btn btn-primary  btn-lg" value="提交"/>
                </div>
            </div>
        </div>

    </form>

    </body>
    </html>
    <?php
} else {
    $_url = "http://www.baidu.com/s?ie=UTF-8&wd=%s";
    $origin_str = [';', '；', ',', '，', ' ',"\r\n"];
    $des_str = [',', ',', ',', ',', ',',','];
    $wd = str_replace($origin_str, $des_str, $wd);
    $keys = explode(",", $wd);
    $result = [];
    foreach ($keys as $key) {
        $url = sprintf($_url, $key);
        $ql = QueryList::get($url);
        $table = $ql->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();
}