SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: connect remotely to mysql db
-
Jan 16, 2006, 00:12 #1
- Join Date
- Oct 2005
- Location
- Taos, NM, US
- Posts
- 441
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
connect remotely to mysql db
I would like to figure out a way to have all of my client's websites connect to a central db (hopefully MySQL) and retrieve shipping costs that way, even if they're not on the same server. This will make it easier if the costs are raised again (like they were on Jan 1). Anybody have any ideas?
Unless anyone knows of a way to connect to weight => cost USPS shipping info with some other service?
-
Jan 16, 2006, 07:25 #2
Hi
Essentially a mysql user is created in the central database. In the host field, instead of Localhost, it will be % so that connections from other servers are allowed. It might be a good idea to give that user limited powers - ie, just SELECT etc.
Then the connecting databases will connect to the central server as that new user, instead of to the "localhost" as they normally would.
Taking a punt, I think the USPS provide APIs to allow queries like you are suggesting,
http://www.usps.com/webtools/welcome.htm
Or you can parse their files:
http://www.usps.com/ratecase/_csv/Priority.csv
Additionally, I'm sure with all the ecommerce stuff around you could find a nice straight-forward example somewhere...
HTH
Simon
-
Jan 16, 2006, 12:06 #3
- Join Date
- Oct 2005
- Location
- Taos, NM, US
- Posts
- 441
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
oh my god, thank you for that link to the USPS-hosted web tools! I don't know why I wasn't able to find that before (sounds like they need to rethink their navigation, I say self-centeredly).
-
Jan 16, 2006, 15:13 #4
Originally Posted by mattalexx
Bookmarks