在PHP函数的for循环中将mysql_ result()转换为mysqli

$mysqli = mysqli_connect("localhost", "username", "password", "database");
if (!$mysqli) {
    die("连接失败: " . mysqli_connect_error());
}

$query = "SELECT * FROM table_name";
$result = mysqli_query($mysqli, $query);
if (!$result) {
    die("查询失败: " . mysqli_error($mysqli));
}

for ($i = 0; $i < mysqli_num_rows($result); $i++) {
    $row = mysqli_fetch_assoc($result);
    // 在这里处理每一行的数据
}

mysqli_free_result($result);

$mysqli = mysqli_connect("localhost", "username", "password", "database");
if (!$mysqli) {
    die("连接失败: " . mysqli_connect_error());
}

$query = "SELECT * FROM table_name";
$result = mysqli_query($mysqli, $query);
if (!$result) {
    die("查询失败: " . mysqli_error($mysqli));
}

for ($i = 0; $i < mysqli_num_rows($result); $i++) {
    $row = mysqli_fetch_assoc($result);
    // 在这里处理每一行的数据
}

mysqli_free_result($result);
mysqli_close($mysqli);