Linking to Uploads Across Multiple Documents?

<ul>
<?php foreach($news as $record): ?>
<li>
<b><?php echo $record['title'] ?></b><br />

<?php if ($record['attachment']): ?>
Attachments:
<ul>
<?php foreach(explode("\t", trim($record['attachment'])) as $attachmentNum): ?>
<?php $attachment = $attachmentsByNum[$attachmentNum] ?>
<?php foreach($attachment['uploads'] as $upload): ?>
<a href="<?php echo $upload['urlPath'] ?>"><?php echo $upload['filename'] ?></a><br/>
<?php endforeach ?>
<?php endforeach ?>
</ul>
<?php endif ?>
</li>
<?php endforeach ?>
</ul>

In fact if you just take out the code in red it works! You need to replace each instance of "$upload" with "$attachment" but it seems to do the trick.

Thanks chaps. Your help was very much appreciated.

:0)

Perch

PS. There is no ['filename'] for uploads only the pseudo [_filename] - but I'm not sure how to define it....

Hi Perch,

Oh, I thought you were going with my suggestion of having an "Attachments" section which would own the uploads. It seems you're directly selecting uploads. I'm glad you figured out how to fix things to work with your approach. :)

If you're getting uploads directly from the uploads table, there are a few fields which won't be defined for you. You can see which "pseudo-fields" are added (and how they're added) if you look in cmsAdmin/lib/upload_functions.php at the getUploadRecords() function.

Specificially, to generate the 'filename' pseudo-field, try this:

<?php echo pathinfo($attachment['filePath'], PATHINFO_BASENAME) ?>

Does that help? Please let me know if you have any questions.

Brilliant -

Thank you, both, very much for this.

Just one last question on this: Currently, in the section editor, I'm using a standard list arrangement to pull the uploads together, using num for values and urlPath for the label.

Would it be possible to construct an advanced MySQL query using PATHINFO_BASENAME? This should result in a list of filenames - not url paths - which would be far easier to read.

:0)

Perch