Photos / database / administration - where to start?

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
alpinestar22
Forum Newbie
Posts: 1
Joined: Wed Mar 10, 2010 5:49 pm

Photos / database / administration - where to start?

Post by alpinestar22 »

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!
John.Mike
Forum Newbie
Posts: 18
Joined: Fri Sep 04, 2009 11:43 pm
Location: Canton.China

Re: Photos / database / administration - where to start?

Post by John.Mike »

DO THESE PARTS AT THE SAME TIME,THEN GET THEM TOGETHER.I will do it like that.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Re: Photos / database / administration - where to start?

Post by John Cartwright »

John.Mike wrote:DO THESE PARTS AT THE SAME TIME,THEN GET THEM TOGETHER.I will do it like that.
If you don't have anything constructive to say, then please keep it to yourself.
Post Reply