My site is broken into three different categories (which are stored on 3 separate tables) and I am looking at creating a functionality to let a user upload photos. Ideally, I would like the following to happen:
- A user is viewing a single retail store on the site, for example and clicks "upload photos"
- The user is prompted with a box that allows them to upload multiple photos simultaneously. These photos need to be "tagged" or associated with this particular store so they can be displayed later (more on that in a bit)
- On upload, the files are renamed and sent to a directory specified in the upload script and their path(s) are saved in the database itself.
- The page refreshes and now the photos are there (along with any other user's photos submitted for that particular store). Note: this is why it's important to tag photos to a particular store, that way they can be retrieved when the store is viewed without displaying other store's photos.
Does anyone have some guidance on where to start with this or if there is a ready-made solution out there for this type of setup?