Multiple Image Attachments

thelos999

For some reason, if I use the following code, only one image seems to get sent:

$sql = mysql_query("SELECT photo FROM article_info");
while($row = mysql_fetch_assoc($sql)) {
    foreach($row as $img) {
        $mime->addHTMLImage($img);
    }
}

But if I were to manually enter each image:

$mime->addHTMLImage("path_to/image1.jpg");
$mime->addHTMLImage("path_to/image2.jpg");

Both images will be sent. Am I doing something wrong? Why would I only be sending/receiving one image? Any suggestions? Thanks in advance.

NogDog

Have you done any debugging to ensure that your DB query is, in fact, returning more than one result?

thelos999

Yes. I told it to return the number of rows, myslq_num_rows, and in fact it says 2.

NogDog

It probably shouldn't matter, but I would likely not use the foreach() loop on $row. You could also add some debug code to see what's going on. (In other words, I don't know what the problem is, and am hoping PHP will tell us.)

$debug = true; // set to false when done debugging
$sql = mysql_query("SELECT photo FROM article_info");
while($row = mysql_fetch_assoc($sql)) {
    $mime->addHTMLImage($row['photo']);
    if($debug) { user_error("Added image: " . $row['photo'], E_USER_NOTICE); }
}
if($debug) {
   echo "<pre>".print_r($mime, true)."</pre>";
}

NogDog

PS: You might want to check the return value of the addHTMLImage() method, in case it returns false or some other value when it runs into a problem.

thelos999

Well, it displays both images on the screen, but in the email, it only attaches one. And, looking at the garbled stuff at the bottom, it seems like it only sends one. Don't know how much of it you need, but I am attaching what I got.

NogDog

Well, it looks as if the second image overwrote the first one in the Mail_mime::html_images array. Since I don't know anything about that Mail_mime class, I don't know if it's a bug or expected behavior or user error. 🙂

thelos999

Finally got it to work. Here is what I ended up having to do:

$sql = mysql_query("SELECT photo FROM article_info");
	while($row = mysql_fetch_assoc($sql)) {
		$mime->addHTMLImage(file_get_contents($row['photo']), 'image/jpg', substr($row['photo'], 7), false);
	}

Apparently PEAR wants all that information, and I needed to put the path within the file_get_contents() function.