User Gallery with Queue for Approval

[NappyHead]

I have a simple gallery built that allows anonymous users to upload images.

I'm trying to set it up to send all uploaded images to a queue to await approval from the admin.

I created a table in my database called imgApp and it defaults to 0.

What I want:
When the admin clicks a checkbox, it sets the column to 1, and the photo will then be published.

if($row->imgApp == 1){

echo '<td align="left">Approved</td>';

}else{

echo '<td align="left">Not Approved</td>';
}

If you can point me to something for me to research to be able to develop this, I'd appreciate. I just don't know how to approach it.

Do I set it up to move the uploaded photos to a different directory (the approved photo directory) when the photo is changed from 0 to 1?

[Kudose]

You could use a form with radio or checkboxes and have the default selected value either 0 or 1, depending on your database column. Then when you submit the form, just update the column accordingly. When you poll your images, just be sure to include a WHERE clause to weed out the unapproved images.

i.e.

<input type="radio" name="approved" value="0"<?php if($row->approved == 0) echo ' selected="selected"'; ?> />
<input type="radio" name="approved" value="1"<?php if($row->approved == 1) echo ' selected="selected"'; ?> />
<input type="hidden" name="id" value="<?php echo $row->id; ?>" />
<input type="submit" name="submit" />

if(isset($_POST['submit'])){
  $status = abs($_POST['approved']);
  $id = abs($_POST['id']);
  $sql = "UPDATE `table` SET `approved` = $status WHERE `id` = $id";
  mysql_query($sql) or die(mysql_error());
}

$sql = mysql_query("SELECT `name` FROM `table` WHERE `approved` = 1");
while(($row = mysql_fetch_object($sql)) !== FALSE)
  echo $row->name;

That is just sample code obviously, but it should give you an idea.

[NappyHead]

Thanks,

This is great! I've got it working to only show approved images. Now, for the admin page.

I'm having a hard time setting up the checkbox in the form to Approve the photo. I have a checkbox to delete and it works fine.

I'm trying to add to the following code an Approve Image column with a checkbox that, when checked, will UPDATE gal_images SET imgApp=1.

//select all images from the database
$sql = mysql_query("SELECT * FROM gal_images");

$count=mysql_num_rows($sql);
$checkbox = $_POST['checkbox']; 
?>

<form name="form1" method="post" action=""> 
<table width="100%" border="0">
  <tr>
    <th align="left" scope="col">ID</th>
    <th align="left" scope="col">Image </th>
    <th align="left" scope="col">Delete</th>
	<th align="left" scope="col">Approval</th>
  </tr>
<?php 
//add data to an object
while($row = mysql_fetch_object($sql))
{
?>
  <tr>
    <td align="left"><?php echo $row->imageID;?></td>
    <td align="left"><?php echo $row->imageTitle ;?></td>
    <td align="left"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $row->imageID;?>"></td>
	<?php 
	if($row->imgApp == 1){
    echo '<td align="left">Approved</td>';
	}else{
    echo '<td align="left">Not Approved</td>';
	}
	?>
  </tr>

  <?
	// Check if delete button active, start this
	if (count($checkbox) > 0)
	{ 
		for($i=0;$i<$count;$i++){
		$del_id = $checkbox[$i];
		$sql = "DELETE FROM gal_images WHERE imageID='$del_id'";
		$result = mysql_query($sql);
	}

// If successful, refresh page.
if($result){
	echo "Image Deleted.";
	header('Location: ' . $_SERVER['HTTP_REFERER']);
	exit;

}
}
?>

<?php } ?>
	<tr>
	<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
	</tr>
</table>
</form>

[Kudose]

You'll want to check for a page submission then loop through the POSTed IDs to delete.

i.e.

if(isset($_POST['delete'])){
  // submit was pressed, delete the rows
  $ids = $_POST['checkbox'];
  foreach($ids as $key => $id){
    if(ctype_digit($id)){
      // delete the row based on $id
      $sql = sprintf("DELETE FROM `gal_images` WHERE `imageID` = %d", $id)
      if(!mysql_query($sql))
        echo 'MySQL Error: '.mysql_error();
    } else {
      // invalid ID, discard
      unset($ids[$key]);
    }
  }
}
// pull the records and show the form here