What are the advantages of using mysqli_fetch_assoc or $result->fetch_assoc over mysqli_fetch_array in PHP?

Using mysqli_fetch_assoc or $result->fetch_assoc over mysqli_fetch_array in PHP provides the advantage of fetching data as an associative array, which makes it easier to access values using column names rather than numerical indices. This can lead to cleaner and more readable code, especially when dealing with large result sets from database queries. 

// Using mysqli_fetch_assoc
$query = "SELECT * FROM users";
$result = mysqli_query($connection, $query);

while($row = mysqli_fetch_assoc($result)) {
    echo $row['username'] . "<br>";
}

// Using $result->fetch_assoc
$query = "SELECT * FROM users";
$result = $connection->query($query);

while($row = $result->fetch_assoc()) {
    echo $row['username'] . "<br>";
}

Keywords

mysqli_fetch_assoc $result->fetch_assoc mysqli_fetch_array PHP advantages

Related Questions