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

Closed

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!

Skills: MySQL, PHP, Software Architecture

See more: download php code insert data mysql database, unzip ftp, php software download, mysql software download, mysql database software, ftp unzip, download coding software, code 999, fix mysql query, php insert select, download file php zip, unzip php, php download zip, php code write, php mysql database query, ftp mysql, software cron, cron job php ftp, php ftp cron job, php download limit download, php code input mysql data, php download zip file database, write ftp software, upload excel file mysql database using php, php mysql download zip file

Project ID: #4759610

Awarded to:

R3d0n3

hi ... i am experienced in php for 12 years ...

$30 USD in 1 day
(1 Review)
1.2

22 freelancers are bidding on average $78 for this job

toinnisfree

quick pro help. ftp and milestone required.

$100 USD in 1 day
(558 Reviews)
7.9
rajeshsonisl

Quality work assured. Ready to get started. Thanks.

$154 USD in 1 day
(411 Reviews)
7.1
eelance

mind show me more details? the sample of the zip file and the php script?

$88 USD in 3 days
(326 Reviews)
6.8
kssoftphp

I am ready and expert in PHP and MySQL.

$84 USD in 3 days
(58 Reviews)
6.6
leomedina01

**** Hi sir, I have lots of experience in PHP. Please drop me a line, so we can discuss this project in details. I'm an experienced Web Developer having worked for 5+ years with PHP, Java, Solr/Lucene, Sphinx Search, S More

$44 USD in 3 days
(63 Reviews)
6.0
techwelfare

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.

$105 USD in 3 days
(51 Reviews)
6.0
akiles99

Hi, I can do the script for you . You can use cron later for any interval.

$55 USD in 1 day
(125 Reviews)
5.9
sunilexpert

I am an expert web developer with 8+ years of developing dynamic web applications and websites. I have experience in PHP, MySQL, Ajax, Javascript etc. You can see feedback against my profile they are always awes More

$100 USD in 5 days
(50 Reviews)
5.7
farhaoui

Thank you for giving your precious time to review my bid and check PM! Thank you

$83 USD in 3 days
(59 Reviews)
5.2
Mezh

Hello, check and answer my message please. Thanks, Alex

$210 USD in 3 days
(16 Reviews)
5.2
Softanz

Professional developer here. I am 6+ years experience in HTML, PHP5, CSS ,MySQL, Ajax, Jquery, JavaScript, Wordpress. My portfolio and review will clarify my skills.I can quickly help you to get it done on-time and wit More

$54 USD in 3 days
(34 Reviews)
5.1
FASTGuru

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!

$74 USD in 1 day
(39 Reviews)
5.0
Paid4Upload

I can complete this project, please read PM

$155 USD in 3 days
(30 Reviews)
5.0
trongtd1988

I ready start make it for you!

$55 USD in 1 day
(9 Reviews)
4.8
techvolcano

We can do this.

$45 USD in 3 days
(27 Reviews)
4.8
lfr2

I have strong knowledge in php, mysql. I'm competent, reliable and efficient coder. Please check pmb.

$35 USD in 1 day
(36 Reviews)
4.7
html5css3php5

Hi i am ready to start the work now.. i have experience on FTP tp FTP download....

$44 USD in 3 days
(34 Reviews)
4.7
abhishekmiet

Ready to start. Quality assured.

$60 USD in 1 day
(14 Reviews)
4.5
thetidevw

Hi, i can do this for you my friend.

$64 USD in 3 days
(20 Reviews)
4.3
alexeyshentyakov

hi, I can help

$55 USD in 3 days
(2 Reviews)
2.4