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!
22 freelancers are bidding on average $78 for this job
Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.
Hello Sir! I have excellent knowledge and experience with PHP and MySql. I am interested in this task and looking forward to have a positive response.. Thank you!