用PHP发送电子邮件，其中包含从数据库中获取的信

Question

I want to pull an email from the database as the recipient. If I replace the line "SELECT student_user_email FROM students";' with an actual email address I get the desired outcome. However it would be handier to pull a particular email address from the 'students' table. Below is the current code. Wondering if anyone can help?

mail('"SELECT student_user_email FROM students";','Sample Form',$msg, 'From: [e-mail]');

Answer 1

You can't send email to a multiple recipients in this way. Because query return array list so you must be looping and send email one by one recipients by this following way,

Try this will work:

<?php
    $con = mysqli_connect("localhost", "uname", "password");
    if (!$con){
      die('Could not connect: ' . mysqli_error());
    }

    $db_selected = mysqli_select_db("database",$con);
    $sql = "SELECT student_user_email FROM students";
    $result = mysqli_query($sql,$con);

    while ($row_data = mysqli_fetch_array($result)) {

        // Then you will set your variables for the e-mail using the data 
        // from the array.

        $from = '[e-mail]';
        $to = $row_data['email']; // The column where your e-mail was stored.
        $subject = 'Sample Form';
        $msg = 'Hello world!';
        mail($to, $subject, $msg, $from);
    }
?>