php 原生导出

最新推荐文章于 2022-12-06 11:06:06 发布

忠忠

最新推荐文章于 2022-12-06 11:06:06 发布

阅读量281

点赞数

文章标签： php

本文链接：https://blog.csdn.net/qiannz/article/details/127396854

版权

   /**
     * 导出
     */
    public function export()
    {
        header("Content-type:application/vnd.ms-excel, charset=utf-8");
        header("Content-Disposition:attachment;filename=news.xls");

        $tab = "\t";
        $br = "\n";
        $head = "标题" . $tab . "作者". $tab . "图片". $tab . "创建时间" . $br;
        //输出内容如下：
        echo $head;

        $data = array (
            0 =>
                array (
                    'title' => '湖北陈抟老祖公司为十堰市公安劳模的进行武当睡功睡眠养身讲座',
                    'author_name' => '齐鲁视窗',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/b0ba0d49d3c96bcc7894f0da25e8f2f4.jpeg',
                    'create_time' => '10-18',
                ),
            1 =>
                array (
                    'title' => '四川省减灾委启动省自然灾害一级救助应急响应',
                    'author_name' => '人民网－四川频道，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/b2b6a53106868d6063758dca888b1e54.jpeg',
                    'create_time' => '10-18',
                ),
            2 =>
                array (
                    'title' => '四川省抗震救灾指挥部启动省级地震一级应急响应',
                    'author_name' => '人民网－四川频道，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/d78719ca897d60a324e4d3b3498b8aeb.jpeg',
                    'create_time' => '10-18',
                ),
            3 =>
                array (
                    'title' => '关键时刻能救命！这份地震避险自救手册请收好',
                    'author_name' => '人民日报客户端，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/3007dca6a4225b48da14acdcb4043ab6.jpeg',
                    'create_time' => '10-18',
                ),
            4 =>
                array (
                    'title' => '小沈阳状告万小刀！一场对自媒体人具有“风向标意义”的肖像权官司',
                    'author_name' => '新闻晨报，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/48fcc657ddcf631bd033e65d19f9a726.jpeg',
                    'create_time' => '10-18',
                ),
            5 =>
                array (
                    'title' => '“9•5”泸定6.8级地震丨省医院第二批20名医疗队员抵达石棉县',
                    'author_name' => '人民日报客户端四川频道，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/ada0ec9cd885288b316d18a95e88c2d5.jpeg',
                    'create_time' => '10-18',
                ),
            6 =>
                array (
                    'title' => '288.8万元！鄂州给他们送来及时雨',
                    'author_name' => '鄂州新闻网，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/news/a3e31c99242feb21f0da254a79c7fb54.jpeg',
                    'create_time' => '10-18',
                ),
            7 =>
                array (
                    'title' => '她到北京替丈夫受领荣誉',
                    'author_name' => '大河网，供稿：人民资讯',
                    'img' => 'http://rhkjsy41p.hd-bkt.clouddn.com/',
                    'create_time' => '10-18',
                ),
        );

        //$data = News::order('id', 'desc')->field('title,author_name,img,create_time')->select();

        foreach ($data as $item) {
            echo $item ['title']. $tab;
            echo $item ['author_name']. $tab;
            echo $item ['img']. $tab;
            echo $item ['create_time'];
            echo $br;
        }

        exit();
    }