FTP file download and insert the data into MYSQL database using PHP
This project was successfully completed by R3d0n3 for $30 USD in a day.Get free quotes for a project like this
Project Budget$30 - $250 USD
Completed In1 day
Fix existing PHP coding to download a large zip file via FTP to FTP, unzip this file and input the data into and existing MYSQL database.
You can either fix the existing PHP or write your own. This PHP coding used to work at one time but I cannot figure out why it is not working now.
I will use a CRON job to make this happen every 24 hours. This is the FTP address of the zip file:
Included in this work is a small job fixing a PHP file to be able to query and select 2 fields from the same column.
This is the Code I am using now that doesn't work:
$query = "SELECT * FROM vesciALLmls WHERE STATUS_CODE = 'A' && SALE_PRICE != '' && TLN_FIRM_ID = '1040654' && PROPERTY_TYPE_CODE = 'M' && PROPERTY_TYPE_CODE = 'V' && PHOTO_IND='X' ORDER BY RAND() LIMIT 999";
Will entertain any REASONABLE bid!
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online