Page 1 of 1

FTP to SQL

Posted: Wed Mar 26, 2008 4:50 pm
by themcnabs
I am in need of setting up a script to automatically download a file via FTP and import it into a SQL database. Can someone help me with this?

Re: FTP to SQL

Posted: Wed Mar 26, 2008 5:09 pm
by Christopher
For FTP there are many classes around that help with this, or:

http://us.php.net/manual/en/ref.ftp.php

To help you import into a database we would need to know the format of the data. Look into LOAD DATA INFILE.

Re: FTP to SQL

Posted: Wed Mar 26, 2008 8:36 pm
by themcnabs
The ftp looks pretty straight forward. Can this PHP script be put into a cron job?

I found the syntax for the "LOAD DATA INFILE", but where do you implement it?

Re: FTP to SQL

Posted: Thu Mar 27, 2008 8:59 pm
by themcnabs
This is now looking like it is going to be too complicated for me. Is there anyone I could hire to do this for me?