PHP script to load csv to mysql

已完成 已发布的 7 年前 货到付款
已完成 货到付款

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 软件构架

项目ID: #10782290

关于项目

8个方案 远程项目 活跃的7 年前

授予:

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 更多

$15 USD 在1天内
(1条评论)
0.4

有8名威客正在参与此工作的竞标,均价$32/小时

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 更多

$24USD 在1天里
(258条评论)
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 在7天内
(24条评论)
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 更多

$50 USD 在3天内
(11条评论)
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 更多

$30 USD 在2天内
(0条评论)
0.0