StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
18536588
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-08-30T15:31:03.800
FavoriteCount
0
LastActivityDate
2013-08-30T15:39:37.020
LastEditDate
2017-05-23T11:44:45.250
LastEditorUserId
-1
OwnerUserId
833795
ParentId
18529164
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Collection classes in Magento's ORM ultimately subclass <a href="https://github.com/benmarks/magento-mirror/blob/magento-1.7/lib/Varien/Data/Collection.php#L34" rel="nofollow noreferrer"><code>Varien_Data_Collection</code></a> which implements <code>IteratorAggregate</code>; this is why you are able to work with the collection object in an array-like fashion (i.e. <code>foreach</code>), but not have it work for the <code>for</code> loop. For one thing, dThere is no direct key-based access to the elements inside the object (<code>_items</code> array members) - unfortunate, given that the key for the <code>_items</code> array is based on the row ID. Bottom line: working with collection items in a <code>for</code> loop is not very easy, not when compared to the ease of working with collection items via <code>IteratorAggregate</code> and all of its related goodies. Here's an example of both. If you have an overarching need to work with the collection's items directly then you can use <code>$collection->getItems()</code>, but again realize that the <code>_items</code> array keys may not be sequential as they are based on the data. Also, note that you need to add the <code>name</code> attribute value to collections stored using Magento's EAV pattern: <pre><code><?php header('Content-Type: text/plain'); include('app/Mage.php'); Mage::app(); $collection = Mage::getResourceModel('catalog/product_collection'); $collection->addAttributeToSelect('name'); //for loop - not as much fun for ($j=0;$j<count($collection);$j++) { //count() triggers $collection->load() $items = $collection->getItems(); $item = current($items); echo sprintf( "%d:\t%s\t%s\n", $k, $item->getSku(), $item->getName() ); next($items); //advance pointer } //foreach - a bit better foreach ($collection as $k => $product) { echo sprintf( "%d:\t%s\t%s\n", $k, $product->getSku(), $product->getName() ); } </code></pre> And just in case you are wondering: <a href="https://stackoverflow.com/questions/3430194/performance-of-for-vs-foreach-in-php">Performance of FOR vs FOREACH in PHP</a>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow to use a for loop on a collection pulled from Magento
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USCommunity
UserOwnerUserId
1. USbenmarks
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow to use a for loop on a collection pulled from Magento
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.