How to convert mysql_result to mysqli result in this example

Question

I understand how to fetch a result in mysqli, but how would this example be coded for mysqli?

    for ($i = 0; $i < $num_rows; $i++) {
    $uname = mysql_result($result, $i, "username");
    $email = mysql_result($result, $i, "email");

    echo "<tr><td>$uname</td><td>$email</td></tr>\n";
}

Thanks for taking a look

You really should read the MySQLi docs. You'll need to change more than that line. Your mysql_connect, mysql_query, etc. stuff all needs replacement. — ceejayoz, Jun 24 '16 at 19:54

score 1 · Answer 1 · answered Jun 24 '16 at 19:57

Assuming you've converted your other calls to return $result as a mysqli_result object, the most efficient way to do this would probably be

while ($row = $result->fetch_assoc())
{
    echo "<tr><td>{$row['username']}</td><td>{$row['email']}</td></tr>\n";
}

score 1 · Accepted Answer · edited Apr 05 '22 at 08:29

1

You can do like this:

while ($row = mysqli_fetch_assoc($result)) {
    $uname = $row["username"];
    $email = $row["email"];

    echo "<tr><td>$uname</td><td>$email</td></tr>\n";
}

edited Apr 05 '22 at 08:29

Your Common Sense

156,878
40
214
345

answered Jun 24 '16 at 20:00

spirit

3,265
2
14
29

How to convert mysql_result to mysqli result in this example

2 Answers2