I want to allow users to upload photos on my project but i am confused if i should store the name of the location(path) and name of the uploaded photo on a database then when it is requested i fetch the photo from the location a include it or if i should just give uploaded photos a similar name like index.jpg or photo.jpg then when it is requested i just include the profile path + photo.jpg, for example ,
<?php $username = //any user name?>
<img src="examplewebsite.com/<?php echo $username ?>/photo.jpg " >..
Please those who have handled projects that allows user to upload and access photos should help me with a solution..

The way I would do this is:
When saving the uploaded photo, concatenate a random string(eg timestamp) to the photo name to avoid overwriting a previously uploaded photo with the same name and then move photo to a preferred directory (eg uploads) on the file system and finally if the move successful save the photo name into the database.

I would have said you should save the path+photo name into the database but situation might arise when you may want to change the directory you upload photos along the way. And this will mean you will have to start replacing in your database too.

Hope it makes sense.

maekhel:
The way I would do this is:
When saving the uploaded photo, concatenate a random string(eg timestamp) to the photo name to avoid overwriting a previously uploaded photo with the same name and then move photo to a preferred directory (eg uploads) on the file system and finally if the move successful save the photo name into the database.

I would have said you should save the path+photo name into the database but situation might arise when you may want to change the directory you upload photos along the way. And this will mean you will have to start replacing in your database too.

Hope it makes sense.

Thanks Alot..