|
 |
Due to the volume of spam happening on our forums, posting is now restricted to verified members only. If you're not verified, drop us a note with your username.
|
|
Home > FlexCMS Support Forum > User Help > Code Snippets > Automagically Generate Clickable File Links
FlexCMS Support Forum
Automagically Generate Clickable File Links
Started May 24, 2010 @ 12:14am by Wolf
|
Post Message |
Wolf
Posts: 65 |
|
|
| Automagically Generate Clickable File Links | May 24, 2010 @ 12:14am | I have a client who wanted to upload newsletters in PDF format so that clients could then click on a link to download them.
The catch is we didn't want the client to have to maintain hard coded links to the newsletters, so I came up with this little ditty...
Using File Manager, I created a directory structure called "/newsletters/pdf".
Then set permissions on the directory so that only the newsletter guy could upload to it via the new File Manager.
I created the following code snippet, then included the snippet in a block:
Quote
$query = "SELECT `Location` , `Filename` FROM `core-Files` WHERE `Location` = \"/newsletters/pdf/\" ORDER BY Filename asc";
$result = mysql_query($query) or die (mysql_error());
print '# Newsletters: ' . number_format(mysql_num_rows($result),0) . '<br><br>';
while ($row = mysql_fetch_array($result))
{ print '<a href="'.$BaseURL.$row['Location'].$row['Filename'].'" target="_blank">'.$row['Filename'].'</a><br>';
}
|
|
Now all the newsletter editor has to do is upload/delete/rename files as he chooses and the links are generated dynamically.
Cheers,
Wolf
PS - Be careful about naming your files... it's probably NOT a good idea to include spaces or special characters. |
|
|
|
Last Edit: May 24, 2010 @ 2:56pm by Wolf | |
|
|
|
| |
DCSun
Administrator
Posts: 625 |
|
|
| May 24, 2010 @ 10:58am | Hey Wolf,
Neat script, thanks for sharing. One small change I would suggest is adding $BaseURL to the beginning of your link URL in the HREF argument of the link (ie: $BaseURL.$row['Location'].$row['Filename']). That way you'll always get the absolute link you intended, rather than relying on the browser to come up with the correct relative one (there may be issues with some browsers on deeper pages on the site because it may mistake "/pages/something" as folders and add your download link onto the end of that).
Dave
FlexCMS v3.2 Has Been Released! |
|
|
|
|
|
|
| |
Wolf
Posts: 65 |
|
|
| Thanks and a question... | May 24, 2010 @ 12:04pm | Dave,
Thanks!
I'd assumed that since File Manager created the info it would contain the necessary full path info. Is that not always the case?
Is this what you suggest?
Quote
$query = "SELECT `Location` , `Filename` FROM `core-Files` WHERE `Location` = \"/newsletters/pdf/\" ORDER BY Filename asc";
$result = mysql_query($query) or die (mysql_error());
print '# Newsletters: ' . number_format(mysql_num_rows($result),0) . '<br><br>';
while ($row = mysql_fetch_array($result))
{ print '<a href="'.$BaseURL.$row['Location'].$row['Filename'].'" target="_blank">'.$row['Filename'].'</a><br>';
}
|
|
Thanks!
Wolf |
|
|
|
Last Edit: May 24, 2010 @ 2:54pm by Wolf | |
|
|
|
| |
DCSun
Administrator
Posts: 625 |
|
|
| May 24, 2010 @ 1:00pm | Need another period before the $ on BaseURL but yes that's where I meant to put it. The location in the files table is a relative path, such as /newsletters/, so depending on the URL you're at and how the browser interprets it you may end up with bad links. Adding the BaseURL variable (contains something like http://www.flexcms.com or http://somesite.com/installationfolder) in there will give you an absolute URL that will always be correct no matter what.
Dave
FlexCMS v3.2 Has Been Released! |
|
|
|
|
|
|
| |
Wolf
Posts: 65 |
|
|
| ::-) | May 24, 2010 @ 2:55pm | Cool beans! Thanks Dave.
I corrected both examples to include your suggestion. 
Wolf |
|
|
|
Last Edit: May 24, 2010 @ 2:56pm by Wolf | |
|
|
|
|
|
|
| MEMBERS
|
|
|
