Solved

PHP IMAP Save Email Attachments to Disk

Posted on 2012-03-28
1
1,959 Views
Last Modified: 2012-03-30
Folks, I'm new to PHP and having a little trouble understanding how to save attachments from a email. The following script works great for saving to the database. I just need to add a section  to save attachments to disk. I have searched for the past few days. I guess I just don't understand PHP well enough.

Basically I want to run a daily cron job, grab all the emails with ### in the subject. Insert that information into a database. Then grab the file attachments and enter the name of the files into the database and save them to disk. the first part is working.

Can some please demonstrate this with the code below.
PHP Version 5.3.10 running on IIS 6 windows 2003


<?php
$db_host = 'somename';
$db_un = 'sa';
$db_pass = 'somepassword';

/* Authenticate to Mailserver */
$mailserver = "{smtp.something.com:143}";
$mailuser = "something";
$mailpass = "something";
 
/* Open Mailbox Stream */
$mbox = imap_open($mailserver, $mailuser, $mailpass) or die ("Couldn't connect to $mailserver");
 
/* Search For Message Criteria  */
$crit = "SUBJECT \"###\"";
$header = imap_search($mbox, $crit);
 
/* Return Results Of Search */
foreach ($header as $val) {
	$id="";
	
	/* Retrieve Body Of Message */
	$body = imap_fetchbody($mbox, $val, 1 , FT_PEEK);
 
	/* Retrieve Details From Header Of Message */
	// [subject] [from] [to] [date] [message_id] [size] [uid] [msgno] [recent] [flagged] [answered] [deleted [seen] [draft]
 
	$v = imap_fetch_overview($mbox, $val);
	foreach ($v as $ov) {
		$strsubject = $ov->subject;  // subject
		$strfrom = $ov->from;  // from
		$strto = $ov->to;  // to
		$strdate = $ov->date;  // date
		$messageid = $ov->message_id;  // Message ID
		
	}
	
$JOBNUM = str_replace(' ', '', $strsubject);
$JOBNUM = substr(ltrim($JOBNUM),3,6);
	// SAVE OR PARSE THESE VARIABLES INTO MySQL
	 
	   //$b = body;
 	   //$s = subject;
	   //$f = from;
	   //$t = to;
	   // $d = date;
	 
 	echo "<br>From: " . $strfrom . "<br>To: " . $strto . "<br>Date: " . $strdate . "<br>". "Subject: " . $strsubject . "<br>";
	echo "Job Number: " . $JOBNUM. "<br>";
	echo "MessageID: " . $messageid. "<br><br>";
	echo nl2br($body)."<br><br>";
	echo "---------------------------------------------------------------------------------------------------<br>";
	echo "---------------------------------------------------------------------------------------------------<br>";
	echo "<br><br>";	

	//DO DB insert here and save Files to Disk
	$conn = odbc_connect($db_host,$db_un,$db_pass);
    //mysql_select_db($db_name); 
	
 $body =  str_replace("'",'&#39;',$body);
 $body =  str_replace("\"",'&#34;',$body);
 $body =  str_replace("\\",'&#92;',$body);
 $strsubject =  str_replace("'",'&#39;',$strsubject);
 $strsubject =  str_replace("\"",'&#34;',$strsubject);
 $strsubject =  str_replace("\\",'&#92;',$strsubject);
 
	$stmt = odbc_prepare($conn, "INSERT INTO tblEmail (MailFrom, Subject, Body, JOBNUM, EMAILID) VALUES('" . $strfrom . "','" . $strsubject . "','" . $body . "','" .$JOBNUM. "','" . $messageid . "');");


 if (!odbc_execute($stmt)) { 
    /* error  */ 
    echo "Whoops"; 

} 
	odbc_close ($conn);
	imap_delete($mbox, $val);  // delete the e-mail
}
 
 
/* Delete Messages */
imap_expunge($mbox);
 
/* Close Mailbox Stream */
imap_close($mbox);
 
?>

Open in new window

0
Comment
Question by:farmerj2012
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
farmerj2012 earned 0 total points
ID: 37787356
I figured this out on my own after hours of trial and error. Thought I would post the code in case someone else was looking for something similar. Basically I call this page every 20 minutes using windows task scheduler. The page checks a mailbox for messages with ### in the subject line.

Enters the email into a database with a job number after ###. Then checks for attachments and enters those in to a table saving the files to disk. Sends a email back to the user

Subject Example:###10-567 Test 1234

 I am pretty new to PHP but it works for my small application.

<?php
$max_time_limit = 600; // in seconds
ini_set ("date.timezone","America/New_York");
ini_set ("SMTP","smtp.domain.com");
ini_set ("sendmail_from","noreply@domain.com");

function flattenParts($messageParts, $flattenedParts = array(), $prefix = '', $index = 1, $fullPrefix = true) {
	 
	    foreach($messageParts as $part) {
	        $flattenedParts[$prefix.$index] = $part;
	        if(isset($part->parts)) {
	            if($part->type == 2) {
	                $flattenedParts = flattenParts($part->parts, $flattenedParts, $prefix.$index.'.', 0, false);
	            }
	            elseif($fullPrefix) {
	                $flattenedParts = flattenParts($part->parts, $flattenedParts, $prefix.$index.'.');
	            }
	            else {
	                $flattenedParts = flattenParts($part->parts, $flattenedParts, $prefix);
	            }
	            unset($flattenedParts[$prefix.$index]->parts);
	        }
	        $index++;
	    }
	 
	    return $flattenedParts;	             
	}

function getPart($connection, $messageNumber, $partNumber, $encoding) {
	     
	    $data = imap_fetchbody($connection, $messageNumber, $partNumber);
	    switch($encoding) {
	        case 0: return $data; // 7BIT
	        case 1: return $data; // 8BIT
	        case 2: return $data; // BINARY
	        case 3: return base64_decode($data); // BASE64
	        case 4: return quoted_printable_decode($data); // QUOTED_PRINTABLE
	        case 5: return $data; // OTHER
	    }
	     
	     
	}
	 
function getFilenameFromPart($part) {
	 
	    $filename = '';
     
	    if($part->ifdparameters) {
	        foreach($part->dparameters as $object) {
	            if(strtolower($object->attribute) == 'filename') {
	                $filename = $object->value;
	            }
	        }
	    }
	 
	    if(!$filename && $part->ifparameters) {
	        foreach($part->parameters as $object) {
	            if(strtolower($object->attribute) == 'name') {
	                $filename = $object->value;
	            }
	        }
	    }
	     
	    return $filename;
	     
	}




$db_host = 'server';
$db_un = 'sa';
$db_pass = 'pw';

/* Authenticate to Mailserver */
$mailserver = "{smtp.domain.com:143}";
$mailuser = "user";
$mailpass = "pw";

$date = date("m-d-y-h-i-s");
	
/* Open Mailbox Stream */
$mbox = imap_open($mailserver, $mailuser, $mailpass) or die ("Couldn't connect to $mailserver");
 
/* Search For Message Criteria  See:  http://us.php.net/manual/en/function.imap-search.php */
$crit = "SUBJECT \"###\"";
$header = imap_search($mbox, $crit);
 
/* Return Results Of Search */
foreach ($header as $val) {
	$id="";
	
	/* Retrieve Body Of Message */
	$body = imap_fetchbody($mbox, $val, 1.1 , FT_PEEK);
 
	/* Retrieve Details From Header Of Message */
	// [subject] [from] [to] [date] [message_id] [size] [uid] [msgno] [recent] [flagged] [answered] [deleted [seen] [draft]
 
	$v = imap_fetch_overview($mbox, $val);
	foreach ($v as $ov) {
		$strsubject = $ov->subject;  // subject
		$strfrom = $ov->from;  // from
		$strto = $ov->to;  // to
		$strdate = $ov->date;  // date
		$messageid = $ov->message_id;  // Message ID
		$msgno = $ov->msgno;  // Message #
		
	}
	
$JOBNUM = str_replace(' ', '', $strsubject);
$JOBNUM = substr(ltrim($JOBNUM),3,6);
			
	 

 	echo "<br>From: " . $strfrom . "<br>To: " . $strto . "<br>Date: " . $strdate . "<br>". "Subject: " . $strsubject . "<br>";
	echo "Job Number: " . $JOBNUM. "<br>";
	echo "MessageID: " . $messageid. "<br><br>";
	echo nl2br($body)."<br><br>";
	echo $date;
	echo "<br><br>";
   	
	
	//DO DB insert here and save Files to Disk
	$conn = odbc_connect($db_host,$db_un,$db_pass);
    //mysql_select_db($db_name); 
	
 $body =  str_replace("'",'&#39;',$body);
 $body =  str_replace("\"",'&#34;',$body);
 $body =  str_replace("\\",'&#92;',$body);
 $strsubject =  str_replace("'",'&#39;',$strsubject);
 $strsubject =  str_replace("\"",'&#34;',$strsubject);
 $strsubject =  str_replace("\\",'&#92;',$strsubject);
 

$stmt = odbc_prepare($conn, "INSERT INTO tblEmail (MailFrom, Subject, Body, JOBNUM, EMAILID) VALUES('" . $strfrom . "','" . $strsubject . "','" . $body . "','" .$JOBNUM. "','" . $messageid . "');");
if (!odbc_execute($stmt)) { 
    /* error  */ 
    echo "Whoops"; 

} 
//get attachments

    $structure = imap_fetchstructure($mbox, $msgno);
	$flattenedParts = flattenParts($structure->parts);
	 
	foreach($flattenedParts as $partNumber => $part) {
	 
	    switch($part->type) {
	         
	        case 0:
	            // the HTML or plain text part of the email
	            $message = getPart($mbox, $msgno, $partNumber, $part->encoding);
				
	            // now do something with the message, e.g. render it
	        break;
	     
	        case 1:
	            // multi-part headers, can ignore
	     
	        break;
	        case 2:
	            // attached message headers, can ignore
	        break;
	     
	        case 3: // application
	        case 4: // audio
	        case 5: // image
	        case 6: // video
	        case 7: // other
	            $filename = getFilenameFromPart($part);
	            if($filename) {
	                // it's an attachment
                $attachment = getPart($mbox, $msgno, $partNumber, $part->encoding);
	                // now do something with the attachment, e.g. save it somewhere
				$Interpath = "F:/Interoffice_uploads/uploads/" . $JOBNUM . "/";
				mkdir(str_replace('//','/',$Interpath), 0755, true);
                //echo $date->format('U = Y-m-d H:i:s') . "\n"				
				$filename =  $date . "-" .$filename;
				$filename =  str_replace(' ','-',$filename);
				$filename =  str_replace('&','-',$filename);
				$filename =  str_replace('=','-',$filename);
				$filename =  strtoupper($filename);
				
				$tFileHandle = fopen($Interpath . $filename, "w");
				//$tFileHandle = fopen('F:/Interoffice_uploads/uploads/' . 'JF-' . $filename, "w");
				$fileContent = imap_fetchbody($mbox, $msgno, $partNumber);
                fwrite($tFileHandle, imap_base64($fileContent));
                fclose ($tFileHandle);
				echo "Attachment:  " . $filename;
				echo "<br>";	
				$stmt = odbc_prepare($conn, "INSERT INTO tblEmailFiles (FILENAME, EMAILID) VALUES('" . $filename . "','" . $messageid . "');");
				if (!odbc_execute($stmt)) { 
   			 /* error  */ 
    			echo "Whoops"; 

} 
				
				
				
	            }
	            else {
	                // don't know what it is
	            }
	        break;
	     
	    }
	     
	}

	echo "---------------------------------------------------------------------------------------------------<br>";
	echo "---------------------------------------------------------------------------------------------------<br>";

//send email	
 $to = $strfrom;
$newmsg = "Email attached to JOB#  ".$JOBNUM;
$newsubject = "Email Upload Complete";
mail($to,$newsubject,$newmsg);
 
	odbc_close ($conn);
	imap_delete($mbox, $val);  // delete the e-mail
}
 
 
/* Delete Messages */
imap_expunge($mbox);
 
/* Close Mailbox Stream */
imap_close($mbox);
 
?>

Open in new window

0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question