#1372 clickable links to open pdf files from fields

[Phil Marsh]

I wish there was a way I could set up a fields such that I could include column(s) with clickable links that would open pdf or other files (such as open office files) from the browsing view of the database table. I would like to be able to include working hyperlinks that would open application files similar as the way such links work from say calc. This functionality would be similar as that for clickable image links but would allow me to view pdf files.

[J.M. Rütter]

Are you planning to store the office files within the database as BLOBs, or are you storing URLs to the actual files in your database?

[Phil Marsh]

mynetx, I'd like to store URLs to actual files on my hard drive if possible,
Thanks

[Marc Delisle]

URLs to local files use the "file://" protocol, and browsers are supporting less and less this protocol, due to security issues.

[Phil Marsh]

Hi Marc,
I did find a way to make clickable links in phpmyadmin.
I give the method for Firefox 19.0 running on Ubuntu 10.04.
The following assumes you're using phpmyadmin locally (localhost or something like that) and that you have phpmyadmin and MySQL properly configured and running.

1. Get the LocalLink Add-On for Firefox. It's currently at:
   https://addons.mozilla.org/en-us/firefox/addon/locallink/

The LocalLink add-on is necessary to allow Firefox to access this clickable link if it's on your hard drive or else Firefox reports a security error

1. Add or modify the field you want the clickable link in as follows:
   Field: field's name
   Type VARCHAR
   Length/Values (greater than or equal to the number of characters in the field's name.

2. set the MIME type to text/plain
   4 set the Browser transformation to text/plain: link
   5 set the Transformation options to 'file:' (at a minimum to get the link from your hard drive) or 'file:xxxxx' to add a directory that your files are in.

3. Finally, and this isn't obvious, You MUST RIGHT click on your phpmyadmin link and select Open Link in Local Context then select one of the three options shown in the resulting menu. If you just left button click on the phpmyadmin link - nothing will happen.
   Good luck,
   Phil

[Marc Delisle]

Phil,
therefore, we can close this feature request?