Re: storing images in a table or in a directory
| From: | Chris Payne | 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
>
>