อยากเพิ่ม insert ตรง echo [.trim($addresses[$i]).] sending success.<br /><br />; แบบว่าถ้า success ให้insert $addresses[$i] ลงdatabaseด้วยอะคับ

for ($i=0; $i<$numOfEMail; $i++) {
	$mail->addAddress($addresses[$i]);	
	if(!$mail->Send()) {

		//check input capt with session captcha
		//if($_SESSION['captcha']!=$_POST['capt'] || $_SESSION['captcha']=='BADCODE') { 
			 //wrong captcha exit the program not continue.
			 //exit("wrong code");
			 
		//}

		//correct captcha continue program
		//echo "Excellent";
		
	
		
		echo 'Message of ['.trim($addresses[$i]).'] was not sent.<br />';
		echo 'can not sending ' . $mail->ErrorInfo . '<br /><br />';
		//break; //Abandon sending
	} else {
		echo '['.trim($addresses[$i]).'] sending success.<br /><br />';
		 
		
		$strSQL = "INSERT INTO mail1_history ";
		$strSQL .="(Mail1) ";
		$strSQL .="$addresses[$i]) ";
		$objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
	}
	
	$mail->clearAddresses();
}
echo $numOfEMail." ".($numOfEMail>1?"mails.":"mail.");

<?php
<?php
<?php

include("bar.php");
include("config.php");
require("phpmailer/class.phpmailer.php"); // path to the PHPMailer class.


//if(isset($_REQUEST['province']) && isset($_REQUEST['std_status']) && isset($_REQUEST['student_code_status']) && isset($_REQUEST['CurLevel'])){
if(isset($_POST['mydata1']) && isset($_POST['mydata2']) && isset($_POST['mydata3']) && isset($_POST['mydata4'])){
	
	$province = stripcslashes($_POST['mydata1']);
	$std_status = stripcslashes($_POST['mydata2']);
	$student_code_status = stripcslashes($_POST['mydata3']);
	$CurLevel = stripcslashes($_POST['mydata4']);
	
	
	$strCondition = "";
	if ($province != "") {
		//$strCondition .= "WHERE province = '".$province."'";
		$strCondition .= "WHERE province IN (".$province.")";
	}
	if ($std_status != "") {
		if ($strCondition != "") {
			$strCondition .= " AND std_status IN (".$std_status.")";
		} else {
			$strCondition .= "WHERE std_status IN (".$std_status.")";
		}		
	}
	if ($student_code_status != "") {
		if ($strCondition != "") {
			$strCondition .= " AND student_code_status IN (".$student_code_status.")";
		} else {
			$strCondition .= "WHERE student_code_status IN (".$student_code_status.")";
		}		
	}
	if ($CurLevel != "") {
		if ($strCondition != "") {
			$strCondition .= " AND CurLevel IN (".$CurLevel.")";
		} else {
			$strCondition .= "WHERE CurLevel IN (".$CurLevel.")";
		}		
	}
	
	//$strSQL = "SELECT * FROM v_studentmail $strCondition";
	$strSQL = "SELECT Mail1,WebMail1 FROM v_studentmail $strCondition";
    $objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
	
	
	
	
	

	
	$r = mssql_num_rows($objQuery);
	$arr = array();
	$c = 0;	
	while($objResult = mssql_fetch_array($objQuery)){
		$c++;
		//$emailStr = $c.'. '.$objResult["Mail1"].'@'.$objResult["WebMail1"];
		$emailStr = $objResult["Mail1"].'@'.$objResult["WebMail1"];
        array_push($arr, $emailStr);
		
		
		//echo $emailStr."<br />";
    }	
	
	$arrUnique = array_unique($arr);
	//$mail_to = implode(',', $arrUnique);
	//$mail_to = implode('<br />', $arrUnique);
	
    //echo $r." ".($r>0?"mails.":"mail.")."<br /><br />".$mail_to."<br /><br />".$strSQL;
	$addresses = implode('<br />', $arrUnique);
	//exit();
} else {
	exit();
}


$fm = "[email protected]"; // *** µéͧãªéÍÕàÁÅì @gmail.com à·èÒ¹Ñé¹ ***

//$to = "[email protected]"; //
//$to = "[email protected],[email protected]";
//$to = trim($_POST['mail_to']); //ÍÕàÁÅì·ÕèãªéÃѺ¢éÍÁÙŨҡẺ¿ÍÃìÁ
//$to = $_POST['mail_to']; //ÍÕàÁÅì·ÕèãªéÃѺ¢éÍÁÙŨҡẺ¿ÍÃìÁ
$custemail = $_POST['email']; // ÍÕàÁÅì¢Í§¼ÙéµÔ´µèÍ·Õè¡ÃÍ¡¼èҹẺ¿ÍÃìÁ
 
 

	
	
//$subj = $_POST['subject'];
$subj = iconv('TIS-620','UTF-8', $_POST['mydata6']);
$msg = stripcslashes($_POST['mydata7']);
$msgUTF8 = iconv('TIS-620','UTF-8', $msg);


// ------------------------------------------------------------------------------------------------------------- //
//$message.= "ª×èÍ-¹ÒÁÊ¡ØÅ: ".$_POST['name']."\n";
$text1 = iconv('TIS-620','UTF-8',"ÍÕàÁÅì: ");
$text2 = iconv('TIS-620','UTF-8',"ËÑÇ¢éÍ: ");
$text3 = iconv('TIS-620','UTF-8',"ÃÒÂÅÐàÍÕ´: ");
$message.= $text1."".$_POST['mydata5']."\n";
//$message.= "to".$_POST['togo']."\n";
$message.= $text2."".$subj."\n";
$message.= $text3."".$msgUTF8."\n";
// ------------------------------------------------------------------------------------------------------------- //


 
$mesg = $message;

//echo "messages = ".$mesg."<br /><br />";

//echo iconv('UTF-8', 'TIS-620',$mesg);
//exit();

$mail = new PHPMailer();
$mail->CharSet = "utf-8"; 
 
/* ------------------------------------------------------------------------------------------------------------- */
/* µÑ駤èÒ¡ÒÃÊè§ÍÕàÁÅì â´Âãªé SMTP ¢Í§ Gmail */
$mail->IsSMTP();
$mail->Mailer = "smtp";
//$mail->IsSMTP(); // telling the class to use SMTP
$mail->SMTPAuth     = true;                  // enable SMTP authentication
$mail->SMTPKeepAlive = true; // SMTP connection will not close after each email sent, reduces SMTP overhead
$mail->SMTPSecure  = "ssl";                 // sets the prefix to the servier
$mail->Host             = "smtp.gmail.com";      // sets GMAIL as the SMTP server
$mail->Port              = 465;                   // set the SMTP port for the GMAIL server
$mail->Username      = "[email protected]";  // Gmail Email username
$mail->Password       = "thekop@1";            // Gmail Email password
/* ------------------------------------------------------------------------------------------------------------- */
//echo "AAA"; 
$mail->From = $fm;




//$mail->AddAddress($to);
$mail->AddReplyTo($custemail);
$mail->Subject = $subj;
$mail->Body = $mesg;
$mail->isHTML(true);
$mail->WordWrap = 50;  
//

$addresses = array();
array_push($addresses, "[email protected]");
$numOfEMail = count($addresses);



for ($i=0; $i<$numOfEMail; $i++) {
	$mail->addAddress($addresses[$i]);	
	if(!$mail->Send()) {

		
	
		
		echo 'Message of ['.trim($addresses[$i]).'] was not sent.<br />';
		echo 'can not sending ' . $mail->ErrorInfo . '<br /><br />';
		//break; //Abandon sending
	} else {
		echo '['.trim($addresses[$i]).'] sending success.<br /><br />';
		 
		$strSQL = "INSERT INTO mail1_history ";
		$strSQL .="(Mail1) ";
		$strSQL .="values( $addresses[$i] ) ";
		
	}
	//correct is notepad
	$mail->clearAddresses();
}
echo $numOfEMail." ".($numOfEMail>1?"mails.":"mail.");

?>

		echo 'Message of ['.trim($addresses[$i]).'] was not sent.<br />';
		echo 'can not sending ' . $mail->ErrorInfo . '<br /><br />';
		//break; //Abandon sending
	} else {
		echo '['.trim($addresses[$i]).'] sending success.<br /><br />';
		 
		$strSQL = "INSERT INTO mail1_history ";
		$strSQL .="(Mail1) ";
		$strSQL .="values( $addresses[$i] ) ";
	 //mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
	  $objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
		
	}
	//correct is notepad
	$mail->clearAddresses();
}
echo $numOfEMail." ".($numOfEMail>1?"mails.":"mail.");