as another solution (and not knowing mysql replication myself, so can't comment on this) you could connect remotely to your MySQL database that is on your intranet, and dump the data straight into it. it really depends how open to the world that system is, or can be, and how security concious you are.
or you could have some kinda XML output or DB dump from the online website available, and have your local CRM machine access that every 5 minutes or less... just 2 other solutions, maybe not the best, but they'd do the job... ----- Original Message ----- From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 10:53 AM Subject: Re: [PHP] Passing data between the web to an Intranet > On Wednesday 26 March 2003 16:40, Steve Jackson wrote: > > > Sorry. What I mean is that we have an externally hosted website. > > Currently all the forms etc update tables in the web hosted mysql DB. I > > am in the process of building a small CRM system and want the data to > > drop into our non public domain Intranet server. Is this possible? > > OK. Yes, some of the possible solutions are as below: > > > > > I am thinking down one of three lines. > > > > 1) I use PHP to send an email with the data in it and update our > > > > internal DB manually (the worst case) > > > > > > Can be done pretty easily. > > > > I know but I don't want to have to manually update data from emails to > > our Intranet server. > > Manually? What I meant was that it's pretty easy to send an email to a server > and have a script process the email. Thus the script will parse the contents > of the mail and update the db accordingly. Search the archives for "process > mail", I have some old posts which outline how this can be done. > > > > > 2) I use PHP which takes data, sends it as an email, puts it into a > > > > form which then automatically updates our internal network > > > > (interesting idea but I have no clue if it can be done ;o) > > > > > > Not sure what you mean here. How is it different from the above? > > > > I was thinking that I may be able to *automatically* take the data from > > emails and put them through a form (hosted internally) which would then > > update our DB here. I just don't know whether it's possible to do or > > where to start. > > See above. > > > > > 3) I use some sort of synchronisation so every time the web DB is > > > > updated our internal one is also updated (ideal). > > > > > > See mysql replication. > > > > > > > I would welcome any other ideas or solutions. Does mysql have any > > > > replication or synchronisation functions? I am told Oracle has but > > > > haven't seen this or heard of this with mysql. > > > > > > Did you actually do any research? I'm sure if you google for "mysql > > > replication" or "mysql synchronisation" you would get > > > thousands of hits. > > > > Yes I did but am not really understanding it which is why I asked here. > > Sorry if that offends you. > > With all due respect that is not what you asked. In any case for help on > mysql's replication feature you should ask on the mysql list. > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > ------------------------------------------ > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-general > ------------------------------------------ > /* > does your DRESSING ROOM have enough ASPARAGUS? > */ > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
