One uploaded file - several different references?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Before I start and try to solve my problem, I wonder if anyone can
help me with my challenge:
I want to make a system to upload files (mostly word and pdf-files),
store them in the file system and store metadata in a mysql db.

I will sort all files into one of five main categorys. In addition, I
will associate each file in a sub-category for each main category. I
know I will get instances where the same file name (the uploaded file)
will exist in all main categorys and also in the associated sub-
categorys, but the file content will be and shall be different in all

Will this be an impossible task to cope with?

Re: One uploaded file - several different references?


You could key the files by an auto increment ID to avoid any name
collisions. When saving the file on disk, you could incorporate the ID
into the path, or just create a random string.

Quoted text here. Click to load it

Site Timeline