FTP to SQL
Moderator: General Moderators
FTP to SQL
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?
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: FTP to SQL
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.
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.
(#10850)
Re: FTP to SQL
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?
I found the syntax for the "LOAD DATA INFILE", but where do you implement it?
Re: FTP to SQL
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?