Re: Passing emails to database
| From: | Bobby Patel | Date: | Wed, 19 Feb 2003 21:44:17 +0000 |
| Subject: | Re: Passing emails to database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-136259@lists.php.net to get a copy of this message | ||
I have an idea that might work in theory. Provided that you have php running
on a Unix based OS. You could forward all emails to an email that sits on a
Unix server. There they are stored as plain text files, then just parse what
you need on a daily basis and truncate that file to 0 bytes.
BUT it sounds that you have the whole setup on a Windows based
machine/server. If you can get access to PHP and Mysql on a unix server
then you will have a chance.
I just did a quick check on the PC and it seems that Outlook express creates
files with a DBX extension to hold email folders.
I found mine at C:\WINDOWS\Application Data\Identities\{JIBBERISH
HEX}\Microsoft\Outlook Express. Try anyalsing these dbx files (open them up
in a text editor). But there HUGE even just if they have one message in
them.
good luck
"Alberto Brea" < > wrote in message
news:00e501c2d81f$e66d3e20$50a8e818@fibertel.com.ar...
Hi, list
Is there any way in PHP to pass the emails received automatically into a
local MySQL database on the same machine (i.e. the fields "date&time",
"from", "to", "message", "subject", etc), without copying
and pasting each
message? Maybe by retrieving and parsing the Outlook Express files that keep
the emails? (the e-mail is received by Outlook Express, and via browser from
a Yahoo account).
Thanks for any help
Alberto