[php] Pickup mail from pop mailbox and post into MySQL DB

[neonetman]

I'm developing a staff and student notice board to integrate into our intranet. One thing I need is a script that can run as a cron task to pull in emails from a specific pop mailbox, and then post the contents into a MySQL database.

 

The cron/php/MySQL bits are no problem - I've just no idea on getting emails pulled in.

 

Can anyone help?

 

Cheers

[mats]

Python has libs which will handle pop3 and mysql. Have a look at poplib for the former.

[SovietRussia]

Why not build a form which directly posts to MySQL? (If its for a noticeboard it will be a hell of a lot easier than having to reach into mailboxes and pull content out)

[neonetman]

We are currently trying to reduce the number of all staff emails being sent, so my aim is to have staff email a seperate mailbox, that will then be picked up and imported into the noticeboard. Staff will also have the ability to use a web form as an alternative option

[webman]

PHP has some functions available for operating with IMAP, which also support some POP methods - PHP: Introduction - Manual