Cannot redeclare Send_mail() error

Question

I m trying to make a function which can check the database for active customer whose status is 1 if active, they should receive email. For Email Functionality I had used PHP Mailer function.

Below is my script:

<?php
include '../mailer/class.phpmailer.php';
$sqlx = mysql_query("SELECT * from `cust");

$numRows = mysql_num_rows($sqlx);
$mail_body = '';
while($row = mysql_fetch_array($sqlx))
{
// fetch email

$uid = $row["uid"];
$email = $row["email"];

$count = "20";
if($count <= '70')
{
$f_name = "abc";
$f_email = "abc@xyz.com";
$mail_body = "Hii message";
$subject = "Hi you got notificaiton";
$headers  = "From: abc <abc@xyz.com>";
$headers .= "Content-type: text/html\r\n";

function Send_mail($email, $subject, $headers, $mail_body, $f_email, $f_name)
{
 $mail = new PHPMailer(); 
 $Email = $email;
 $fname = $f_name;
 $femail = $f_email; 
 //==================smtp mail ===============================//
 $mail->IsSMTP(); // telling the class to use SMTP
 $mail->SMTPAuth = true;
 $mail->Port= 25; //  Sets the default SMTP server port.
 $mail->SMTPSecure= 'tls'; //  Options are "", "ssl" or "tls"
 $mail->Host = 'localhost'; // SMTP server 
 $mail->Username = 'abc@xyz.com';  // Sets SMTP username. 
 $mail->Password = '1234556';  //Sets SMTP password. 
 //=========================================================// 
  
 $fname = $f_name;
 $femail = $f_email;       // email address of reciever 
 $mail->WordWrap = 50;                              // set word wrap 
 $mail->IsHTML(true);                               // send as HTML  
 $mail->Subject  =  $subject;      // subject of mail 
 $mail->Body     =  $mail_body;      // body of mail  
 $mail->Send();   return true;
}

$mail_result=Send_Mail($email, $subject, $headers, $mail_body,$f_email, $f_name);


}

}

?>

But i getting error:

You must provide at least one recipient email address. Fatal error: Cannot redeclare Send_mail() (previously declared in C:\xampp\htdocs\testing\update.php:161) in C:\xampp\htdocs\testing\update.php on line 161

Answer 1

check your cust table there must be entered email address on which you are trying to send email. And change your

$mail->Port= 587; 
$mail->SMTPSecure= 'tls'; 
$mail->Host = 'smtp.gmail.com'; 
$mail->Username = 'abc@gmail.com';//Valid Gmail address 
$mail->Password = '1234556';//Gmail password

if still getting error you can go to your gmail account setting and allow for secure app authentication.

Answer 2

take your function outside of loop.Change your code structure to this.

function Send_mail($email, $subject, $headers, $mail_body, $f_email, $f_name)
        {
            ................//code
            $mail->Send();          return true;
        }


     while($row = mysql_fetch_array($sqlx))//use mysqli or PDO
        {
       .......//code
        if($count <= '70')
         {
        .......//code
        $mail_result=Send_mail($email, $subject, $headers, $mail_body,$f_email, $f_name);
        }
        }

Answer 3

Put your function outside of the loop. Here is the code structure:

<?php
include '../mailer/class.phpmailer.php';
function Send_Mail($email, $subject, $headers, $mail_body, $f_email, $f_name)
{
    $mail = new PHPMailer(); 
    $Email = $email;
    $fname = $f_name;
    $femail = $f_email; 
    //==================smtp mail ===============================//
    $mail->IsSMTP(); // telling the class to use SMTP
    $mail->SMTPAuth = true;
    $mail->Port= 25; //  Sets the default SMTP server port.
    $mail->SMTPSecure= 'tls'; //  Options are "", "ssl" or "tls"
    $mail->Host = 'localhost'; // SMTP server   
    $mail->Username = 'abc@xyz.com';  // Sets SMTP username.    
    $mail->Password = '1234556';  //Sets SMTP password. 
    //=========================================================//   

    $fname = $f_name;
    $femail = $f_email;     // email address of reciever    
    $mail->WordWrap = 50;   // set word wrap    
    $mail->IsHTML(true);    // send as HTML     
    $mail->Subject  =  $subject;// subject of mail  
    $mail->Body     =  $mail_body;  // body of mail     
    $mail->Send();          
    return true;
}




$sqlx = mysql_query("SELECT * from `cust");

$numRows = mysql_num_rows($sqlx);
$mail_body = '';
while($row = mysql_fetch_array($sqlx))
{
// fetch email

$uid = $row["uid"];
$email = $row["email"];

$count = "20";
if($count <= '70')
{
$f_name = "abc";
$f_email = "abc@xyz.com";
$mail_body = "Hii message";
$subject = "Hi you got notificaiton";
$headers  = "From: abc <abc@xyz.com>";
$headers .= "Content-type: text/html\r\n";
$mail_result=Send_Mail($email, $subject, $headers, $mail_body,$f_email, $f_name);


}

}       

?>