Re: storing images in a table or in a directory

From: Date: Wed, 20 Aug 2003 21:33:44 +0000
Subject: Re: storing images in a table or in a directory
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-30005@lists.php.net to get a copy of this message
Hi there, Why not do both? Store the images themselves in a dir, but reference them from a table, so that way you can control them pretty much totally via PHP and MySQL. You could them write a system to create thumbnails from selected items in the database or delete certain images etc ..... easily, because you'd have the filename/location etc ..... stored in the DB. That's how I do it anyway, as then you don't have to query each image uploaded everytime, as it queries while you are uploading the image and stores stats such as location, size, type etc ... in the DB. Just a thought :-) Chris > Hi, > I have to manage a large amount of images uploaded by users on my site. > Using php/mysql I don't know if I should store the images in a directory > within the server or in a dedicated table. > What is the most suited method? > Thanks, best regards. > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >

« previous php.db (#30005) next »