Jump to content

Maintaining hyperlinks when storing documents in Mysql blobs


midgley

Recommended Posts

Hello,

 

I've been tasked with creating a secure CMS and have up until now had little trouble, however i seem to have hit a brick wall. The problem is that many of the documents have embedded hyperlinks to other documents held on the system and I’m really not sure how to maintain the links.

 

The only workaround I can think of is to somehow redirect 404s to a script that takes the URL and wildcards it against the name of documents in the database but this is obviously a troublesome solution.

 

Anybody got any better ideas, or can point me in the right direction?

 

Thanks in anticipation.

 

Andy

 

Link to comment
Share on other sites

  • 2 weeks later...

 

so you have a link inside content to another url. the content is manged through an administration interface, assumed. what is it that you are looking to maintain in the content of the document?

 

You mention links, however what about them do you need to maintain and why? do you need to update them when a document is no longer active or it's been deleted? do you need to change attributes in the href based upon some other logical sequence?

 

w/o knowing specific needs you could...

- have a script in the admin tool that can be ran by an admin user to clean up existing content. which then grabs the content, parses out the links from the text and makes changes as determined by your business logic.

- use javascript after the document is rendered to modify links that need to be modified

 

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.