Peruttu

Import db

My original data is stored in txt only(5 fields).

For some reason, I import 2 fields(url,description) recently for link checking purpose.

So I still need to import 3 other fields into the db. Since the data in mysql is not in original order or some links have been deleted. So your script must match the url field first and then insert 3 other fields to the correct row.

Here is sample txt db:

url,category,model name,des,sponsor,site

[url removed, login to view],category,name,desc,sponsorurl,sitename

[url removed, login to view],category,name,desc,sponsorurl,sitename

[url removed, login to view],category,name,desc,sponsorurl,sitename

[url removed, login to view],category,name,descsponsorurl,sitename

I need a script to do it. Not working in phpmyadmin.

Taidot: tietojenkäsittely, Perl, PHP

Näytä lisää: the des, sponsor, php db, import mysql, desc, db, sample perl, url import data, perl sample, insert txt, php mysql import script, import category, script import, des php, mysql data import, pending order deleted, cgi model, sponsor script php, php import, perl script data mysql, sponsor php script, mysql php insert script, mysql import script, mysql row order, php script data import

About the Employer:
( 140 reviews ) Hong Kong, Hong Kong

Projektin tunnus: #48517

4 freelanceria on tarjonnut keskimäärin 50 $ tähän työhön

bruzli2005

Within an hours and its done. Let me know.

30 $ USD 0 päivässä
(137 arvostelua)
7.1
webalis

I often had to do jobs in this flavor. I can create your import script in minutes only. PS: my email server is being replaced now, and so, for now I won't receive GAF emails. Send me a PM if you are intersted, I'll c Lisää

40 $ USD 0 päivässä
(2 arvostelua)
3.5
bluegene

Greetings can be done

30 $ USD 1 päivässä
(1 arvostelu)
2.0
yumair

Please check your PM!

100 $ USD 1 päivässä
(0 arvostelua)
0.0