Hey guys,
I am planning to cycle through some phone numbers in my database (I have it in MS Excel but can put it in MySQL), and using the “reverse phone lookup” feature of the site www.411.ca, I plan to find to who each number belongs to. However, I want to do this quickly and not manually. I want to automatically plug in each number as a GET variable in the address bar of the www.411.ca site (which I can easily do using php) but then how can I easily retrieve the person’s name from the 411.ca site???
Simply stated: How can I retrieve data from a data field of an external website?
I know Excel has a “retrieve external data” function so I know it can be done. But Excel’s function has to be done manually and it’s not designed to be used for every single number. Is there some other similiar feature of php or java? I was also reading up on something called “xmlhttp” but not sure how that works (http://www.4guysfromrolla.com/webtech/110100-1.shtml).
This is actually something for work so I would greatly appreciate your helping me. Thank you!