User Gallery with Queue for Approval

[nappyhead]

Hi, I created a simple user gallery that allows anybody to upload photos to it. I now want all uploaded photos sent to a queue to await for approval by me. When the 'approved' checkbox is clicked for a particular photo (or multiple photos), the photos are then published to the public gallery.

 

I need some advice on how to approach this. I'm not asking for a complete solution; I just need something to go by in my research and I'll work to figure it all out.

 

Thank you.

[Maq]

You should have a field in your database called something along the lines of, "approved".  The values should be either '0', waiting for approval, or '1', for approved.  That way, when you display the gallery you can include this condition in your query to only display the photos that have been approved.

 

As for listing the queued photos, you can do the opposite.  You can list all of the photos in the queue with a '0' for the "approved" column along with a corresponding checkbox.  When you submit this page it should iterate through all of the checked photos and update the database to have these photos approved (1).

 

Do you have any of this page setup yet?

[nappyhead]

Thanks Maq,

The admin section of my gallery only lists all photos in the gallery with a delete link next to each photo. Very simple right now.

 

I understand your concept and will take a shot at it.