Đã hoàn thành

151415 mysql update script

I have a database with the following fields

id | pc | des | qty | who | condition | notes

I need to be able to upload a csv file via a web page,

the file then needs to be processed and perform the following functions.

compare the pc and who fields.

If there is a match i want it to take the quantity (qty) from the csv and ADD it to the quantity in the relevant DB row, NOT REPLACE IT so if the csv qty = 2 and the db qty = 5 the script should update the row to be 7.

If there is no match I would like it to insert a whole new row with the data from the CSV.

Once it has recieved and processed the CSV file a report of what was added and what was updated should be displayed.

I would like this fairly quickly and preferably fairly cheaply too.

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: the des, mysql report, update mysql csv php, script update database mysql, report mysql php database, mysql add fields, csv update, compare update, mysql compare update, report page mysql php, mysql update database, des php, mysql insert update , php mysql database report, update quantity mysql, script replace, php csv compare, report page php mysql, mysql replace script, notes php script, php data database update, csv upload script php mysql, notes mysql, insert data database mysql, update data mysql

Về Bên Thuê:
( 5 nhận xét )

ID dự án: #1897595

Được trao cho:


Hi. Thanks for considering this bid. This is a fairly simple job, and should not take much more than an hour to complete. I am ready to go on this as soon as you give the word. Delivery can be made in hours, jus Thêm

$15 USD trong 1 ngày
(0 Đánh Giá)