No problem I have a mysql server sited 150 miles from the php server (more by accident than design, but it works day in day out)
Just set the connection parameter with the IP of the Mysql server and it works. php doesn't know or care whether mysql is on the same machine or one the other side of the world mysql_connect ( "123.456.123.456" , "username" , "password" ) HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 ----------------------------------------------- > -----Original Message----- > From: René Fournier [mailto:[EMAIL PROTECTED]] > Sent: 20 June 2002 19:33 > To: [EMAIL PROTECTED] > Subject: Can I be an ASP with PHP? > > > I have a question to which I'm pretty sure the answer will be "no", but > I would like to hope I'm wrong... > > I've developed a very simple Content Management tool--called > "Europa"--that even retarded monkeys can use to change/update text in > their web site. It's web-based, user-authenticated (sessions), and runs > with PHP4 and MySQL. > > Now, Europa is pretty much plug and play, so long as the web site is > getting its text from a MySQL database. There's a web agency in town > that is interested in Europa for their clients. Their clients want to be > able to easily and quickly update certain elements of their site without > begging some outside webmaster. They would really benefit from Europa. > > Problem: I don't want to "sell" Europa, or even install it on someone's > web server for a one-time fee. I've spent a long time on this little > tool, and want to continue to improve it. So, I would rather license it > to companies. They pay a quarterly subscription fee, and get to use > Europa as it continues to grow and improve. I'm just a little worried > about one thing: If I install Europa on their server, and they pay their > paltry quarterly subscription fee, and then decide they don't need any > updates, I'm screwed. The value of Europa is much greater than what I > want to sell subscriptions to it for (not much--I'm not really greedy), > but I need some kind of control. > > The idea: In order for Joe User to update text on his web site, he comes > to my "Europa" web site, enters his company name, user ID, password, and > clicks Login, and--voilà--he sees a handsome list of tables containing > the text content of his site--which is pulled from a MySQL database > residing on HIS web site's web host. > > And this is the trick: Can PHP somehow fetch MySQL data over the > Internet? Is this possible? If so, is it necessary for me to resort to > new, unknown technologies like XML or SOAP, or can I do it with PHP > alone? > > Thanks for your comments. > > ...Rene > > --- > René Fournier, > [EMAIL PROTECTED] > > Toll-free +1.888.886.2754 > Tel +1.403.291.3601 > Fax +1.403.250.5228 > www.smartslitters.com > > SmartSlitters International > #33, 1339 - 40th Ave NE > Calgary AB T2E 8N6 > Canada > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
