我想從具有條件的表中獲取所有行，然后向指定的用戶發(fā)送電子郵件。表中有 2 個(gè)用戶。如果我將 sql 語(yǔ)句放在 sql 語(yǔ)句中，則它不起作用，只有第一個(gè)用戶才能收到郵件和郵件。我確信這很容易，但我是 php 和 mysql 初學(xué)者，所以請(qǐng)幫助我。表中有 2 個(gè)用戶。<?php require'../includes/database.php'; $sql = "SELECT * FROM users"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $fname = $row["fname"]; $nname = $row["lname"]; $mailadresse = $row["email"]; $user2 = $fname." ".$nname; echo $user2; $sql = "SELECT * FROM iks_open, users WHERE Datum <= '$neudate' AND pverantwortung = '$user2'"; $result = $conn->query($sql); if ($result->num_rows > 0) { $mailhost = "$server"; //SMTP Host name $mailsmtpauth = true; $mailusername = "$user"; // SMTP Login $mailpassword = "$pass"; // SMTP Password require_once('../includes/Mailer/class.phpmailer.php'); require_once('../includes/Mailer/class.smtp.php'); $mail = new PHPMailer(); $mail->IsSMTP(); $mail->Host = $mailhost; $mail->Port = $port; $mail->SMTPDebug = 1; // Kann man zu debug Zwecken aktivieren $mail->SMTPAuth = true; $mail->Username = $mailusername; $mail->Password = $mailpassword; $mail->SMTPSecure = $sec; $frommail = "$email"; $mail->SetFrom($frommail, 'IKS-System'); $address = "$mailadresse"; $mail->AddAddress($address); $mail->Subject = "Offene IKS-Aufgaben"; $mail->Body = "Sie haben offene Aufgaben. Bitte einloggen und erledigen"; if(!$mail->Send()) { $lcontact = 1; } else { $lcontact = 2; } }else { echo "Alles gut"; } } } ?>
2 回答
呼喚遠(yuǎn)方
TA貢獻(xiàn)1856條經(jīng)驗(yàn) 獲得超11個(gè)贊
您正在while 語(yǔ)句中覆蓋$result變量。小心你的變量，你不會(huì)有那樣的麻煩。
茅侃侃
TA貢獻(xiàn)1842條經(jīng)驗(yàn) 獲得超22個(gè)贊
我認(rèn)為，在 while 循環(huán)內(nèi)發(fā)生的數(shù)據(jù)庫(kù)獲取正在覆蓋 $result 對(duì)象。
嘗試這個(gè)
<?php
require'../includes/database.php';
$sql = "SELECT * FROM users";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
$fname = $row["fname"];
$nname = $row["lname"];
$mailadresse = $row["email"];
$user2 = $fname." ".$nname;
echo $user2;
$query = "SELECT * FROM iks_open, users WHERE Datum <= '$neudate' AND pverantwortung = '$user2'";
$details = $conn->query($sql);
if ($details->num_rows > 0) {
$mailhost = "$server"; //SMTP Host name
$mailsmtpauth = true;
$mailusername = "$user"; // SMTP Login
$mailpassword = "$pass"; // SMTP Password
require_once('../includes/Mailer/class.phpmailer.php');
require_once('../includes/Mailer/class.smtp.php');
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->Host = $mailhost;
$mail->Port = $port;
$mail->SMTPDebug = 1; // Kann man zu debug Zwecken aktivieren
$mail->SMTPAuth = true;
$mail->Username = $mailusername;
$mail->Password = $mailpassword;
$mail->SMTPSecure = $sec;
$frommail = "$email";
$mail->SetFrom($frommail, 'IKS-System');
$address = "$mailadresse";
$mail->AddAddress($address);
$mail->Subject = "Offene IKS-Aufgaben";
$mail->Body = "Sie haben offene Aufgaben. Bitte einloggen und erledigen";
if(!$mail->Send()) {
$lcontact = 1;
} else {
$lcontact = 2;
}
}else {
echo "Alles gut";
}
}
}
?>
- 2 回答
- 0 關(guān)注
- 216 瀏覽
添加回答
舉報(bào)
0/150
提交
取消