将输入字段从选定的表行推送到数组中以遍历

<?php
// 连接数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 执行查询
$sql = "SELECT field_name FROM table_name WHERE condition";
$result = $conn->query($sql);

// 检查查询结果
if ($result->num_rows > 0) {
    // 创建一个数组来存储字段值
    $fieldValues = array();

    // 遍历结果集并将字段值存储到数组中
    while ($row = $result->fetch_assoc()) {
        $fieldValues[] = $row["field_name"];
    }

    // 处理数组，例如打印每个字段值
    foreach ($fieldValues as $value) {
        echo $value . "<br>";
    }
} else {
    echo "没有匹配的行";
}

// 关闭数据库连接
$conn->close();
?>