FTP file download and insert the data into MYSQL database using PHP

  • Status Completed
  • Budget $30 - $250 USD
  • 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!

Get free quotes for a project like this
Completed by:
Skills Required

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