/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
- <?php
- include('../../../config.php');
- include('../../../mysql.php');
- $link = mysql_connect($mysqlhost, $mysqluser, $mysqlpass) or die("Could not connect to server");
- mysql_select_db($mysqldb) or die("Could not select database");
- $sql = "SELECT screenshot_file FROM screenshots WHERE id='" . $_POST['id'] . "'";
- $fetch = mysql_query($sql) or die(mysql_error());
- while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
- $screenshot_file = $row['screenshot_file'];
- // delete image file
- unlink($web_root . "/modules/screenshots/uploads/" . $screenshot_file);
- // delete image from database
- $delete_sql = "DELETE FROM screenshots WHERE id='" . $_POST['id'] . "'";
- $delete_query = mysql_query($delete_sql) or die(mysql_error());
- // also delete any tags
- $delete_tags_sql = "DELETE FROM screenshots_pos WHERE screenshot_id='" . $_POST['id'] . "'";
- $delete_tags_query = mysql_query($delete_tags_sql) or die(mysql_error());
- // return id
- echo $_POST['id'];
- }
- ?>