I have a web based application built using PHP and MySQL, however we also support Apache or MS SQL if required by a client. One section of our software deals with document control, so if a user needs to upload a document to a particular section of our software they can do so via document control, which manages security of documents and also version control.
However this is where the problem lies. For example what if a user browses to the following path:
Not a problem if we were simply returning a URL to the browser, but we need to use the server to grab this file, check the user has permissions for it and then return it as a download, but not ever let them know the link to it as obviously it may be sensitive. So if the server opens the file X:\Documents\document.doc it would be looking locally on the server where the software is installed.
Now obviously a way round this would be to treat the link differently by either specifying the server name or the server's IP address so:
This is where we wondering if Share Point could be integrated to help us with building this link.
Any ideas? Maximum points available due to very tight schedule.