在过去的几个小时里,我一直在尝试在电子邮件中创建一个动态表..而且我一直不成功,我试图在体内内外创建表变量并在其中回显它,但我没有成功,我把我的代码放在下面.. 任何帮助将非常感谢.. 我试图做的只是创建一个包含一些 MySQL 数据的表,然后发送它给一些客户..这只是我一直在努力完成的内容的一小部分
$link = mysql_connect('localhost', 'root', '');
mysql_select_db('netbookdb');
$sql="SELECT * FROM rep_log WHERE s_date = '2012-05-31'";
$result=mysql_query($sql, $link);
$date=date('dmy');
require("../PHPMailer/class.phpmailer.php");
$mail = new PHPMailer();$mail = new PHPMailer();
$mail->IsSMTP(); // set mailer to use SMTP
$mail->Host = "smtp"; // specify main and backup server
$mail->From = "support@.vic.edu.au";
$mail->FromName = "Ict Devices";
$mail->AddAddress("email@h.vic.edu.au", "Matthew");
$mail->Subject = "Damage Log Report";
$mail->IsHTML(true);
$var='xlsx';
$date=date('dmy.');
$mail->Body = " while($rows=mysql_fetch_array($result)){
$cases=$rows['cases'];
$hg=$rows['hg'];
$surname=$rows['surname'];
$firstname=$rows['firstname'];
$claim=$rows['claim'];
$damage=$rows['damage'];
$cost=$rows['cost'];
}";
$mail->AltBody="Please Use a Html Compaible Email Veiwer";
if(!$mail->Send())
{
echo "Error sending: " . $mail->ErrorInfo;;
}
else
{
echo "Letter is sent";
}
我使用我创建的这个代码的和平来获取脚本来创建动态表,然后将其回显到电子邮件正文中 这只是一个基本的表格,但可以进行改进
$link = mysql_connect('localhost', 'root', '');
mysql_select_db('Your Dataabse name');
$sql="SELECT * FROM rep_log WHERE claim='Insurance' AND s_date = '2012-05-31'";
$result=mysql_query($sql, $link);
$table= "<table width='100%' border='3' cellspacing='0' cellpadding='0'>";
$table .="<th>Cases</th>";
$table .="<th>HG</th>";
$table .="<th>Surname</th>";
$table .="<th>FristName</th>";
$table .="<th>Claim</th>";
$table .="<th>Damage</th>";
$table .="<th>Cost</th>";
while($rows=mysql_fetch_array($result)){
$cases=$rows['cases'];
$hg=$rows['hg'];
$surname=$rows['surname'];
$firstname=$rows['firstname'];
$claim=$rows['claim'];
$damage=$rows['damage'];
$cost=$rows['cost'];
$table .="<tr>";
$table .="<td>$cases</td>";
$table .="<td>$hg</td>";
$table .="<td>$surname</td>";
$table .="<td>$firstname</td>";
$table .="<td>$claim</td>";
$table .="<td>$damage</td>";
$table .="<td>$cost</td>";
$table .="</tr>";
}
$table .="</table>";
$date=date('dmy');
require("../PHPMailer/class.phpmailer.php");
$mail = new PHPMailer();$mail = new PHPMailer();
$mail->IsSMTP(); // set mailer to use SMTP
$mail->Host = "smtp"; // specify main and backup server
$mail->From = "support@ac.vic.edu.au";
$mail->FromName = "Ict Devices";
$mail->AddAddress("gs@hum.vic.edu.au", "Matthew");
$mail->Subject = "Damage Log Report";
$mail->IsHTML(true);
$var='xlsx';
$date=date('dmy.');
$mail->Body = "$table;";
$mail->AltBody="Please Use a Html Compaible Email Veiwer";
if(!$mail->Send())
{
echo "Error sending: " . $mail->ErrorInfo;;
}
else
{
echo "Letter is sent";
}