phpcms批量添加数据库表

<?php
// 数据库连接配置
$host = 'localhost';
$dbname = 'phpcms';
$user = 'root';
$pass = '';

try {
    // 创建 PDO 实例
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);

    // 定义要创建的表结构
    $tables = [
        [
            'name' => 'table1',
            'structure' => "
                id INT AUTO_INCREMENT PRIMARY KEY,
                name VARCHAR(255) NOT NULL,
                email VARCHAR(255) NOT NULL
            "
        ],
        [
            'name' => 'table2',
            'structure' => "
                id INT AUTO_INCREMENT PRIMARY KEY,
                title VARCHAR(255) NOT NULL,
                content TEXT
            "
        ]
    ];

    // 执行创建表的 SQL 语句
    foreach ($tables as $table) {
        $sql = "CREATE TABLE IF NOT EXISTS `$table[name]` ($table[structure])";
        $pdo->exec($sql);
        echo "Table $table[name] created successfully.\n";
    }
} catch (PDOException $e) {
    echo "Error: " . $e->getMessage();
}
?>