Results 1 to 2 of 2
May 12, 2011, 22:20 #1
- Join Date
- Dec 2008
- 0 Post(s)
- 0 Thread(s)
Uploading image ... preventing filename conflicts...
I'm writing a PHP program that allows users to upload images. These images are stored in a directory and the URL is saved in a MySQL database.
If I name each image "image_1", "image_2", etc. and get the the number by counting how many images have already been stored in the database (or the directory or whatever), could cause errors if two users are uploading a file at the same time? I.e. cause two images to have the same name, which would mean one overwrites the other one?
A begins uploading image....
B begins uploading image....
A counts existing images, result: 0
A's image named as "image_1.jpg"
B coutns existing images, result: 0
B's image named as "image_1.jpg"
A's image saved as "image 1.jpg"
B's image saved as "image 1.jpg"
I just don't really know how these syncronisation issues are handled with MySQL and PHP ... any ideas? Thanks.
May 13, 2011, 03:13 #2
In MySQL: you could use an autoincremental id field (if you have an 'images' table).
In PHP: you could add the microtime to the imagename.Guido - Community Team Leader
The Votes Are In: The Winners of the 2013 Community Awards are...
Blog - Free Flash Slideshow Widget