Welcome to WebmasterWorld Guest from 54.196.238.210

Forum Moderators: open

Message Too Old, No Replies

How to link a form to existing database on another site

Users need to enter a tracking number & get status from other database

     

peterdouglas

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

10+ Year Member



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

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

WebmasterWorld Senior Member 10+ Year Member



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

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

10+ Year Member



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!

 

Featured Threads

Hot Threads This Week

Hot Threads This Month