i know this is a bit down the chain, but i'm trying to keep the message strings in tact.... but can't you set up your directory just like you set up your mysql Grants. I have a directory that the web user owns, who is in its own group. so i set the permisssions once, and its done. Also i don't store the folder structure, i have a variable named for that folder structure then if the folders move or you need to move your webservers, the path will dynamically update, regardless of location. just some thoughts, this is a topic that intrigues me, jeff "Bayu Susiloadhy" To: php-db@lists.php.net <bayu@bit.web. cc: id> Subject: Re: blob 01/08/2003 03:40 AM it's very useful to store images in the db then in the other page show the image by selecting it then print it out to the page with "Content-type: image" (jpeg/gif/etc) header; But, i didn't find how to show pdf binary file so that the browser can directly call acrobat reader to show it, i tried to use content-type : application/pdf but it failed! i think maybe in the pdf cases, browser called acrobat reader because of its extension (pdf),not because the header is it true? could someone help me? Luke Woollard writes: > I agree with Dave. I wrote an application to allow a client to upload/manage > images and categorise them into diff. parts of their website. > > Images were stored as normal image files after upload and a pointer made to > them from the appropriate database record (which had additional image info > e.g. description) > > Since I now have to move this website to a new server -> transferring all > these files was a bit annoying. Storing them as binary data in mysql would > have been easier to manage... > > > > > > > -----Original Message----- > From: David Smith [mailto:DavidSmith@byu.net] > Sent: Wednesday, 8 January 2003 10:19 AM > To: php-db@lists.php.net > Subject: Re: Re: blob > > > On Tue, 2003-01-07 at 15:52, Jeffrey_N_Dyke@Keane.com wrote: >> >> I agree with this method. i have not yet seen an advantage of storing >> blobs in a database. Is there one? i'm sure those on this list would > have >> an opinion if there was one. personally, i like storing all this stuff on >> the file system. > > There is one advantage. You must either chown the upload directory to > the user that your web-server runs as, or chmod it to be world-writable. > When creating a web-application that you plan to distribute (like > Slashcode), you can't assume that your users will have that privilege. > So, storing it in MySQL is a great option. > > --Dave > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > &$BS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php