Uploading of photos (database or regular file??)

[bradmurmz]

I have a website where users can upload photos... Right now when they upload a photo it just puts it into a directory called '/userpics/username.jpg'

One of the main reasons I want to transfer this into a database is so that whenever someone re-uploads a picture you don't have to click refresh twice for it to realize that it is a new picture.

Will storing the files in a database make it so that the pics reload everytime they are new?
If so... How would I go about displaying a photo from a database?

Im pretty sure I know how to upload the file into the database... you just would create the database data type as binary file and then place it into the mySQL command as normal with the $_FILE string.. correct me if Im wrong on this... Thanks!

[dinger]

Youre better off storing the URL of the pics in the database.

The only way of making the pics refresh automatically is to use JavaScript.

Sounds like maybe you might want to use Ajax here.

🙂

[bokehman]

dinger wrote:

you might want to use Ajax here.

Bagh! Humbug! Why! How! People seem to be recommending this technology for everything lately however impractical or inappropriate it may be.

[bradmurmz]

does anybody know if that is how other sites like MySpace and Facebook are done? (storing the pics on the server and using javascript to reload them...)