PHP code example of fdd / php-helper

1. Go to this page and download the library: Download fdd/php-helper library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.

    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

fdd / php-helper example snippets


    $list   = [
        [
            "title"   => "你是什么垃圾？",
            "type"    => 1,
            "content" => "喵喵喵？？？",
            "img"     => "/static/uploads/20190928\77871c95d3f86e6f4f5b7fb3655355be.jpg",
            "create_time" => time(),
        ]
    ];  //数据
    $header = [
        ['标题', 'title', 'text'],
        ['内容', 'content', 'text'], // 规则不填默认text
        ['类型', 'type', 'selectd', [1 => '新闻', 2 => '刊物']],
        ['图片链接', 'img', 'function', function ($model) {
            return  'www.myadmin' . $model['msg_img'];
        }],
        ['创建时间', 'create_time', 'data', 'Y-m-d'],
    ];//表头
    $fileName = time();  //文件名 默认当前时间戳
    $suffix   = 'xlsx';  //后缀名 默认-xlsx-(xlsx/xls/html/csv)
    return ExcelExportV2:: export($list, $header, $fileName,$suffix);


    $filePath   = './static/excel/1.xlsx'; //文件路径
    $startIndex = 1;                       //开始行数 默认 1
    $data = ExcelExportV2::import($filePath, $startIndex);
    var_dump($data);