Retrieving files from pgsql objects via PHP4

[Anon]

I have been developing a php/postgresql based documentation database. In order to store documents I have used a HTML upload function that places the file in an pgsql object within the database.

I cannot find a method to present the available object as a click-to-download link on the web page (as the real files only exist in the database).

Does anyone know a method to neatly achieve this?

Thanks in advance
/Simon Inns

[Anon]

You could store the files in a directory instead of in the database and just store the file name in the database. Downloads would then just be anchors to the files on disk.

The other option would be to create your "download links" as 'get' formatted calls to a php script passing the name of the file:

<a href="http://www.mysite.com/dlscript.php?file=filename">file one</a>

The download script would then set the correct header() for the file type and use the PG_LOREADALL() function to send the object to the browser.

Hope this helps.

-- Rich --

[Anon]

You need to send mime headers first. If it is .html but you want them to download it, use a diff. mime header than text/html. It's not that hard...check some of the example stuff from the manual