php export data to execl file format

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 '< /thead>';echo '';foreach ($content as $k => $v){ echo ""; echo ""; echo ""; echo " "; echo ""; echo ""; echo "";  echo ""; }echo '';echo '';echo '
 Video list(index: Display on the homepage lanmu: Display on the video page) 


serial number
user uid< /th>';
echo 'Display location
File name
Video name
echo 'Video introduction
Upload time





$k
{$v['title']}< ;/td>";
 echo "{$v['phone']}
{$v['address']}
{$v['ischeck']}
{$v['content']}
{$v['datetime']}




';
 //var_dump($content);
 mysql_free_result($ rs1);
 mysql_close($link);
?>