dongrou839975 2014-07-28 06:20
浏览 50
已采纳

PHP Mailer中的动态HTML

I have a database with the following fields

  1. ID
  2. title
  3. URL
  4. summary

This data is stored in a multi dimensional associative array like this:

$array[0][title] = Title-1
$array[0][summary] = Summary-1
$array[1][title] = Title-2
$array[1][summary] = Summary-2

I also have a script that can loop through these and render as needed.

However I'm finding it tough getting this output into the body of a mail.

Looking around got me the following

  1. Dynamic Content into mail() $message
  2. Dynamic HTML Table in PHP Mail
  3. HTML mail with dyanmic values
  4. How to send HTML Dynamic Table as mail in php?

I found many more solutions via google, but they're more or less similar to the one's above.

These have not been helpful as the content is part static and part dynamic. In my case the whole body would be dynamic

Here's what I have as of now

function get_mailer_contents($email_category) {
    global $mailer_contents;
    $fetch_mailer_contents = mysql_query("SELECT * from `selected_posts` WHERE industry='$email_category'");
    $id = "0";
    while($temp_mailer_contents = mysql_fetch_array($fetch_mailer_contents))
        {
            $mailer_contents[$id]['title'] = $temp_mailer_contents['title'];
            $mailer_contents[$id]['description'] = $temp_mailer_contents['description'];
            $id ++;
        }
    }

get_mailer_contents($email_category);

foreach($mailer_contents as $title_cat)
{
    echo "==================";
    echo "<br>";
    echo $title_cat['title'];
    echo "<br>";
    echo $title_cat['description'];
    echo "<br>";
}

The output rendered here is not the final output. I'm using this just for testing purpose.

My problem is, a foreach function(or anything similar that would loop through the array) cannot be part of $message(body of the mail) mailer and I need to have a mechanism as the data is dynamic

Hope I have been clear enough. Do let me know if you need more specifics

  • 写回答

1条回答 默认 最新

  • drtiwd06558 2014-07-28 06:27
    关注

    You simply need to assign your output to variable and then use it in PhpMailer as in the following code:

    $html = '<html><head><meta charset="utf-8" /></head><body>';

foreach ($array as $item) {
   $html.= '<p>'.$item['title'].' '.$item['summary']."</p>";
}

$html.= '</body></html>';

// ... setting up phpMailer


$phpMailer->Body = $html;
$phpMailer->AltBody = nl2br(strip_tags($html));
$phpMailer->IsHTML(true); // you need to set HTML format

    You also need to use IsHTML method to tell phpMailer to send the content as HTML, you should also set AltBody to display your mail for people who don't want/cannot display it in HTML format. Above I used a very simple way to transform html to text. However you can put here any other text as you want.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

悬赏问题

  • ¥15 metadata提取的PDF元数据，如何转换为一个Excel
  • ¥15 关于arduino编程toCharArray()函数的使用
  • ¥100 vc++混合CEF采用CLR方式编译报错
  • ¥15 coze 的插件输入飞书多维表格 app_token 后一直显示错误，如何解决？
  • ¥15 vite+vue3+plyr播放本地public文件夹下视频无法加载
  • ¥15 c#逐行读取txt文本，但是每一行里面数据之间空格数量不同
  • ¥50 如何openEuler 22.03上安装配置drbd
  • ¥20 ING91680C BLE5.3 芯片怎么实现串口收发数据
  • ¥15 无线连接树莓派，无法执行update，如何解决？（相关搜索：软件下载）
  • ¥15 Windows11, backspace, enter, space键失灵