php 导出excel

header("Content-type:application/vnd.ms-excel");header("Content-Disposition:filename=seller.xls");error_reporting(0);$default_arr = explode(",", $content);$str = "\xEF\xBB\xBF<table border='1'><tr><td>ID</td><td>名称</td><td>主营厂商</td><td>400电话</td><td>400电话权限</td></tr>";$sql = "xxxx ";$query = $db->query($sql);while ($re = $db ->fetch_array($query)){$is_400 = "没有";if(in_array($re['id'], $default_arr)){$is_400 = "有";}if($re['brands']){$brands_arr = json_decode($re['brands']);$spl = "";$brands = "";foreach ($brands_arr as $brand){$brands .=$spl.$brand ->name;$spl = ",";}}else{$brands = "";}$str .= "<tr><td>{$re['id']}</td><td>{$re['sellername']}</td><td>{$brands}</td><td>{$re['telephone_400']}</td><td>{$is_400}</td></tr>";}echo $str;