PHP script to load csv to mysql
$10-30 USD
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?)
ID do Projeto: #10782290
Sobre o projeto
Concedido a:
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
8 freelancers estão ofertando em média $32 nesse trabalho
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
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.