时间戳

首页 > 解决方案 > 向 $row_data['email'] 发送电子邮件

php - 向 $row_data['email'] 发送电子邮件

问题描述

我有用户验证页面，管理员可以在其中批准或不批准用户。所有这些代码都运行良好，但除了电子邮件部分，一旦管理员批准用户帐户......用户假设收到一封电子邮件通知。用户的电子邮件地址应取自数据库。

<?php
    include('../setting/config.php');
    $id = $_GET['id'];
    $query = "select * from `register_requests` where `id` = '$id'; ";
    if(count(fetchAll($query)) > 0){
        foreach(fetchAll($query) as $row){
            $email = $row['email'];
            $level = $row['level'];
            $username = $row['username'];
            $password = $row['password'];
            $query = "INSERT INTO `registered_accounts` (`id`, `email`, `level`, `username`, `password`) VALUES (NULL, '$email', '$level', '$username', '$password');";
        }
        $query .= "DELETE FROM `register_requests` WHERE `register_requests`.`id` = '$id';";
        if(performQuery($query)){
            echo "<script>alert('This account has been approved');window.location.href='View_Users.php';</script>";
        }
         $sql = "SELECT email FROM register_requests";
    $result = mysqli_query($conn,$sql);

        while ($row_data = mysqli_fetch_array($result)) {
        $from = 'emarketing.unisel.faudzi.info';
        $to = $row_data['email']; 
        $subject = 'Sample Form';
        $msg = 'Hello world!';
        mail($to, $subject, $msg, $from);
        
    }
}
    
?>

请在这方面提供帮助。谢谢你。

标签： phphtmlmysql

解决方案

代替

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

利用

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

推荐阅读