Re: storing images in a table or in a directory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux