[MySQL][PHP]Pętla w phpmailer Opcje

[ufo1990]

Mam problem z PHPMailer ponieważ chcę wysłać wiadomości do wszystkich użytkowników z bazy danych i to działa jednak pętla nie działa do "$mail->Subject" oraz "$mail->Body". Ktoś coś doradzi, pomoże ?

[PHP] pobierz, plaintext 
	require_once "connect.php";
	$connect = @new mysqli($host, $db_user, $db_password, $db_name); 
	$result = $connect->query("Select Group_concat(name SEPARATOR ',') as names, Group_concat(email SEPARATOR ',') as emails from persons");
	if($result->num_rows > 0)
	{
		while($row = $result->fetch_assoc())
		{
			$name_explode = explode(",",$row['names']);
			$email_explode = explode(",",$row['emails']);
 
			require "PHPMailer/PHPMailerAutoload.php";
 
			$mail = new PHPMailer();
			$mail->CharSet = "UTF-8";
			$mail->IsSMTP();
			$mail->SMTPAuth = true; 					
 
			$mail->SMTPSecure = 'ssl'; 
			$mail->Host = '**********';
			$mail->Port = 465;  
			$mail->Username = '**********';
			$mail->Password = '**********';   
 
			$mail->IsHTML(true);
			$mail->From='**********';
			$mail->FromName='**********';
 
			$mail->AddReplyTo('**********');
 
			for ($i=0; $i< count($name_explode); $i++) 
			{
				$mail->Subject = $name_explode[$i];
				$mail->Body = "Witaj$name_explode[$i]";
				$mail->AddAddress($email_explode[$i], $name_explode[$i]);
			}	
			if(!$mail->Send()) 
			{
				echo "Wiadomość nie wysłana: " . $mail->ErrorInfo;
			} 
			else 
			{
				echo "Wiadomość wysłana!";
			}
			$mail->clearAllRecipients();	
		}	
	}
	$connect->close();
[PHP] pobierz, plaintext 

[LowiczakPL]

tak poza pętlą powinien być mailer

[PHP] pobierz, plaintext 
    	require_once "connect.php";
        require "PHPMailer/PHPMailerAutoload.php";
 
    	$mail = new PHPMailer();
    	$mail->CharSet = "UTF-8";
    	$mail->IsSMTP();
    	$mail->SMTPAuth = true; 					
     	$mail->SMTPSecure = 'ssl'; 
 	$mail->IsHTML(true);
    	$mail->Host = '**********';
    	$mail->Port = 465;  
    	$mail->Username = '**********';
    	$mail->Password = '**********';   
 
    	$connect = @new mysqli($host, $db_user, $db_password, $db_name); 
    	$result = $connect->query("Select Group_concat(name SEPARATOR ',') as names, Group_concat(email SEPARATOR ',') as emails from persons");
    	if($result->num_rows > 0)
    	{
    		while($row = $result->fetch_assoc())
    		{
    			$name_explode = explode(",",$row['names']);
    			$email_explode = explode(",",$row['emails']);
 
 
    			$mail->From='**********';
    			$mail->FromName='**********';
    			$mail->AddReplyTo('**********');
 
    			for ($i=0; $i< count($name_explode); $i++) 
    			{
    				$mail->Subject = $name_explode[$i];
    				$mail->Body = "Witaj $name_explode[$i]";
    				$mail->AddAddress($email_explode[$i], $name_explode[$i]);
    			}	
    			if(!$mail->Send()) 
    			{
    				echo "Wiadomość nie wysłana: " . $mail->ErrorInfo;
    			} 
    			else 
    			{
    				echo "Wiadomość wysłana!";
    			}
    			$mail->clearAllRecipients();	
    		}	
    	}
    	$connect->close();
[PHP] pobierz, plaintext 

Ten post edytował LowiczakPL 19.05.2021, 07:13:46