get mail from mail server and process it

[hanwei]

hi,

i have created a table in my database. the table consist of columns named clientName, problem and problemDesc.

When a client email a message to my mail server([e-mail]), the script will grep the mail from my mail server and process it.

I want the informations in From:, Header: and Message: to be automatically inserted into the table that i have created.

For Example :
To: [e-mail]
From: [e-mail]
Header: problem1
Message: Hi, i have a problem in my computer. Please help.

The informations is inserted into the table:
[e-mail] >> clientName
problem1 >> problem
Hi, i have a problem in my computer. Please help >> problemDesc

so how will i go about doing it? Do i have to use the sendmail option? or the procmail?

thanks in advance..

[hanwei]

up~ ??

[liquorvicar]

You probably need to investigate PHP's IMAP functions

[pixelsoul]

If you want the data from the email they send you from the form inserted into MySql, why not just have the data inserted into the db and then have the email processed normally? May be I am misunderstanding exactly what you are trying to do but that would be the way I would do it if I wanted the email data in my MySql db.

[hanwei]

pixelsoul wrote:

If you want the data from the email they send you from the form inserted into MySql, why not just have the data inserted into the db and then have the email processed normally? May be I am misunderstanding exactly what you are trying to do but that would be the way I would do it if I wanted the email data in my MySql db.

hi, thanks for replying..

my script works like this. If a client sends an email to my mail server, the script will grab the data from the email and inserted into my database, thus a ticket is created. It is like creating tickets using email.

I already have a form whereby client can key in their particulars and submit it, and it will straight away be inserted into my database.

So now i'm trying to create another script whereby ticket will be created via email.

so can u give me some idea on how to do it?

thanks in advance...

[liquorvicar]

As I said, you need to look into PHP's imap functions.
You can use them to log into a mailbox on your server, parse the mail and extract the info you need (e.g. from address, subject and body).

[pixelsoul]

Oh okay, now I understand your method. liquorvicar is right, you would need to check PHP's imap functions for that. Sorry I just misunderstood what exactly you were doing.

[hanwei]

hmm.. kk thanks alot, i will try to read more about the IMAP thing first..

i hope you guys can help me when i'm stuck somewhere...

thanks alot..😃