prepare("UPDATE stock_items SET stock_quantity = stock_quantity + ? WHERE id = ?"); $stmt->execute([$normalizedQty, $item_id]); } }