如何使用mysqli和PHP获取多个值的数据

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

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

// 执行查询语句
$sql = "SELECT * FROM table_name";
$result = mysqli_query($conn, $sql);

// 处理结果集
if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_array($result)) {
        // 使用数据
        $value1 = $row['column1'];
        $value2 = $row['column2'];
        // 其他操作...
    }
} else {
    echo "没有找到数据";
}

// 关闭连接
mysqli_close($conn);
?>