PHP script to load csv to mysql

Concluído Postado há 7 anos Pago na entrega
Concluído Pago na entrega

Need php script to load csv files from a directory on the server to MySQL database. Requirements are as follows

Need ability to specify the directory to search for files (can be variable in code or in parameter file)

Need to be able to create a new table in the MySQL database if the table does not already exist.

Needs to be able to load all records from the csv file but ignore the duplicates that may be in the table already. IE csv file could be a full table dump that 90+% of the records already exist in the database, you would need to ignore the records in the csv that already exist in the table

Need to be able to replace the table completely if required (flag set on running)

Need to be able to delete the csv files when they are completed processing

Need to be able to log any issues to a log file and email that file to specified address when there are errors

Need to be able to schedule job to run nightly (via cron?)

MySQL PHP Arquitetura de software

ID do Projeto: #10782290

Sobre o projeto

8 propostas Projeto remoto Ativo em há 7 anos

Concedido a:

robinverstraele4

I have a lot of experience with mySQL and php. A couple of weeks ago, I created a simular project in powershell so I know how to do it. It would be my first project on freelancer so I'm doing it for a rating. That's wh Mais

$15 USD em 1 dia
(1 Comentário)
0.4

8 freelancers estão ofertando em média $32 nesse trabalho

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Mais

$24 USD em 1 dia
(258 Comentários)
8.9
sambestsolutions

Hi I am an Engineer experienced in web development. I can help you please message to discuss further on this. Thanks Note-please check m profile for past projects and reviews.

$35 USD in 7 dias
(24 Comentários)
5.1
deadka

Hello, my name is Daniil, I am php-developer from Russia. Could you please share a more detailed description of the task? Provide please the example of the csv-file, there no attached files to your assignment. Als Mais

$50 USD in 3 dias
(11 Comentários)
3.9
phazraits

Hello, I’m excited to share with you the proposal for your project. I am an experienced PHP Developer having good working knowledge in PHP, MYSQL, Codeigniter, Jquery, Ajax etc.  more than 4 Yr.  I have worked in dif Mais

$30 USD in 2 dias
(0 Comentários)
0.0