/modules/snippets/ajax/delete_screenshot.php

https://bitbucket.org/websightdesigns/project-manager · PHP · 21 lines · 17 code · 0 blank · 4 comment · 1 complexity · 8b2e1a3d214447eda5a4b18ddb48fbe3 MD5 · raw file

  1. <?php
  2. include('../../../config.php');
  3. include('../../../mysql.php');
  4. $link = mysql_connect($mysqlhost, $mysqluser, $mysqlpass) or die("Could not connect to server");
  5. mysql_select_db($mysqldb) or die("Could not select database");
  6. $sql = "SELECT screenshot_file FROM screenshots WHERE id='" . $_POST['id'] . "'";
  7. $fetch = mysql_query($sql) or die(mysql_error());
  8. while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
  9. $screenshot_file = $row['screenshot_file'];
  10. // delete image file
  11. unlink($web_root . "/modules/screenshots/uploads/" . $screenshot_file);
  12. // delete image from database
  13. $delete_sql = "DELETE FROM screenshots WHERE id='" . $_POST['id'] . "'";
  14. $delete_query = mysql_query($delete_sql) or die(mysql_error());
  15. // also delete any tags
  16. $delete_tags_sql = "DELETE FROM screenshots_pos WHERE screenshot_id='" . $_POST['id'] . "'";
  17. $delete_tags_query = mysql_query($delete_tags_sql) or die(mysql_error());
  18. // return id
  19. echo $_POST['id'];
  20. }
  21. ?>