php怎么导出数据库表结构

<?php
// 数据库连接信息
$host = 'localhost';
$user = 'username';
$password = 'password';
$dbname = 'database_name';

// 创建数据库连接
$conn = new mysqli($host, $user, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 获取所有表名
$tables = $conn->query("SHOW TABLES");

// 创建SQL文件
$sqlFile = 'exported_tables.sql';
$fileHandle = fopen($sqlFile, 'w');

if ($fileHandle === false) {
    die("无法创建文件: " . $sqlFile);
}

// 导出每个表的结构
while ($table = $tables->fetch_array()) {
    $tableName = $table[0];
    $result = $conn->query("SHOW CREATE TABLE `$tableName`");
    $row = $result->fetch_assoc();
    $sql = "DROP TABLE IF EXISTS `$tableName`;\n";
    $sql .= $row['Create Table'] . ";\n\n";
    fwrite($fileHandle, $sql);
}

fclose($fileHandle);
$conn->close();

echo "数据库表结构已导出到文件: " . $sqlFile;
?>