'Sexting' US lawmaker Weiner resigns