php將資料匯出為execl檔案格式

php將資料匯出為execl檔案格式 ?session_start(); $sql_excel=""; if(isset($_SESSION["excel"])) { $sql_excel=$_SESSION["excel"]; } //unset($_SESSION["excel"]); $conn=mysql_connect("localhost","root",""); mysql_select_db("test"); mysql_query("set names utf8",$conn); $result=mysql_query($sql_excel); header("Content-type:application/vnd.ms-excel"); header("Content-Disposition:attachment;filename=export_data.xls"); //$result=mysql_query($sql_excel); $result=mysql_query($sql_excel); while($arr = mysql_fetch_assoc($result)){ $content[]=$arr; } // print_r($content); $table = ' $table .= ' $table .= ' foreach($content as $key=>$value){ $table .= " $table .= " $table .= " $table .= " $table .= " $table .= " $table .= " $table .= ' } $table .= ' '; '; '; $table .= " "; '; '; '; '; '; '; '; '; $table .= ' '; id 標題 電話 地址 審核狀態 內容 留言時間 ".$value['id'].' ".$value['title'].' ".$value['phone'].' ".$value['address'].' ".$value['ischeck'].' ".$value['content'].' ".substr($value['datetime'],0,11).' '; echo $table; ?> 複製代碼 session_start(); $link= mysql_connect("localhost", "root", "") or die("Could not connect: " . mysql_error()); mysql_query("set names utf8",$link); mysql_select_db("test"); $sqls = "select * from news order by id desc "; $_SESSION["excel"]=$sqls; $rs1 = mysql_query($sqls); while($arr = mysql_fetch_assoc($rs1)){ $content[]=$arr; } echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' echo ' foreach ($content as $k => $v){ echo " echo " echo " echo " echo " echo " echo " echo " } echo ' '; '; '; '; '; '; '; '; '; '; '; '; '; '; echo " "; "; "; "; "; "; "; "; "; echo ''; echo ' '; 視頻列表(index:在首頁顯示 lanmu:在視頻頁顯示) 序號 使用者uid 顯示位置 檔案名稱 視頻名 視頻介紹 上傳時間 $k {$v['title']} {$v['phone']} {$v['address']} {$v['ischeck']} {$v['content']} {$v['datetime']} '; //var_dump($content); mysql_free_result($rs1); mysql_close($link); ?> 複製代碼

