在PHP中，可以使用以下两种方法将数据库表格输出：
使用HTML表格输出：可以通过循环遍历数据库查询结果，并使用HTML标签将数据以表格的形式输出。<?php// 连接数据库$servername = "localhost";$username = "username";$password = "password";$dbname = "dbname";$conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) {die("连接失败: " . $conn->connect_error);}// 查询数据库表格$sql = "SELECT * FROM tablename";$result = $conn->query($sql);// 输出表格if ($result->num_rows > 0) {echo "<table>";echo "<tr><th>列1</th><th>列2</th></tr>";while ($row = $result->fetch_assoc()) {echo "<tr><td>" . $row["列1"] . "</td><td>" . $row["列2"] . "</td></tr>";}echo "</table>";} else {echo "0 结果";}// 关闭数据库连接$conn->close();?><?php// 连接数据库$servername = "localhost";$username = "username";$password = "password";$dbname = "dbname";$conn = new mysqli($servername, $username, $password, $dbname);if ($conn->connect_error) {die("连接失败: " . $conn->connect_error);}// 查询数据库表格$sql = "SELECT * FROM tablename";$result = $conn->query($sql);// 创建CSV文件$filename = 'table.csv';$fp = fopen($filename, 'w');// 写入表头$headers = array('列1', '列2');fputcsv($fp, $headers);// 写入数据if ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) {$row_data = array($row["列1"], $row["列2"]);fputcsv($fp, $row_data);}}// 关闭文件fclose($fp);// 下载CSV文件header('Content-Type: application/csv');header('Content-Disposition: attachment; filename="' . $filename . '"');readfile($filename);// 删除临时文件unlink($filename);// 关闭数据库连接$conn->close();?>以上两种方法可以根据需求选择适合的方式将数据库表格输出。
