excel 导出

admin10个月前Laravel478
    header("Content-Type: application/vnd.ms-excel; name='excel'"); header("Content-Disposition:attachment;filename=" . date('Y-m-d', time()) . "商品订单.xls"); echo <<< EOT <html xmlns:o="urn:schemas-microsoft-com:office:office"  xmlns:x="urn:schemas-microsoft-com:office:excel"  xmlns="http://www.w3.org/TR/REC-html40"> <head><meta http-equiv="Content-type" content="text/html;charset=utf-8" /></head> <body>  <table border="1" width="80%">  <tr>  <td align="center">档口</td>  <td align="center">商品</td>  <td align="center">下单时间</td>  <td align="center">导出时间</td>  </tr> EOT; foreach ($list as $row) { echo <<< EOT  <tr>  <td align="center">{$row["title"]}</td>  <td align="center">{$row["data"]}</td>  <td align="center">{$row["date"]}</td>  <td align="center">{$row["time"]}</td>  </tr> EOT;
        } echo <<< EOT </table> </body> </html> EOT;

相关文章

腾讯云发送短信

<?phpnamespace App\Http\Controllers;use Illuminate\Http\Request;use Illuminate\Support\Facades\DB...

上传图片

public function image(){    $obFile = request()->file('image');    if...

修改密码

/** * 修改密码 */publicfunction setpass(){    $type = request()->input('type');// 1...

压缩图片

public static function size($id, $img) { try { list($width, $height, $img_type, $attr) = @getimages...

查找下级所有数据

public function bottom($mid = 3){    $members = DB::select('select id,parent_id,`level...

设置项目编号

$max = Db::table('member')->max('id') ?? 0; if ($max < 100000) { $cd = $this->create...