How to show art from category in two columns ?
5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 12, 2010 (RSS)
By esteban - May 10, 2010
I would like to show this in two column and show name of category.
<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
require_once "/home/trener_osobisty/trener_osobisty/cmsAdmin/lib/viewer_functions.php";
list($artykulyRecords, $artykulyMetaData) = getRecords(array(
'tableName' => 'artykuly',
'limit' => '4',
'where' => 'on_index',
));
?>
-----------------------------------
This code show my 4 article, and I need to show this 4 article i two column and add a category name from which an article comes in this place: <!-- Here I need put Category name -->
<table width="233" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="233">
<!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
<?php foreach ($artykulyRecords as $record): ?>
<!-- STEP 2a: Display Uploads for field 'zdjecie_glowne' -->
<?php foreach ($record['zdjecie_glowne'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<a href="<?php echo $record['_link'] ?>">
<img src="<?php echo $upload['thumbUrlPath2'] ?>" alt="<?php echo $record['title'] ?>" width="<?php echo $upload['thumbWidth2'] ?>" height="<?php echo $upload['thumbHeight2'] ?>" border="0" align="left" class="foto-ramka" /></a>
<?php endif ?>
<?php endforeach ?><br />
</td>
</tr>
<tr>
<td><a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a><br/>
Zajawka: <?php echo $record['zajawka'] ?><br/>
<!-- Here I need put Category name -->
<p class="dot_hor"> </p>
<?php endforeach ?>
<?php if (!$artykulyRecords): ?>
No records were found!<br/><br/>
<?php endif ?>
<!-- /STEP2: Display Records --></td>
</tr>
</table>
-------------------------------------
For category:
<?php
require_once "/home/trener_osobisty/trener_osobisty/cmsAdmin/lib/viewer_functions.php";
list($main_menuRecords, $main_menuMetaData) = getRecords(array(
'tableName' => 'main_menu',
));
?>
Every article has a category = "category_num" but every category_num has a name = "name" and I need put this name.
----------------
This is this website: http://goo.gl/QTno
Please help Interactivetools.
<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
require_once "/home/trener_osobisty/trener_osobisty/cmsAdmin/lib/viewer_functions.php";
list($artykulyRecords, $artykulyMetaData) = getRecords(array(
'tableName' => 'artykuly',
'limit' => '4',
'where' => 'on_index',
));
?>
-----------------------------------
This code show my 4 article, and I need to show this 4 article i two column and add a category name from which an article comes in this place: <!-- Here I need put Category name -->
<table width="233" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="233">
<!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
<?php foreach ($artykulyRecords as $record): ?>
<!-- STEP 2a: Display Uploads for field 'zdjecie_glowne' -->
<?php foreach ($record['zdjecie_glowne'] as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<a href="<?php echo $record['_link'] ?>">
<img src="<?php echo $upload['thumbUrlPath2'] ?>" alt="<?php echo $record['title'] ?>" width="<?php echo $upload['thumbWidth2'] ?>" height="<?php echo $upload['thumbHeight2'] ?>" border="0" align="left" class="foto-ramka" /></a>
<?php endif ?>
<?php endforeach ?><br />
</td>
</tr>
<tr>
<td><a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a><br/>
Zajawka: <?php echo $record['zajawka'] ?><br/>
<!-- Here I need put Category name -->
<p class="dot_hor"> </p>
<?php endforeach ?>
<?php if (!$artykulyRecords): ?>
No records were found!<br/><br/>
<?php endif ?>
<!-- /STEP2: Display Records --></td>
</tr>
</table>
-------------------------------------
For category:
<?php
require_once "/home/trener_osobisty/trener_osobisty/cmsAdmin/lib/viewer_functions.php";
list($main_menuRecords, $main_menuMetaData) = getRecords(array(
'tableName' => 'main_menu',
));
?>
Every article has a category = "category_num" but every category_num has a name = "name" and I need put this name.
----------------
This is this website: http://goo.gl/QTno
Please help Interactivetools.
Re: [esteban] How to show art from category in two columns ?
By gkornbluth - May 11, 2010 - edited: May 11, 2010
Hi esteban,
Limiting the amount of columns is not too difficult. Here's an excerpt from my CMSB Cookbook http://www.thecmesbcookbook.com that describes an approach:
LIMITING THE AMOUNT OF COLUMNS IN A SINGLE ROW IMAGE DISPLAY
Here’s a suggestion from Dave:
The CSS way is to have each image in a div that has something like: style="float: left; width: 200px". This will make them flow from left to right and wrap when they run out of space (you can put them inside a bigger fixed width container).
Or with a table you can have one table cell per image and insert a closing and opening TR every X images. Here's a code snippet that does that:
Which is just a way of saying "Every 2 images insert "</tr><tr>"".
Here’s a single row example using the thumbnail2 image as a link to a detail page, separate Title and Subtitle fields, a hidden border for IE and a fixed height for the image cell so that everything lines up nicely.
Similarly, if you’re not using images this code will output a </tr><tr> after every 2 <td>...your content...</td> lines:
Use your own variable names instead of $yourrecord, but the line in red can stay the same.
Hope that gets you going.
CATEGORIES
There are a number of ways to show a category. Where does the category name come from? A list field? Some other way?
Best,
Jerry Kornbluth
Limiting the amount of columns is not too difficult. Here's an excerpt from my CMSB Cookbook http://www.thecmesbcookbook.com that describes an approach:
LIMITING THE AMOUNT OF COLUMNS IN A SINGLE ROW IMAGE DISPLAY
Here’s a suggestion from Dave:
The CSS way is to have each image in a div that has something like: style="float: left; width: 200px". This will make them flow from left to right and wrap when they run out of space (you can put them inside a bigger fixed width container).
Or with a table you can have one table cell per image and insert a closing and opening TR every X images. Here's a code snippet that does that:
<?php $maxCols=2; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?>Which is just a way of saying "Every 2 images insert "</tr><tr>"".
Here’s a single row example using the thumbnail2 image as a link to a detail page, separate Title and Subtitle fields, a hidden border for IE and a fixed height for the image cell so that everything lines up nicely.
<table width="100%" border="0" cellpadding="5">
<tr>
<?php foreach ($your_sectionRecords as $record): ?><?php foreach ($record['image'] as $upload): ?>
<td align=”center” height="350" valign="bottom">
<a href="<?php echo $record['_link'] ?>"><img src="<?php echo $upload['thumbUrlPath2'] ?>" width="<?php echo $upload['thumbWidth2'] ?>" height="<?php echo $upload['thumbHeight2'] ?>" alt="" style="border:hidden" /><br /><div align="center" class="medium-title"><?php echo $record['title'] ?></div>
<div align="center" class="medium-text"><?php echo $record['sub_title'] ?></div></a>
</td>
<?php $maxCols=2; if (@++$count % $maxCols == 0): ?></tr><tr><?php endif; ?>
<?php endforeach ?><?php endforeach ?>
</tr>
</table>Similarly, if you’re not using images this code will output a </tr><tr> after every 2 <td>...your content...</td> lines:
<table border="1">
<tr>
<?PHP foreach ($yourrecords as $record): ?>
<td>
<?PHP echo $record['your_content'] ?><br/>
</td>
<?PHP $maxCols=2; if (@++$count % $maxCols == 0): ?></tr><tr><?PHP endif; ?>
<?PHP endforeach; ?>
</tr>
</table>Use your own variable names instead of $yourrecord, but the line in red can stay the same.
Hope that gets you going.
CATEGORIES
There are a number of ways to show a category. Where does the category name come from? A list field? Some other way?
Best,
Jerry Kornbluth
The first CMS Builder reference book is now available on-line!
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Re: [gkornbluth] How to show art from category in two columns ?
By esteban - May 11, 2010
Sorry I don't understand, I do not know PHP and I just can not pass on it in your example. You Give me a solution for images and content separately and I have this one and there are twice as <? Php endforeach?>. What to do in this situation?
Re: [esteban] How to show art from category in two columns ?
By esteban - May 11, 2010 - edited: May 11, 2010
Ok I figured out. Working :-) Your post was helpfull. Thanks.
Re: [esteban] How to show art from category in two columns ?
By gkornbluth - May 12, 2010
Good for you
The first CMS Builder reference book is now available on-line!
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php
Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php