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("設定名稱utf8",$conn);
- $result=mysql_query($sql_excel);
- header("內容類型: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;
-
- }
- $content_r( $ $( $content) $( $contentcontent );
- $table = '
';- $table .= '
;id | ;標題 th> |
電話 |
地址 |
審核狀態 |
內容 |
留言時間< ;/th> |
';
- $table .= '';
- foreach($content as $key=>$value){
- $table .= "
";- $table .= "
". $value['id'].' | ';
- $table .= "
"。 $value['title'].' | ';
- $table .= "
".$value['phone'].' | ';
- $表.= "
".$value['address'].' | ';
- $table .= "
".$value['ischeck'].''; - $table .= "
".$value['content'].' | ';
- $table .= "
". substr($value['datetime'] ,0,11).' | ';
- $table .= '
|
';
- }
- $table .= '
';
- $table .= '
';
- 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 '';
- //var_dump($content);
- mysql_free_result($rs1);
- mysql_close($ link);
- ?>
-
複製程式碼
|
本網站聲明
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn
作者最新文章
-
2024-10-22 09:46:29
-
2024-10-13 13:53:41
-
2024-10-12 12:15:51
-
2024-10-11 22:47:31
-
2024-10-11 19:36:51
-
2024-10-11 15:50:41
-
2024-10-11 15:07:41
-
2024-10-11 14:21:21
-
2024-10-11 12:59:11
-
2024-10-11 12:17:31