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