使用PHPMailer发送表数据

Question

I have a record which can be fetched from the database. I want to be able to send this tabulated report to email using PHPMailer.The issue now is: When the mail is sent, it shows only the header section of the table and the content is not shown. See my code below, maybe someone can tell me what i am missing or better approach:

$mail->Body    =  "<p>Please find below the Action Plan for Routine Report that is generated based on today's Check.</p><br/>".
                  "<table width='100%' border='1' style='margin-top:15px;' align='left class='table table-striped'>". 
                  "<thead><tr>".
                  "<th>SN</th>".
                  "<th nowrap='nowrap'>Mainlocation</th>".
                  "<th nowrap='nowrap'>Sub-Loaction</th>".
                  "<th nowrap='nowrap'>Issue</th>".
                  "<th nowrap='nowrap'>Current Plan</th>".
                  "<th nowrap='nowrap'>Who</th>".
                  "<th nowrap='nowrap'>When</th>".
                  "</tr></thead><tbody>".
                  $qq = mysqli_query($con,"SELECT * FROM tab_trans WHERE transid='$transid' ORDER BY subloc");
                  $d =0;
                  while($c = mysqli_fetch_array($qq)){ $d++;
                  "<tr>".
                  "<td nowrap='nowrap'>".$d."</td>".
                  "<td nowrap='nowrap'> ".$c['mainloc']."</td>".
                  "<td nowrap='nowrap'> ".$c['subloc']."</td>".
                  "<td nowrap='nowrap'> ".$c['issue']."</td>".
                  "<td nowrap='nowrap'> ".$c['what']."</td>".
                  "<td nowrap='nowrap'> ".$c['who']."</td>".
                  "<td nowrap='nowrap'> ".$c['period']."</td></tr>";
                  }
                  "</tbody></table>";

I have truncated the previous section of the phpmailer function. ie the settings. Thanks

Answer 1

Thanks all. The solution is this: The loop is the one having issue. It is not able to get the result. Hence, concantenating the $mail->body and little modification solves the problem:

$mail->Body    =  "<p>Please find below the Action Plan for Routine Report that is generated based on today's Check.</p><br/>".


                     "<table width='100%' border='1' style='margin-top:15px;' align='left class='table table-striped'>". 
                      "<thead><tr>".
                      "<th>SN</th>".
                      "<th nowrap='nowrap'>Mainlocation</th>".
                      "<th nowrap='nowrap'>Sub-Loaction</th>".
                      "<th nowrap='nowrap'>Issue</th>".
                      "<th nowrap='nowrap'>Current Plan</th>".
                      "<th nowrap='nowrap'>Who</th>".
                      "<th nowrap='nowrap'>When</th>".
                      "</tr></thead><tbody>";
                      $qq = mysqli_query($con,"SELECT * FROM tab_trans WHERE transid='$transid' ORDER BY subloc");
                      $d =0;
                      while($c = mysqli_fetch_array($qq)){ $d++;
  $mail->Body.=       "<tr>".
                      "<td nowrap='nowrap'>".$d."</td>".
                      "<td nowrap='nowrap'> ".$c['mainloc']."</td>".
                      "<td nowrap='nowrap'> ".$c['subloc']."</td>".
                      "<td nowrap='nowrap'> ".$c['issue']."</td>".
                      "<td nowrap='nowrap'> ".$c['what']."</td>".
                      "<td nowrap='nowrap'> ".$c['who']."</td>".
                      "<td nowrap='nowrap'> ".$c['period']."</td></tr>";
                      }
$mail->Body.=       "</tbody></table>";