layui導(dǎo)出所有數(shù)據(jù)的例子

<button class="layui-btn layui-btn layui-btn-warm" οnclick="excl_rep()">導(dǎo)出</button>

//導(dǎo)出
function excl_rep() {
 var SH=$("#type").val();//匯總分類
 var SER = $("#ser_row").val(),
  ONETYPE = $("#type_one").val(),//一級分類
  TWOTYPE = $('#type_two').val();//二級分類
  var BRAND=$('#type_p').val();
 var url = "{:U('home/goods/brand_goods_img_excl')}" + "&ser=" + SER +'&type_h='+SH+ "&type_one=" + ONETYPE + "&type_two=" + TWOTYPE+"&brand="+BRAND ;
 //console.log(url);
 window.open(url);
}

function brand_goods_img_excl(){
 header("Content-type:application/vnd.ms-excel");
 header("Content-Disposition:filename=品牌商品上圖.xls");
 $data = api("goods/brand_goods_img_get_excel",I("param."));//I（）方法獲取傳過來參數(shù)
 $list = $data['data'];//獲取數(shù)據(jù)庫查詢的數(shù)據(jù)
 $strexport="商品編碼\t商品名稱\t商品圖片\t商品圖片1\t商品圖片2\t一級分類\t二級分類\t單位\t品牌\r";
 foreach ($list as $row){
  $strexport.=$row['jfcode']."\t";
  $strexport.=$row['name']."\t";
  $strexport.=$row['img']."\t";
  $strexport.=$row['img1']."\t";
  $strexport.=$row['img2']."\t";
  $strexport.=$row['one_type_name']."\t";
  $strexport.=$row['two_type_name']."\t";
  $strexport.=$row['unit_name']."\t";
  $strexport.=$row['br_name']."\r";
 }
 $strexport=iconv('UTF-8',"GB2312//IGNORE",$strexport);
 exit($strexport);
}