如何使用PHP + mysqli数据库查找列是否存在

$query = "SHOW COLUMNS FROM 表名";
$result = mysqli_query($connection, $query);

$columnExists = false;
while ($row = mysqli_fetch_assoc($result)) {
    if ($row['Field'] == '列名') {
        $columnExists = true;
        break;
    }
}

<?php
// 连接到数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";
$connection = mysqli_connect($servername, $username, $password, $dbname);

// 检查连接是否成功
if (!$connection) {
    die("连接失败: " . mysqli_connect_error());
}

// 查询列是否存在
$query = "SHOW COLUMNS FROM 表名";
$result = mysqli_query($connection, $query);

$columnExists = false;
while ($row = mysqli_fetch_assoc($result)) {
    if ($row['Field'] == '列名') {
        $columnExists = true;
        break;
    }
}

// 输出结果
if ($columnExists) {
    echo "列存在";
} else {
    echo "列不存在";
}

// 关闭数据库连接
mysqli_close($connection);
?>