StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPut array of elements under correct header with foreach
primarykey
Id
10653643
data
AcceptedAnswerId
10653733
AnswerCount
3
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2012-05-18T13:33:54.340
FavoriteCount
0
LastActivityDate
2012-05-19T09:47:44.967
LastEditDate
2012-05-19T09:47:44.967
LastEditorUserId
1055690
OwnerUserId
1055690
ParentId
0
PostTypeId
1
Score
0
ViewCount
433
LastEditorDisplayName
text
Body
<p>I have an array of vendors called:</p> <pre><code>$listOfVendors </code></pre> <p>I loop through this array with a foreach in my view.</p> <pre><code><?php foreach($listOfVendors as $vendor):?> <p class="vendor"> <span class="vendor-title"><?php echo $vendor->name ?>(<?php echo $vendor->country ?>)</span>, <?php echo $vendor->goods ?>, <a href="<?php echo $vendor->site_adres ?>" class="vendor-link"><?php echo $vendor->site_adres ?></a> </p> <?php endforeach ?> </code></pre> <p>Each vendor object has the following properties:</p> <p><strong>vendors_Id</strong>, <strong>name</strong>, <strong>country</strong>, <strong>goods</strong>, <strong>site_address</strong>, <strong>activities_Id</strong>. The last one, activities_Id, is a FK to the table activities which has, for the time being, two types of activities: Dealers and Artists.</p> <p>Now I want to add a header once for every type of vendor. So want to get something like:</p> <p><strong>Artist</strong></p> <p>Vendor1(DE), Eigen posters e.a. merchandise, <a href="http://www.linktosite.com" rel="nofollow noreferrer">http://www.linktosite.com</a></p> <p><strong>Dealer</strong></p> <p>Vendor2(BE), Toys, DVD's, books, <a href="http://www.anotherlink.be" rel="nofollow noreferrer">http://www.anotherlink.be</a></p> <p>Vendor3(FR), Merchandise, <a href="http://www.anotherlink2link.be" rel="nofollow noreferrer">http://www.anotherlink2link.be</a></p> <p>How do I do this? I just can't seem to get my head around this seemingly simple thing.</p> <h2>Edit for Solution</h2> <h3>Controller actvities -> function vendors</h3> <pre><code>//Get the vendor information and add the needed headers //Here I get all the vendors if($listOfVendors = $this->atsusacon_model->get_records()) { foreach($listOfVendors as $vendor) { $listOfVendorsByType[$vendor->activities_Id][] = $vendor; } $data['listOfVendorsByType'] = $listOfVendorsByType; var_dump($listOfVendorsByType); } </code></pre> <h3>View actvities/vendors</h3> <pre><code><section class="vendors-overview twelvecol clearBoth"> <?php foreach($listOfVendorsByType as $activity):?> <?php if ($activity[0]->activities_Id == 1) :?> <h3>Artists</h3> <?php else :?> <h3>Dealers</h3> <?php endif ?> <?php foreach($activity as $vendor):?> <p class="vendor"> <span class="vendor-title"><?php echo $vendor->name ?>(<?php echo $vendor->country ?>)</span>, <?php echo $vendor->goods ?>, <a href="<?php echo $vendor->site_address ?>" class="vendor-link"><?php echo $vendor->site_address ?></a> </p> <?php endforeach ?> <?php endforeach ?> </section> </code></pre> <p>I could make it more dynamic but for now, this is exactly how it should be.</p> <p>The var_dump of $listOfVendorsByType looks like this:</p> <p><img src="https://i.stack.imgur.com/tNZIp.png" alt="Var_dump($listOfVendorsByType)"></p>
Tags
<php><mysql><codeigniter><foreach>
Title
Put array of elements under correct header with foreach
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USreaper_unique
UserOwnerUserId
1. USreaper_unique
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
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.