Completed

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
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
25
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online