phpcms数据库字典

<?php
$host = 'localhost';
$user = 'username';
$pass = 'password';
$dbname = 'phpcms';

$conn = new mysqli($host, $user, $pass, $dbname);

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

$sql = "SHOW TABLES";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $table_name = $row['Tables_in_' . $dbname];
        echo "Table: " . $table_name . "\n";
        
        $sql_fields = "SHOW COLUMNS FROM " . $table_name;
        $result_fields = $conn->query($sql_fields);
        
        if ($result_fields->num_rows > 0) {
            while($row_fields = $result_fields->fetch_assoc()) {
                echo "  Field: " . $row_fields['Field'] . "\n";
                echo "    Type: " . $row_fields['Type'] . "\n";
                echo "    Null: " . $row_fields['Null'] . "\n";
                echo "    Key: " . $row_fields['Key'] . "\n";
                echo "    Default: " . $row_fields['Default'] . "\n";
                echo "    Extra: " . $row_fields['Extra'] . "\n";
            }
        }
    }
} else {
    echo "0 结果";
}

$conn->close();
?>