/*
* ----------------------------------------------------------------------
* AJAX: REMOVE SALE
* ----------------------------------------------------------------------
*/
if ($_POST) {
require_once "../../../../static/_header.php";
class AJAX
{
private $conn;
function __construct()
{
$this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
}
function remove_promo($promo_item_id)
{
$sql = "DELETE FROM tbl_promo_item WHERE `promo_item_id` = ?";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("s", $promo_item_id);
$stmt->execute();
}
$stmt->close();
}
}
$_ajax = new AJAX();
$promo_item_id = filter_var($_POST['item_id'], FILTER_SANITIZE_NUMBER_INT);
$_ajax->remove_promo($promo_item_id);
}
