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 .= '
id |
标题 |
电话 |
地址 |
审核状态 |
内容 |
留言时间 |
';
- $table .= '';
- foreach($content as $key=>$value){
- $table .= "
";- $table .= "
".$value['id'].' | ';
- $table .= "
".$value['title'].' | ';
- $table .= "
".$value['phone'].' | ';
- $table .= "
".$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);
- ?>
-
复制代码
|