The war in Iran and subsequent increase in fuel prices have driven US President Donald Trump's popularity to record lows ahead of November’s midterm elections.