Databases
StackOverflow2013
Postsdbo
POSolving Foreach Rows
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSolving Foreach Rows
    primarykey
    data
    text
    <p>I am looking for help in how to have my foreach loop data display in table rows. The code below echos the data in a single row that runs off the screen. I would like to have three items per row. I currently have about 80 items in total for display and more are added every month so bonus points for anyone who can also help with pagination after 4 rows of 3 items are displayed... FYI, I've tried variations on answers for similar questions asked but I can't find a solution that works for me or I am implementing it wrong. Any help would be greatly appreciated. Thank you!</p> <pre><code>&lt;table&gt; &lt;tr&gt; &lt;?php foreach (get_terms('term') as $cat) : ?&gt; &lt;td&gt; &lt;a href="&lt;?php echo get_term_link($cat-&gt;slug, 'term'); ?&gt;"&gt;&lt;strong&gt;&lt;?php echo $cat-&gt;name; ?&gt;&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="&lt;?php echo get_term_link($cat-&gt;slug, 'term'); ?&gt;"&gt;&lt;?php echo $cat-&gt;description; ?&gt;&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="&lt;?php echo get_term_link($cat-&gt;slug, 'term'); ?&gt;"&gt;&lt;img src="&lt;?php echo taxonomy_image_url($cat-&gt;term_id); ?&gt;" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;?php endforeach; ?&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p><strong>This is the output produced by Tecbrat's code below:</strong></p> <pre><code>&lt;table&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/august-2013/"&gt;&lt;strong&gt;August 2013&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/august-2013/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/august-2013/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/february-2012/"&gt;&lt;strong&gt;February 2012&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/february-2012/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/february-2012/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/february-2013/"&gt;&lt;strong&gt;February 2013&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/february-2013/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/february-2013/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/january-2012/"&gt;&lt;strong&gt;January 2012&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/january-2012/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/january-2012/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/january-2013/"&gt;&lt;strong&gt;January 2013&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/january-2013/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/january-2013/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/november-2013/"&gt;&lt;strong&gt;November 2013&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/november-2013/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/november-2013/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/october-2013/"&gt;&lt;strong&gt;October 2013&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/october-2013/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/october-2013/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt; &lt;a href="http://comm.org/mag/september-2013/"&gt;&lt;strong&gt;September 2013&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="http://comm.org/mag/september-2013/"&gt;Issue 101, Vol. 1&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="http://comm.org/mag/september-2013/"&gt;&lt;img src="http://comm.org/wp-content/uploads/FC-OCT.jpg" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p><strong>I was able to make it work using this markup:</strong></p> <pre><code>&lt;table&gt; &lt;tr&gt; &lt;?php $col = 0; ?&gt; &lt;?php foreach (get_terms('term') as $cat) : ?&gt; &lt;?php if ($col &gt; 0 &amp;&amp; $col % 3 == 0): ?&gt; &lt;/tr&gt; &lt;tr&gt; &lt;?php endif; ?&gt; &lt;?php $col++; ?&gt; &lt;td&gt; &lt;a href="&lt;?php echo get_term_link($cat-&gt;slug, 'term'); ?&gt;"&gt;&lt;strong&gt;&lt;?php echo $cat-&gt;name; ?&gt;&lt;/strong&gt;&lt;/a&gt;&lt;br&gt; &lt;em&gt;&lt;a href="&lt;?php echo get_term_link($cat-&gt;slug, 'term'); ?&gt;"&gt;&lt;?php echo $cat-&gt;description; ?&gt;&lt;/a&gt;&lt;/em&gt;&lt;br&gt; &lt;a href="&lt;?php echo get_term_link($cat-&gt;slug, 'term'); ?&gt;"&gt;&lt;img src="&lt;?php echo z_taxonomy_image_url($cat-&gt;term_id); ?&gt;" /&gt;&lt;/a&gt; &lt;/td&gt; &lt;?php endforeach; ?&gt; &lt;/tr&gt; &lt;/table&gt; </code></pre> <p>Now I need to find out how to add pagination for every 11 items, so that numbers 12-22 are on page 2, and so on. </p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser2591811
    1. USuser2591811
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COon a UX sidenote: users don't cope well with large tabular data on pages. If this is a webpage, consider finding a different way to do data visualisation. If this is a data resource, then having the data run off the screen should be fine, people who need it know how to use a scrollbar (just ensure your labels are always visible. There are many JS libraries for effective that, just use one of those)
      singulars
      1. POSolving Foreach Rows
      1. USMike 'Pomax' Kamermans
    2. COThank you for your note. It's for a an online magazine archive so I am trying to display the magazine issues -- preferably four rows of three issues (12 on a page = 1 yr) before paginating to the next page. I'm not sure how else to call the data dynamically but am open to suggestions that are better than the solution I'm trying.
      singulars
      1. POSolving Foreach Rows
      1. USuser2591811
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload