php如何把数据库的数据导出Excel表格

	error_reporting(E_ALL ^ E_DEPRECATED);
    $localhost = '127.0.0.1';
    $dbname = '数据库name';
    $dbuser = '数据库user';
    $dbpwd = '数据库pwd';
    $tbname = "数据表name";
    ob_end_clean();
    header('Content-type: text/html; charset=utf-8');
    header("Content-type:application/vnd.ms-excel;charset=UTF-8"); 
    header("Content-Disposition:filename=excel.xls");// excel.xls为导出的数据表信息
    $conn = mysql_connect($localhost,$dbuser,$dbpwd) or die("连接数据库失败");
    mysql_select_db($dbname, $conn);
    mysql_query("set names 'UTF-8'");
 
    $result=mysql_query("SELECT * FROM $tbname");
    echo "<table>";
    echo "<tr>";
    echo "<th>ID</th>";//A1单元格
    echo "<th>姓名</th>";//B1单元格
    echo "<th>年龄</th>";//C1单元格
    echo "<th>城市</th>";
	echo "<th>校区</th>";
	echo "<th>电话</th>";
	echo "<th>来源</th>";
	echo "<th>时间</th>";
    echo "</tr>";
    echo "</table>";
    while($row=mysql_fetch_array($result)){
        $data1 = $row["id"];
        $data2 = $row["cname"];
        $data3 = $row["age"];
        $data4 = $row["city"];
		$data5 = $row["cxiaoqu"];
		$data6 = $row["ciphone"];
		$data7 = $row["domian"];
		$data8 = $row["time"];
        
        //输出字段的数据到单元格
        //下面data改成你自己数据库对应的字段
        echo "<table>";
        echo "<tr>";
            echo "<td>$data1</td>";
            echo "<td>$data2</td>";
            echo "<td>$data3</td>";
            echo "<td>$data4</td>";
			echo "<td>$data5</td>";
            echo "<td>$data6</td>";
            echo "<td>$data7</td>";
            echo "<td>$data8</td>";
        echo "</tr>";
        echo "</table>";
    }