Email parsing into MySQL with PHP

Email parsing into MySQL with PHP is project number 201312 posted at GetAFreelancer.com. Click here to post your own project.

Status:	Closed (Selected Service Provider)
Selected Providers:	selected service provider Alkobazik
Budget:	$100-300
Created:	12/04/2007 at 6:16 EST
Bidding Ends:	12/05/2007 at 6:16 EST
Project Creator:	ralph123   Buyer Rating: (1 reviews)
Description:	I need an application writing that will receive all incoming emails to a specified domain, parse them, modify some content on them and store them in a MySQL database. The mail server will be Sendmail and will be hosted on a Linux box that I have root access on. Sendmail will need to invoke this script every time an email is sent to a specific domain. I will take care of this part of the project in the live environment. The freelancer just needs to write the PHP application for me. I need the following data storing in the database: ID Sender email address Sender's company * Date Subject Content ** * The sender's company will be one of a number of companies in a lookup table. The script needs to detect the sender's company from either the sender's email address, text in the subject or text in the content. ** Most of the emails received will be HTML emails. If an email has HTML content then it is the HTML part that wants storing in the database, if there is no HTML then only the text part wants to be stored. Any HTML links need to be parsed to add an affiliate ID in them. I am also open to other suggestions on how to approach this and if someone can provide the same functionality reading the emails via either POP/IMAP then I will consider this too.
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	8
Average bid:	$ 161