update db when confirmed.