while or foreach

[mga_ka_php]

why does wordpress is using foreach rather than while in listing records?

 

common

while ($products = mysql_fetch_object($rs) {
...
}

 

but wordpress is using foreach

foreach ($posts as $post) {
...
}

 

which is better? because i'm trying to create my own code for database connection.

 

[Chris92]

foreach is faster.

[mga_ka_php]

i see that they use array in getting records from the database.

 

while ( $row = @mysql_fetch_object( $this->result ) ) {
    $this->last_result[$num_rows] = $row;
    $num_rows++;
}

 

what if my records is 50,000. does array can hold that number of records, or does it use to much memory?

[Chris92]

Depending on your computer and PHP settings. It might timeout if your computer can't store that much.

 

It's better to then unset the records after they have been used.

[rwwd]

Is this wordpress too:-

while ( $row = @mysql_fetch_object( $this->result ) ) {

 

Bad coding methods afoot here...

 

If it is, this is why I use a tiny text editor, so that I know what's going on, and don't get me started on DreamWeaver, ugh.

 

Original question: While loops are preferred for iterating through DB/Array records, for loops and foreach take more memory as you are assigning temporary memory whilst the loop completes, also, preferred to use functions OUTSIDE the for loop to then there is less over head involved parser side.

 

Rw

[mga_ka_php]

while loop is better?

[salathe]

Neither is better nor worse. They're just two ways of looping. Choose whichever you find gets the job done best, or at all.

[kickstart]

Hi

 

Using foreach for this suggests that Wordpress is reading the entire result set into an array before processing it, rather than allowing the programmer to just retrieve a row at a time.

 

All the best

 

Keith

[mga_ka_php]

thanks for all of your replies.