Hi, I'm pretty new to Arduino, and I'm having trouble powering 2 DC motors at the same time, using an L293D Motor Driver. I am using 1 9V battery to power it (Not a smoke alarm battery)
That's the reason for the trouble. The PP3 delivers 9 volt but not current enough. Replace it with a descent power source. AA batteries would do better but not for very long time.
Don't use those Fritzing pictures. Take the time to draw real schematics. All helpers know an UNO is blue and what a bread board looks like. No use for using surface to show that.
The problem here is current, not voltage - adding another battery in parallel could address that, but small 9V batteries (unless lithium chemistry) are notoriously low current and struggle completely with any sort of motor level current.