Read two airport codes from each lines from table mightyDeals (database1) if there is no city field filled in:
SELECT `toCode`,`fromCode` FROM `mightyDeals` WHERE `fromCity` ='' or `toCity`=''
--> take all matching rows
2) get city names for all airports from database2 one (new connection)
SELECT city FROM `airport` WHERE `iata`='$row';
3) Save back city names into mightyDeals
UPDATE fromCity set '$cityname' where toCode='$cityto' and fromCode='$cityfrom'
UPDATE toCity set '$cityname' where toCode='$cityto' and fromCode='$cityfrom'
This script shall run on command line (CLI). We will provide all data and tables (just need the script making a connection).
Seems straightforward. I can start your script right away and have it back to you in a couple of hours.
I am an experienced web developer with over 25 years of coding experience. I;ve done both web faced development and CLI development. Can start right away.
$30 USD en 1 día
5,0 (2 comentarios)
2,5
2,5
7 freelancers están ofertando un promedio de $26 USD por este trabajo
Hi.
Quality code and responsibility or don't pay. I am in IT since 2012.
I read the assignment.
You can use php file and run it from CLI. And you can use .bat file if you want run it via schedule. (It is about Windows OS)
If you have a desire to cooperate, I will be glad to help.
I'm online from 8 to 15 GMT. And 6 to 20 GMT after we start cooperating. I answer within an hour.
Thanks.
Hi, I'm ready to doing this work. I have 5 years experience. I'll do my best best and ensure the quality works. Please Contact with me. Thanks in advance. Best Regards AsNetwork