Mysqli_fetch_array not working for forearch loop

Question

I'm trying to fetch data and display it via foreach loop but it's not working giving argument error but when i try this with while loop it's work fine. so my question is that why i cannot fetch data using mysqli_fetch_array with foreach why it's only possible with while loop

// While
while($row = mysqli_fetch_row($result))
{
    var_dump($row); echo "<hr />";  
}

// Foreach
foreach(mysqli_fetch_array($result) as $row)
{
    var_dump($row); echo "<hr />";
}

its different, while will continually invoke the the function, the foreach will not — Kevin
– Kevin, Commented Sep 23, 2016 at 6:55

vishal shah · Accepted Answer · 2016-09-23 06:56:44Z

1

You can't use foreach for mysqli_fetch_array directly. Foreach is a loop using for an exist array, to loop through each its item

You can use like below

$result = array();
    while($row = mysqli_fetch_array($result)) {
       $result[] = $row;
    }

    foreach($result as $row) {
        var_dump($row);
        echo "<hr />";
    }

answered Sep 23, 2016 at 6:56

vishal shah

3162 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roy123 Over a year ago

will using a reference; foreach(mysqli_fetch_array($result) as &$row) work?

u_mulder · Accepted Answer · 2016-09-23 06:55:22Z

0

Because mysqli_fetch_array as comes from it's name - fetches one row of your result as array.

So, foreach(mysqli_fetch_array($result) as $row) means

Fetch one row and iterate over this row.

While while($row = mysqli_fetch_row($result)) means

Do fetching rows until there's nothing to fetch. And when there's nothing to fetch while-condition is false and the loop breaks.

Info about while-loop and foreach-loop

answered Sep 23, 2016 at 6:55

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Collectives™ on Stack Overflow

Mysqli_fetch_array not working for forearch loop

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related