如何让php在循环外回显值？

Question

I want to be able to put the name of the person in the email. But I don't know how to retain the value outside the loop. Also, I'm wondering if this will work if there is more than one result.

Here is the php:

// WHO HAS BEEN A MEMBER FOR ONE YEAR
function joinDateFilter(){
    $query = mysql_query("SELECT * FROM user WHERE date_joined = DATE_SUB(curdate(), INTERVAL 1 YEAR)");
    $mail_to = "";
    while ($row = mysql_fetch_array($query)){
        echo $row['name']." - ".$row['email']."
";
        $mail_to = $row['email'].", ";
        $name = $row['name'];
    }
    if (!empty($mail_to)){
        sendEmail($mail_to);
    }
}

// SEND EMAIL
function sendEmail($mail_to) {
    $from    = "[e-mail]";
    $message = "Happy Anniversary!";
    $headers = 'From: '.$from."
" .
    'Reply-To:'.$_POST['email']."
" .
    "Content-Type: text/html; charset=iso-8859-1
".
    'X-Mailer: PHP/' . phpversion();
    mail($mail_to, "Congratulations ".$name."!", $message, $headers);
}

In that example above, the mail never reads their name, as the value seems to be forgotten outside of the while loop. Can someone help me?

Answer 1

Currently, your code overwrites the email id stored in $mail_to in each iteration of the while loop. So, it will have only the email id of the last user. And you need name of each user (stored in $name and used in the function). You need to send the email whenever a user is found. Try this:

// WHO HAS BEEN A MEMBER FOR ONE YEAR
function joinDateFilter(){
    $query = mysql_query("SELECT * FROM user WHERE date_joined = DATE_SUB(curdate(), INTERVAL 1 YEAR)");
    while ($row = mysql_fetch_array($query)){
        echo $row['name']." - ".$row['email']."
";
        $mail_to = $row['email'];
        $name = $row['name'];
        if (!empty($mail_to))
            sendEmail($mail_to, $name);
    }
}

// SEND EMAIL
function sendEmail($mail_to, $name) {
    $from    = "[e-mail]";
    $message = "Happy Anniversary!";
    $headers = 'From: '.$from."
" .
    'Reply-To:'.$_POST['email']."
" .
    "Content-Type: text/html; charset=iso-8859-1
".
    'X-Mailer: PHP/' . phpversion();
    mail($mail_to, "Congratulations ".$name."!", $message, $headers);
}