Re: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Richard Heyes
Hi, ... Sounds like you may have a MIME (an HTML email or one with attachments etc) email to decode. What you can do is use the PEAR class Mail_mimeDecode ( http://pear.php.net/package/Mail_mimeDecode ). Pass it the entire email (headers and all) and it will try to decode it for you. --

Re: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Dave M G
Richard, Thank you for responding. Sounds like you may have a MIME (an HTML email or one with attachments etc) email to decode. No, the mails should be in plain text format. I probably didn't describe my issue properly because I don't understand it fully. If I can assume all the mails I am

RE: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Jason
-Original Message- From: Dave M G [mailto:mar...@autotelic.com] Sent: 07 September 2009 14:26 To: Richard Heyes Cc: php-general@lists.php.net Subject: Re: [PHP] Taking body of an email and storing it in MySQL database Richard, Thank you for responding. Sounds like you may have a MIME

Re: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Paul M Foster
On Mon, Sep 07, 2009 at 07:47:00PM +0900, Dave M G wrote: PHP List, I am working on a project now where I need to check a POP3 mail account, download any mails there, and store the body and headers of each individual mail as plain text in a MySQL database. I have downloaded the POP3

Re: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Dave M G
Paul, Is there a decent tutorial anywhere on the net for the pop3.class.inc available on phpclasses.org? http://www.phpclasses.org/browse/package/1120.html Maybe I'm blind, but I just can't find anywhere a decent description or tutorial of what calls you can make to its functions. The

Re: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Paul M Foster
On Tue, Sep 08, 2009 at 03:27:05AM +0900, Dave M G wrote: Paul, Is there a decent tutorial anywhere on the net for the pop3.class.inc available on phpclasses.org? http://www.phpclasses.org/browse/package/1120.html Maybe I'm blind, but I just can't find anywhere a decent description or

Re: [PHP] Taking body of an email and storing it in MySQL database

2009-09-07 Thread Dave M G
Paul, Thank you very much for responding. I'm not sure why you're attempting to do the above. According to the documentation, you should simply be able to do ... $pop3-save2mysql(a bunch of parameters); I'm not sure the parameters on the save2mysql() function give me the flexibility I