I, getting a new xml file everyday to one of our external ftp servers. I want to get that file and then insert select data into my mysql.
What I'm thinking is that I would use curl to get the file, then simplexml and then insert into database.
But as the xml file contains sensitive data, the transfer must be encrypted to keep out prying eyes :)
In overview, does anybody have any suggestions or examples on how to go about this?