In Progress

Email parsing into MySQL with PHP

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.

Skills: PHP

See more: parsing mail mysql, parse email mysql, php parse sendmail linux, email parsing mysql, php email parsing mysql, writing email address, writing an email, table of content in project writing, subject php, root freelancer, project php freelancer, php project in freelancer, php in freelancer, php freelancer mysql, php freelancer id, php company, open a project for specific freelancer, number one freelancer, mysql database application, mysql data access, mail server freelancer, mail id of freelancer, linux project in freelancer, how to write email, how to email on freelancer

About the Employer:
( 1 review ) Gibraltar, Gibraltar

Project ID: #201312

Awarded to:

Alkobazik

Please see your PMB

$150 USD in 2 days
(15 Reviews)
4.6

8 freelancers are bidding on average $161 for this job

sourabhgupta3838

already worked on this...3.8 yrs exp in php

$100 USD in 0 days
(4 Reviews)
2.5
radcorpindia

Please check PMB

$300 USD in 20 days
(1 Review)
1.0
alilogics1

Its important but not a difficult task for us. We are 18 hours online to serve our precious customers. We work till our customer satisfied. PM us for detail. Regards, AliLogics Info tech.

$200 USD in 1 day
(0 Reviews)
0.0
nilsoftechnolgy

Hi, I have gone thru your requirement and i am very confident to give you best results. I have a team of experienced and highly qualified programmers(expert in PHP/J2EE), AJAX, Database designer (expert in MS SQL/MySQL More

$200 USD in 7 days
(0 Reviews)
0.0
nam07

Please check PMB

$140 USD in 3 days
(0 Reviews)
0.0
borodatyj

Hi! Please check PM

$100 USD in 1 day
(0 Reviews)
0.0
orlupo

I can do this project.

$100 USD in 5 days
(0 Reviews)
0.0