Member profile pictures/thumbnails - need advice on how best to store retrieve

[conjurer]

I am working on a member association page (aprox 300 members) and they want to be able to upload their personal photo.

I have the member demographics stored in a MySQL database.

I am trying to figure out the best way to set it up so that someone can upload their photo. My main questions are:

1. Where to store uploaded images (Do I need to store them in the database or just organize them in a separate directory folder and link to them by url)

2. Where and how to set a limit on the file size of the image being uploaded?

3. How to create a thumbnail from the uploaded image?

4. Any other issues I should think about if we are storing images.

This is a small group that I would not expect to expand beyond 400 members.

Thanks for any ideas and advice you can share.

[rsmith]

conjurer;10969436 wrote:

I am working on a member association page (aprox 300 members) and they want to be able to upload their personal photo.

I have the member demographics stored in a MySQL database.

I am trying to figure out the best way to set it up so that someone can upload their photo. My main questions are:

1. Where to store uploaded images (Do I need to store them in the database or just organize them in a separate directory folder and link to them by url)

2. Where and how to set a limit on the file size of the image being uploaded?

3. How to create a thumbnail from the uploaded image?

4. Any other issues I should think about if we are storing images.

This is a small group that I would not expect to expand beyond 400 members.

Thanks for any ideas and advice you can share.

1. Upload the image information to the db but store the image in a directory, then reference it by url.

2. You do this within PHP's File Upload configuration or you can do things like getimagesize() in your upload script and do an if() statement to check it against your size limit which would then be set in a variable.

3. Imagemagick!

4. When I do images for smaller scale sites I setup a table similar to this:

+----------+
|  IMAGES  |
+----------+
ID
PATH_FULL
PATH_THUMB