How to access mysql result set data with a foreach loop

To access MySQL result set data with a foreach loop, you can fetch the result set into an array first, as mysqli_result objects are not directly iterable in PHP. You can use a loop like the following:

How to access MySQL result set data with a foreach loop in PHP?

<?php
// Example connection setup
$conn = mysqli_connect("localhost", "username", "password", "database");

$query = "SELECT id, name FROM users";
$result = mysqli_query($conn, $query);

if (!$result) {
    die("Query failed: " . mysqli_error($conn));
}

// Fetch all rows into an associative array
$rows = $result->fetch_all(MYSQLI_ASSOC);

foreach($rows as $row) {
  // process each row
}

In this example, $conn is a connection to the MySQL database, and $query is the query that you want to execute. The result set is stored in the $result variable, which is then converted to an array using fetch_all().

Inside the loop, $row will be an associative array that represents a single row in the result set. You can access the individual columns of the row by using their keys. For example:

How to access the individual columns of the row by using their keys in a MySQL result data set with a foreach loop in PHP?

<?php
foreach($rows as $row) {
  echo "ID: " . $row['id'];
  echo "Name: " . $row['name'];
}

This will loop through all the rows in the result set, and print out the id and name column values for each row.

Note that this code assumes that you are using the MySQLi extension for PHP. If you are using a different MySQL library, the syntax may be slightly different.