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

发表于编程技术版块

<?php
    error_reporting(E_ALL ^ E_DEPRECATED);
    $localhost = '数据库地址';
    $dbname = '数据库名';
    $dbuser = '数据库账号';
    $dbpwd = '数据库密码';
    $tbname = "需要导出的数据库表名";

    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=data.xls");// 文件名自己改，默认data.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>A1单元格</th>";
    echo "<th>B1单元格</th>";
    echo "<th>C1单元格</th>";
    echo "<th>D1单元格</th>";
    echo "</tr>";
    echo "</table>";
    while($row=mysql_fetch_array($result)){
        //下面data改成你自己数据库对应的字段
        $data1 = $row["data1"];
        $data2 = $row["data2"];
        $data3 = $row["data3"];
        $data4 = $row["data4"];
        
        //输出字段的数据到单元格，www.3qpd.com
        //下面data改成你自己数据库对应的字段
        echo "<table>";
        echo "<tr>";
            echo "<td>$data1</td>";
            echo "<td>$data2</td>";
            echo "<td>$data3</td>";
            echo "<td>$data4</td>";
        echo "</tr>";
        echo "</table>";
    }
?>

本文转载至鸿盟创客https://www.3qpd.com/read-470-1.html

2023-10-05 20:34

评论列表评论

资源网www.3qpd.com 八级站长 VIP 2#

上面的代码有点小问题，修复了
普通方式导出，excel.php代码：
<?php
//php7.2
error_reporting(E_ALL ^ E_DEPRECATED); // 数据库连接信息
$localhost = "root";
$dbuser = "root";
$dbpwd = "root";
$dbname = "root";
$tbname = "pk_user";
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=data.xls");// 文件名自己改，默认data.xls
$conn = mysqli_connect($localhost, $dbuser, $dbpwd, $dbname) or die("连接数据库失败");
mysqli_query($conn, "set names 'UTF-8'");
$result = mysqli_query($conn, "SELECT * FROM $tbname");
echo "<table>";
echo "<tr>";
echo "<th>IP</th>";
echo "<th>用户名</th>";
echo "<th>密码</th>";
echo "<th>邮箱</th>";
echo "</tr>";
while ($row = mysqli_fetch_assoc($result)) { // 使用mysqli_fetch_assoc()替换mysql_fetch_array()
    $data1 = $row["regip"];
    $data2 = $row["username"];
    $data3 = $row["password"];
    $data4 = $row["email"]; //输出字段的数据到单元格 //下面data改成你自己数据库对应的字段
    echo "<tr>";
    echo "<td>$data1</td>";
    echo "<td>$data2</td>";
    echo "<td>$data3</td>";
    echo "<td>$data4</td>";
    echo "</tr>";
}
echo "</table>"; 
?>

共0条回复,点击查看回复

2023-10-06

加载更多