Review page help? (SQL+PHP)

JeffAh · September 11, 2011

Heya folks, I came here in hope someone could shed some light on the situation I'm in, it's probably looking me straight in the face and I cant see it..

So basically, I've got my page sorted, I'll theme it for my website later, but it echo's out entry's from a SQL database (images to be reviewed) then it has the name, id and accept and reject buttons.

Currently I have the page echoing perfectly, the reject button removes from SQL but does not delete the actual image (that's where I need help)

The accept button currently has no function as I've tried INSERT INTO but I cant get it working, so here's some code I hope someone knows what's missing

Page that echo's from SQL;

<?php
$dbHost = "xxxxxxx";

$dbUser = "xxxxxxx";

$dbPass = "xxxxxxx";

$dbName = "xxxxxxxx";

$db = mysql_connect($dbHost,$dbUser,$dbPass);

mysql_select_db($dbName,$db);

$image_name='fullsize'

?>

<?php $result = mysql_query("SELECT id, fullsize FROM tblimages");
$filename['fullsize'] 
?>

<html>
<table>
  <tr>
    <td>Image Uploads</td>
  </tr>
  <?php while($row = mysql_fetch_array($result)) :
  		$image = $row['fullsize']
   ?>
  <tr>
    <td><?php echo $row['id']; ?></td>
    <td><?php echo $row['fullsize']; ?></td>
<td><?php echo '<img src= "uploads/'.$row['fullsize'].'" width="180" height="180"/> '; ?> </td>


    <!-- and so on -->
    <td>
      <form action="delete.php" method="post">
        <input type="hidden" name="delete_id" value="<?php echo $row['id']; ?>" />
        <input type="submit" value="Reject" />
      </form>
  <form action="insert.php" method="post">
        <input type="hidden" name="insert_id" value="<?php echo $row['filename']; ?>" />
        <input type="submit" value="Accept" />
      </form>
    </td>
  </tr>
  <?php endwhile; ?>
</table>
</html>

The delete.php's code is;

<?php
if(isset($_POST['delete_id']) && !empty ($_POST['delete_id'])) {
  $delete_id = mysql_real_escape_string($_POST['delete_id']);
  mysql_query("DELETE FROM tblimages WHERE `id`=".$delete_id);
  header('Location: test.php');
}
?>

And my insert.php is currently faulty code, so but I used virtually the same as the delete.php but where 'delete_id' is I replaced with 'insert_id'

My database is laid out like this,

tblimages (this is where images that need to be reviewed are stored)

[id, fullsize] <- columns stored inside

images (this is where images that have been accepted should be moved to)

[filename] <-where images should be inserted to.

Hope someone can understand and help with this, if so, thank you very much ^_^

litebearer · September 11, 2011

For deleting the file look here...

http://www.w3schools.com/php/func_filesystem_unlink.asp

Sign In

Review page help? (SQL+PHP)

Recommended Posts

JeffAh

Link to comment

Share on other sites

litebearer

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information