Send comma delimited CSV through SFTP?

Question

I am collecting registration information on my site and need to figure out how to pass all data stored in the MySQL DB (or just portions of it) as a CSV file through an SFTP so our partners can access the information. The pages are built using PHP.

I literally have no idea how to do this and am hoping somebody has experience doing so.

Thanks ahead of time!

---

EDIT

I don't necessarily need to store the information first- I am trying to take all the values collected during an enrollment process, parse them as a CSV file, then deliver the CSV file through SFTP somehow.

EDIT #2 - Configuration on client side changed and we are now using FTPS gien FTPS Server, TCP Port, username, password, data directory (ftp mode being passive). Any suggestions on how to approach using PHP?

Answer 1

There is a really nice PHP extension to handle SSH/SFTP. See the manual.