将MySQLi查询结果存储在PHP变量中

<?php
// 连接到MySQL数据库
$connection = mysqli_connect("localhost", "username", "password", "database");

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

// 执行查询语句
$query = "SELECT * FROM users";
$result = mysqli_query($connection, $query);

// 处理查询结果
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        // 将查询结果存储在PHP变量中
        $userId = $row["id"];
        $username = $row["username"];
        $email = $row["email"];

        // 在这里可以对查询结果进行进一步处理或显示
        echo "用户ID: " . $userId . "<br>";
        echo "用户名: " . $username . "<br>";
        echo "电子邮件: " . $email . "<br>";
        echo "<br>";
    }
} else {
    echo "没有找到匹配的记录";
}

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