Having uploads show in list veiwer
4 posts by 2 authors in: Forums > CMS Builder
Last Post: March 19, 2008 (RSS)
I have searched and have not found the exact answer so I will try my own post. I want to have included any uploaded files (PDF ect) in a list viewer instead of going to the page viewer to see them.
I am thinking that I need another "foreach" tag in the upload part of the code but I am not sure if thats what it will take or not.
Could you point me in the right direction?
<?php
require_once "C:/Webspace/resadmin/mmoyers/efreewillmar.org/www/cmsAdmin/lib/viewer_functions.php";
$options = array(); // NOTE: see online documentation for more details on these options
$options['tableName'] = 'news_006'; // (REQUIRED) MySQL tablename to list record from. Example: 'article';
$options['titleField'] = 'title'; // (optional) MySQL fieldname used in viewer url for search engines. Example: 'title' would display: viewer.php/article_title_here-123
$options['viewerUrl'] = 'news_006Page.php'; // (optional) URL of viewer page. Example: '/articles/view.php';
$options['perPage'] = ''; // (optional) The number of records to display per page. Example: '5'; Defaults to 10.
$options['orderBy'] = 'orderPriority+0 DESC, date DESC, title'; // (optional) Fieldnames to sort by. Example: 'field1, field2 DESC, field3';
$options['pageNum'] = ''; // (optional) Page number of results to display. Example: '1'; Defaults to ?page=# value, or 1 if undefined
$options['where'] = ''; // (ADVANCED) Additional MySQL WHERE conditions. Example: 'fieldname = "value"'
$options['useSeoUrls'] = ''; // (ADVANCED) Set this to '1' for search engine friendly urls: view.php/123 instead of view.php?123 (not supported on all web servers)
list($listRows, $listDetails) = getListRows($options);
?>
<?php foreach ($listRows as $record): ?>
<?php echo $record['content'] ?><br/>
<?php endforeach ?>
<?php if ($listDetails['noRecordsFound']): ?>
<span class="style21">This Content Is <br/>
Currently Unavailable.<br/>
Please Check Back Soon.</span><br/>
<?php endif ?>
<?php if ($record): ?>
<?php foreach (getUploads($options['tableName'], 'upload', $record['num']) as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" /><br/>
<?php elseif ($upload['isImage']): ?>
<img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" /><br/>
</span>
<?php else: ?>
<span class="style6"><br/><a href="<?php echo $upload['urlPath'] ?>">Download <?php echo $upload['info1'] ?></a><br/>
<br/>
<?php endif ?>
<?php endforeach ?>
<?php endif ?>I am thinking that I need another "foreach" tag in the upload part of the code but I am not sure if thats what it will take or not.
Could you point me in the right direction?
Michael Moyers
Owner of Just Rite Design Inc. A growing network of professionals in web design, graphic design, flash development, programming, and audio & video productions.
"Due to budget constraints, the Light at the end of the tunnel will be temporarily out!"
Owner of Just Rite Design Inc. A growing network of professionals in web design, graphic design, flash development, programming, and audio & video productions.
"Due to budget constraints, the Light at the end of the tunnel will be temporarily out!"
Re: [justritedesign] Having uploads show in list veiwer
By Dave - February 15, 2008
You're on the right track. Just copy and paste the block of code that displays uploads (from the page viewer) and past it _inside_ the foreach loop that displays your record.
So for your viewer that would be like this:
Then it will display the uploads or attachments for each record.
Hope that helps!
So for your viewer that would be like this:
<?php foreach ($listRows as $record): ?>
<?php echo $record['content'] ?><br/>
Copy and paste upload display code here.
<?php endforeach ?>Then it will display the uploads or attachments for each record.
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com
Re: [Dave] Having uploads show in list veiwer
By Mohaukla - March 19, 2008
I have created the list page and it works fine but I am wondering if there is a way to have only one thumbnail show instead of all the uploaded images that were uploaded.
http://www.willmarairservice.com/listings.php
http://www.willmarairservice.com/listings.php
<?php if ($record): ?>
<?php foreach (getUploads($options['tableName'], 'uploads', $record['num']) as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" border="0" onmousedown="MM_swapImage('picture','','<?php echo $upload['urlPath'] ?>',1)" />
<!-- <span class="t12_white"><?php echo $upload['info1'] ?></span><br />-->
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>">Download <?php echo $upload['info1'] ?></a><br/>
<?php endif ?>
<?php endforeach ?>
Michael Moyers
Owner of Just Rite Design Inc. A growing network of professionals in web design, graphic design, flash development, programming, and audio & video productions.
"Due to budget constraints, the Light at the end of the tunnel will be temporarily out!"
Owner of Just Rite Design Inc. A growing network of professionals in web design, graphic design, flash development, programming, and audio & video productions.
"Due to budget constraints, the Light at the end of the tunnel will be temporarily out!"
Re: [justritedesign] Having uploads show in list veiwer
By Dave - March 19, 2008
You bet, PHP has a function for "breaking" out of a foreach loop called 'break'. Also, if you're never going to have anything but thumbnails you can remove the code that shows download links (keep it if you need it). Try this:
Basically, it won't see the break() code until the first time it shows a thumbnail, then it will "break" out of the loop and won't show anything else. You can use break() in any foreach loops when you want to show just one of something.
Hope that helps!
<?php foreach (getUploads($options['tableName'], 'uploads', $record['num']) as $upload): ?>
<?php if ($upload['hasThumbnail']): ?>
<img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" border="0" onmousedown="MM_swapImage('picture','','<?php echo $upload['urlPath'] ?>',1)" />
<!-- <span class="t12_white"><?php echo $upload['info1'] ?></span><br />-->
<?php break; ?>
<?php else: ?>
<a href="<?php echo $upload['urlPath'] ?>">Download <?php echo $upload['info1'] ?></a><br/>
<?php endif ?>
<?php endforeach ?>Basically, it won't see the break() code until the first time it shows a thumbnail, then it will "break" out of the loop and won't show anything else. You can use break() in any foreach loops when you want to show just one of something.
Hope that helps!
Dave Edis - Senior Developer
interactivetools.com
interactivetools.com