Use foreach instead of while with mysqli_fetch_object

Question

Is there any method to use foreach instead of while with mysqli_fetch_object($query)?

For example:

while($row = mysqli_fetch_object($query)) {
    echo $row->title;
}

How to use it with Foreach?

xate · Accepted Answer · 2014-07-02 07:32:38Z

5

IF you have PHP 5.4 you could do this:

// Using iterators (support was added with PHP 5.4)
foreach ( $c->query('SELECT user,host FROM mysql.user') as $row ) {
    printf("'%s'@'%s'\n", $row['user'], $row['host']);
}

LIke this you use the iterator to loop through every result set and then you can use it as $row a

answered Jul 2, 2014 at 7:32

xate

6,3723 gold badges20 silver badges43 bronze badges

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

5 Comments

ITChristian Over a year ago

Thanks. I'm creating an application and I want to make it working with lower php versions, too.

xate Over a year ago

@MMPP Why? You should keep your versions up-to-date

ITChristian Over a year ago

I have all versions up-to-date. I want to allow users to download and use it. That's why I want to make it working with some php versions. However, best answer! Thanks a lot!

xate Over a year ago

Hm. I think there's no other way to actually use a foreach to loop through a result set

ITChristian Over a year ago

No problem. I will keep while.

Collectives™ on Stack Overflow

Use foreach instead of while with mysqli_fetch_object

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related