How would one retrieve emails from an email server and put them into a mysql database?
Idealistically sticking with php. But could incorporate another language if needed.
How would one retrieve emails from an email server and put them into a mysql database?
Idealistically sticking with php. But could incorporate another language if needed.
Yes, there's.
If you're using a hosting solution with cPanel. You should take a look at
http://devtrench.com/posts/simple-email-logger-using-cpanels-pipe-forwarder
(useful for php scripts)
If you're using a Postfix solution take a look at
http://evolt.org/incoming_mail_and_php?from=50
You should look for "piping email to php" or "piping email to python" or what the language you're using on google.
Anyway, with PHP or Python you can achieve that, getting your incoming email to a DB.
Here is the whole class which can help you do this i have used it and its working
http://www.phpclasses.org/package/3324-PHP-Retrieve-e-mail-messages-into-a-MySQL-database.html
further you can get help from PHP email to mysql database issue when not deleting emails from server
see the code he used, its is done by imap_open also see this