从所有行检索并显示它

Question

$query = "SELECT * FROM main";

    if ($result = $db->query($query)) {

        while ($row = $result->fetch_assoc()) {
            $name= $row["name"];
            $image = $row["image"];


        }

    }

then somewhere in my code I print it out using like echo $name; but I got only one result, which is the last row. I know I have to do foreach but what variable should I put?

foreach($result as $results) ? like this?

Answer 1

On every iteration, you reassign the values to $name and $image, causing it to show only the last value when it leaves the loop.

You can either echo them right away in the loop, or populate an array or an object with them, so they will be available later.

Example:

$data = array();
while ($row = $result->fetch_assoc()) {
    $data[] = array('name'=>$row["name"], 'image'=>$row["image"]); // push into the array
}

var_dump($data); // it's all here now

And to echo the data later, one of the ways is foreach:

foreach($data as $row) {
    echo "Name: ", $row['name'], "; Image: ", $row['image];
}