从php中获取数据库中的电子邮件列表[复制]

Question

This question already has an answer here:

• MySQL returns only one row 5 answers

Can Anyone help me with this

SELECT userEmail FROM users in mysql gets a email list like
userEmail
[e-mail]
[e-mail]

Currently $userEmail gets first email from the list
[e-mail]
I am trying to get email list from database like
[e-mail],[e-mail]

    <?php

    $mailselect = "SELECT userEmail FROM users";
    $mailselect2 = mysqli_query($mysqli, $mailselect) or die('-31' . mysqli_error());
    $recipients = mysqli_fetch_assoc($mailselect2);
    $userEmail = $recipients['userEmail'];    
   $recipientss = array(',', $row['recipients'] );    
    $to = '[e-mail]';
    $subject = "E-mail subject";
    $message = 'Testing1: ' . $userEmail . "
" .
               'Testing2: ' .  implode(',', $recipientss);
    $headers = 'From: [e-mail]' . "
" ;
    $headers .= 'Reply-To: [e-mail]' . "
";

    mail($to, $subject, $message, $headers);

    ?>

Currently mail() function sends this email Testing1: [e-mail] Testing1:

implode(',', $recipientss); This code might be a problem. Anyone with some sugestion

Thanks Guys.

</div>

Answer 1

http://php.net/manual/en/mysqli-result.fetch-assoc.php

Fetch a result row as an associative array

Usage for multiple rows:

$emails = [];
while ($row = mysqli_fetch_assoc($mailselect2)) {
    $emails[]=$row['userEmail'];
}

Then $emails is an array filled with the email addresses, you can implode it.