iPhone video input (composite)
There are no known solutions for video input to the iPhone (other than the built-in camera of course). The AV cable you mentioned only provides video output and since there are no pins for video input on the dock connector (although the pinouts have often changed during the history of the dock connector), and the iPhone has no other inputs suitable for video input, this is very unlikely to happen with current iPhone/Pod/Pad models.

The closest solution I can think of would be to use an external recording device (a computer with a video capture device for example) and stream the resulting video the the iPhone over Wifi.