Parsing Email procedures, some guidance.

[ShopMAster]

Hey guys, I'm fairly new to PHP, but getting better everyday through an application that I'm creating from scratch.  So far so good. 

 

My question is how would I go about getting an email into a database.  I've heard about parsing but honestly have no clue as to how to do it.  If someone can point me to an article or something I can read that would be appreaciated.  I have an email that comes to me every day in the same format but with different data and I want to store that email into my database to retrieve later.  Is there a way it can automatically be done?  I've heard they have software that does this but like I said, I do not even know where to begin.  Thanks for your help.  PHPFreaks is the best.

 

Shopmaster

[skali]

http://wiki.jumba.com.au/wiki/Pipe_an_email_to_a_script

 

Once you have piped properly and your script is receiving the email.

 

$email_file = fopen("php://stdin", "r");

 

this script as described in the tutorial will have the complete contents of the email and you can do whatever you want with it.

[ShopMAster]

When I tried to put the

 

| php -q -n /home/USERNAME/public_html/SCRIPT.php

 

 

into the forward email it didn't take.  Is there some software that does this?

[skali]

If you are using sendmail the pipe can be put into /etc/aliases in the following form:

[email protected]: "| php /path/to/yourscript_handling_mail.php"