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 flexibilit

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 descript

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 documentat

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 POP

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 respon

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 a

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. -- Richa