Change 'while' by 'foreach' in 'mysql_fetch_row' in PHP

Question

Is it possible to change while by foreach in mysql_fetch_row in PHP?

For example

$result = mysql_query("SELECT * FROM test");

while ($row = mysql_fetch_row($result)) {
    print_r($row);
}

This will take all records(rows) from query SELECT * FROM test.

But, if foreach is used

foreach (mysql_fetch_row($result) as $row) {
    print_r($row);
}

This will take only first record(row) from query SELECT * FROM test.

Is it possible get all records by foreach loop when using with mysql_fetch_row ?

Because it handles what your trying to do. Actually nevermind. You're trying to get all rows, without specifying their column names — Ryan
– Ryan, Commented Apr 13, 2012 at 18:44

rid · Accepted Answer · 2012-04-13 22:16:26Z

3

You can only use foreach if:

you create a class that implements ArrayAccess or Iterator, or
you obtain the whole result set in an array and use that array with foreach.

You could use a for loop, but the code would be less than readable:

for ($row = mysql_fetch_row($result); $row !== false; $row = mysql_fetch_row($result)) {
    print_r($row);
}

edited Apr 13, 2012 at 22:16

answered Apr 13, 2012 at 18:40

rid

64k31 gold badges159 silver badges201 bronze badges

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

3 Comments

dev-null-dweller Over a year ago

Should be Iterator instead of ArrayAccess

rid Over a year ago

@dev-null-dweller, both ArrayAccess and Iterator can be used with foreach. Updated answer.

dev-null-dweller Over a year ago

But ArrayAcces does not give you control on order of kes/values and skips protected/private properties, and fails completely when using internal array (or resource in this case) as data holder instead of class properties, so it can give different results when accessing as array and iterating with foreach, so to have true iterable object, better use Iterator.

rid · Accepted Answer · 2012-04-13 18:48:00Z

1

No, because foreach needs a array. Here, mysql_fetch_row() returns only one row at a time.

edited Apr 13, 2012 at 18:48

rid

64k31 gold badges159 silver badges201 bronze badges

answered Apr 13, 2012 at 18:42

Anil

5881 gold badge4 silver badges12 bronze badges

1 Comment

Justin John Over a year ago

It is possible with for loop

Collectives™ on Stack Overflow

Change 'while' by 'foreach' in 'mysql_fetch_row' in PHP

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related