insert into MySQL via email and PHP?

[Microbe]

Hey there, is it possible to insert a record into a mySQL db with the data sent via email?

Have searched for something, but can't find on google.

Thanks in advance.

Steve Davis

http://www.HaHaHa.com.au/weblog

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination.

 

[TonyGroves]

You could certainly write a little program to fetch the mail, parse its contents, and execute the appropriate SQL commands.

 

[pwesson]

I've written such a script though it has to be installed on your server and you have to have your mail application execute the script when new e-mail is received.

If you are trying to do this from your Desktop e-mail client, then you need to write a windows application to do the work.

Paul Wesson, Programmer/Analyst

http://www.ipaw.net

 

[TonyGroves]

The script doesn't need to be installed on a server or have any dealings with other client software. It could include code to download mail from a remote POP server, and execute SQL commands on a remote MySQL server.

 

[Microbe]

Thanks for the responses, but does it exist so I don't have to reinvent the wheel?

And no, I am not able to install the script on the server. Apart from in my own directories.

Steve Davis

http://www.HaHaHa.com.au/weblog

NOTE: This sig does not include any reference to voting, stars, or marking posts as helpful as doing so is cause for membership termination.

 

[TonyGroves]

You would be better off asking that in the PHP forum.