Пример #1
0
/*
* ----------------------------------------------------------------------
* AJAX: REMOVE WISHLIST
* ----------------------------------------------------------------------
*/
if (isset($_POST)) {
    require_once '../../admin/static/_header.php';
    class AJAX_CLASS
    {
        private $conn;
        function __construct()
        {
            $this->conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
        }
        function delete_wishlist($wishlist_id)
        {
            $sql = "DELETE FROM tbl_wishlist WHERE `wishlist_id` = ?";
            $stmt = $this->conn->prepare($sql);
            if ($stmt === false) {
                trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
            } else {
                $stmt->bind_param("s", $wishlist_id);
                $stmt->execute();
            }
            $stmt->close();
        }
    }
    $_ajax = new AJAX_CLASS();
    $wishlist_id = filter_var($_POST['key'], FILTER_SANITIZE_NUMBER_INT);
    $_ajax->delete_wishlist($wishlist_id);
}