Specifications

LISTING 28.16 Continued
}
else if (mysql_num_rows($result)==0)
{
echo “There is nobody subscribed to list number $listid”;
return false;
}
else
{
include(‘class.html.mime.mail.inc’);
$mail = new html_mime_mail();
// read in the text version
$filename = “archive/$listid/$mailid/text.txt”;
$fp = fopen ($filename, “r”);
$text = fread($fp, filesize($filename));
fclose ($fp);
// read in the HTML version
$filename = “archive/$listid/$mailid/index.html”;
$fp = fopen ($filename, “r”);
$html = fread($fp, filesize($filename));
fclose ($fp);
// get the list of images that relate to this message
$query = “select path, mimetype from images where mailid = $mailid”;
if(db_connect())
{
$result = mysql_query($query);
if(!$result)
{
echo “<p>Unable to get image list from database.”;
return false;
}
$num = mysql_numrows($result);
for($i = 0; $i<$num; $i++)
{
//load each image from disk
$filename = “archive/$listid/$mailid/”.mysql_result($result, $i, 0);
$fp = fopen($filename, ‘r’);
$image = fread($fp, filesize($filename));
fclose($fp);
// add images to the mimemail object
$mail->add_html_image($image,
mysql_result($result, $i, 0),
Building a Mailing List Manager
C
HAPTER 28
28
BUILDING A
MAILING LIST
MANAGER
705
34 7842 CH28 3/6/01 3:46 PM Page 705