homepage Welcome to WebmasterWorld Guest from 50.17.79.35
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
How to link a form to existing database on another site
Users need to enter a tracking number & get status from other database
peterdouglas




msg:1578304
 12:35 am on Apr 12, 2006 (gmt 0)

Is there a way to put a form on my site to let users enter a tracking number and get a status update? It's for a local moving company. Right now customers go to the main, corporate site to a web page done in asp, enter their info, and get and get tracking information.

My site is designed in php (solely for the purpose of using php includes). The form on my site would have the same fields as the one on the main corporate site. Then submit info to their database and post the results on my website. Can this be done? Here are the fields:

booker sequence year
shipper's last name
origin phone number (eg:8005551212)
origin postal code (eg: M5W 3T1) (yes, it's alpha numeric)

Any suggestions or help would be greatly appreciated, thanks! :)

 

moltar




msg:1578305
 1:07 am on Apr 12, 2006 (gmt 0)

If they provide you direct access to their database, then you can just connect to it remotely. If they don't then you can scrape their results, but it's a bit unethical, unless you get an approval from the company.

peterdouglas




msg:1578306
 1:48 am on Apr 12, 2006 (gmt 0)

Ok, thanks. I'd like to do it the right way, but it could take them a while to get back to me. If that's the case, what sort of information would I need to look for in their source code? I'm more of a designer than a programmer, so this is a bit unfamiliar territory for me.

Thanks!

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved