Mail 2 MySQL

[Chris Day]

On my hosted site, I can pipe email to a script (example, info@heartlevelminsitries.org ->> support.pl).

I'm trying to find out if there is a sample script anywhere so I can have emails piped through that .pl file and inserted into an existing mySQL database.

Anyone know of anything?

Chris

[Technosailor]

Hmmm, this is a really good question and something we're trying to answer for a hosting client who wants to do the same thing except, instead of data going to MySQL, the data would go to a file...I'm hoping we can get a Perl OR a PHP solution to this.

Aaron

[Chris Day]

there just has to be a way to do this :-p

[jonsagara]

If I understand your question correctly, you're basically asking how to insert email addresses into a table in a MySQL database, correct? If that's the case, then what you're looking to use is the DBI module.

http://dbi.perl.org/doc/index.html

I wrote a Perl guestbook script that uses DBI to insert data into a MySQL database. Maybe you can grab some of that code to help get you started.

http://www.codeproject.com/useritems/perlguestbook.asp