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
