habe soeben den PHPMailer der dabei ist aktiviert und das angefuegte Beispiel:
Code: Alles auswählen
<?php
$mail = new rex_mailer();
$sql = new rex_sql();
$query = "SELECT full_name, email, photo FROM employee WHERE id=$id";
$sql->setQuery($query);
for($i = 0; $i < $sql->getRows(); $i++)
{
// HTML body
$body = "Hello <font size=\"4\">" . $sql->getValue("full_name") . "</font>, <p>";
$body .= "<i>Your</i> personal photograph to this message.<p>";
$body .= "Sincerely, <br />";
$body .= "phpmailer List manager";
// Plain text body (for mail clients that cannot read HTML)
$text_body = "Hello " . $sql->getValue("full_name") . ", \n\n";
$text_body .= "Your personal photograph to this message.\n\n";
$text_body .= "Sincerely, \n";
$text_body .= "phpmailer List manager";
$mail->Body = $body;
$mail->AltBody = $text_body;
$mail->AddAddress($sql->getValue("email"), $sql->getValue("full_name"));
$mail->AddStringAttachment($sql->getValue("photo"), "YourPhoto.jpg");
if(!$mail->Send())
echo "There has been a mail error sending to " . $sql->getValue("email") . "<br>";
// Clear all addresses and attachments for next loop
$mail->ClearAddresses();
$mail->ClearAttachments();
$sql->next();
}
?>
Und was rauskommt ist NUR Schrott ... auf meiner Seite sehe ich:
Code: Alles auswählen
<?php = new abc_mailer();
SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’
ORDER BY abc_bierw_01article_slice.re_article_slice_id = new abc_sql(); = “SELECT full_name, email, photo FROM employee WHERE id=”; SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->setQuery();
for(2 = 0; 2 < SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’
ORDER BY abc_bierw_01article_slice.re_article_slice_id->getRows(); 2++) { // HTML body = “Hello “ . SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->getValue(“full_name”) . “,
“; .= “Your personal photograph to this message.
“; .= “Sincerely, “; .= “phpmailer List manager”; // Plain text body (for mail clients that cannot read HTML) = “Hello “ . SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->getValue(“full_name”) . “,
“; .= “Your personal photograph to this message.
“; .= “Sincerely,
“; .= “phpmailer List manager”;
->Body = ; ->AltBody = ; ->AddAddress(SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->getValue(“email”), SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->getValue(“full_name”)); ->AddStringAttachment(SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->getValue(“photo”), “YourPhoto.jpg”); if(!->Send()) echo “There has been a mail error sending to “ . SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->getValue(“email”) . “
“; // Clear all addresses and attachments for next loop ->ClearAddresses(); ->ClearAttachments(); SELECT abc_bierw_01module.id, abc_bierw_01module.name, abc_bierw_01module.ausgabe, abc_bierw_01module.eingabe, abc_bierw_01article_slice.*, abc_bierw_01article.re_id FROM abc_bierw_01article_slice LEFT JOIN abc_bierw_01module ON abc_bierw_01article_slice.modultyp_id=abc_bierw_01module.id LEFT JOIN abc_bierw_01article ON abc_bierw_01article_slice.article_id=abc_bierw_01article.id WHERE abc_bierw_01article_slice.article_id=‘22’ AND abc_bierw_01article_slice.clang=‘0’ AND abc_bierw_01article.clang=‘0’ ORDER BY abc_bierw_01article_slice.re_article_slice_id->next(); }
?>
Eigentlich will ich ein Mailformular aller Name, Email, Text - fertig. Vielleicht ein Captcha.
Kriegt man das irgendwie hin oder ist das kompliziert?!
Im Wiki steht so fast nix und in der Doku nur sinnloses zum Thema.
Sebastian