Re: Process data changes in MySQL by e-mail!?!?!?

On Thu, 19 Oct 2000, Kraa de Simon wrote: > Hi, > > Anybody know if this is implemented / can be implemented? > > - E-mail the changes in a MySQL database (data) to e-mail adres. > - Changes are read (by PHP script) on server and processed in MySQL database. > > So e.g. e-mail "insert into test values (...)" to changes@mydomain.com and the > insert is processed by changes.php in tabel test in connected database. Hhmm, > how do I trigger the processing... > > TIA. Off the top of my head and if on *nix - compile a cgi version of PHP; write a script (and make it executable and put #!/path/to/php on the first line) that does what you want which you fire up by piping the email to the script via your alias file (or qmail equivalent). How to get the content of the email? I think via stdin? -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA