Re: Passing emails to database

From: 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

« previous php.general (#136259) next »