Em Andamento

CSV Download to MySQL Database using PHP

I need a PHP script that can be automated with CRON Jobs.

The PHP script will have to do the following:

1. Download a remote ZIP file containing a CSV File.

2. Unzip the file.

3. Transfer the first row only to Table 1 of the database.

4. Transfer all other rows/columns of data from row three onwards to Table 2 of the database.

I have attached a copy of the zip file with the csv in it so that you can see what needs to be transferred (please note the zip file will be located on a remote server so the script will need to incorporate the ability to download the file from a remote URL).

This process will need to be automated and run (via cron jobs) several times a day so the script will also need to delete the previous zip/csv file and empty the information from both Tables of the database before uploading the new data.

We also have a bigger project coming up that you may be interested in - will be posted on GAF soon. The successful bidder of this project will get preference on our next project if the work is done well.

Payment will be made preferably by GAFs Escrow service but other ways will be considered if necessary.

Thanks for looking!

Habilidades: PHP

Ver mais: csv mysql using php, zip jobs, work remote jobs, what is escrow service, what can you do with php, transfer url, remote work php, remote work jobs, remote jobs it, remote jobs c#, process work jobs, php service, php remote jobs, payment is only with escrow service, mysql database server, jobs php remote, it remote+ jobs, file download service, c++ remote jobs, c# remote jobs, php csv download, php download csv mysql, csv cron job php, download csv mysql, csv database via php

Acerca do Empregador:
( 2 comentários ) Gosport, United Kingdom

ID do Projeto: #155488

Premiar a:


Hi, I can easily do this project. Please check your PMB for more details. Yours, Amiri

$30 USD em 1 dia
(36 Avaliações)

15 freelancers estão ofertando em média $44 para este trabalho


Valueonweb is a customer-specific service oriented company has got an Professional and creative team. We are the Professional Web Development Company having 3 years experience in Web design and development. We have exp Mais

$30 USD em 1 dia
(212 Comentários)

I am ready to help you.

$80 USD in 2 dias
(99 Comentários)

Please check it out the PM for more info, thanks…

$55 USD in 2 dias
(95 Comentários)

Professional work from professionals!

$50 USD em 1 dia
(219 Comentários)

Hello Sir, Please check PMB

$30 USD em 1 dia
(141 Comentários)

hi, please have a look at pmb. regards, Rakesh

$50 USD em 1 dia
(22 Comentários)

I can do it.

$30 USD em 1 dia
(42 Comentários)

Please look PMB.

$50 USD in 0 dias
(5 Comentários)

I can do this for you. I have experience with CSV files.

$50 USD em 1 dia
(3 Comentários)

Hello, I'm very interested in working on your project and I can deliver a script fulfilling your requirements within just one day. I can start immediately after having been chosen by you and I have experience in PHP de Mais

$40 USD em 1 dia
(4 Comentários)

Hello, please check PM. Thanks, Sergey.

$30 USD em 1 dia
(2 Comentários)

CHeck PMB Plz

$50 USD em 1 dia
(0 Comentários)

I will give u script in half day. For more info. check your PMB/

$50 USD em 1 dia
(0 Comentários)

I can do it.

$30 USD em 1 dia
(0 Comentários)