Nuclear attack 'will result in the end of whatever regime were to take such an action,' says US president