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);
?>