Photos / database / administration - where to start?
Posted: Wed Mar 10, 2010 6:00 pm
Alright, first time posting here (actually, anywhere!) I'm fairly new to PHP & Web programming - so I apologize ahead of time for sounding retarded.
Currently, I'm working on a site in which users can submit a photo. While this initially doesn't sound terrible - there are some complications as I need to do several things before the photos are published to my site. Here is the process that I need implemented:
1. User submits a photo (is uploaded to an images directory & file path saved in db w/unique id) - I think.
2. My moderator/writer logs in to an administrative panel, checks for new images, adds some content, and then posts the article in its entirety to the site to be live.
3. That's pretty much it!
Maybe my thought process is a little screwed up, but initially I want to take some of the leg work out of posting an article for my moderators/writers. I hope this makes sense... maybe I'm missing a few steps.
In theory, my guess is that the images could be uploaded and their initial 'state' in the database would be "0"
The administrator panel would run a query only pulling submissions that have a value of "0"
Once content was added, or whatever else needed done, a check box would change the state to "1" and my site would then query only articles that have the value of "1"
Again, I have no knowledge of this, but I'm willing to give it a shot until it works - I'm just looking to make sure I have the right process.
Thanks!
Currently, I'm working on a site in which users can submit a photo. While this initially doesn't sound terrible - there are some complications as I need to do several things before the photos are published to my site. Here is the process that I need implemented:
1. User submits a photo (is uploaded to an images directory & file path saved in db w/unique id) - I think.
2. My moderator/writer logs in to an administrative panel, checks for new images, adds some content, and then posts the article in its entirety to the site to be live.
3. That's pretty much it!
Maybe my thought process is a little screwed up, but initially I want to take some of the leg work out of posting an article for my moderators/writers. I hope this makes sense... maybe I'm missing a few steps.
In theory, my guess is that the images could be uploaded and their initial 'state' in the database would be "0"
The administrator panel would run a query only pulling submissions that have a value of "0"
Once content was added, or whatever else needed done, a check box would change the state to "1" and my site would then query only articles that have the value of "1"
Again, I have no knowledge of this, but I'm willing to give it a shot until it works - I'm just looking to make sure I have the right process.
Thanks!