php - 更新sql表时递归发送电子邮件

Question

我有以下查询:

UPDATE
    users AS t
    LEFT JOIN (
        SELECT
          user
        FROM
               facebook, users
        WHERE
            facebook.user = users.id
        GROUP BY
           users.id
    ) AS m ON
        m.user = t.id
SET
   t.coins =t.coins+200
WHERE
  m.user = t.id

我需要帮助来创建一个 php 脚本，该脚本实际上必须向我更新硬币数量的用户发送电子邮件。电子邮件字段位于用户表中。

谢谢!

Answer 1

选择您需要的所有行:

SELECT
t.id, t.email
FROM
    users AS t
    LEFT JOIN (
        SELECT
          user
        FROM
               facebook, users
        WHERE
            facebook.user = users.id
        GROUP BY
           users.id
    ) AS m ON
        m.user = t.id
WHERE
  m.user = t.id

然后更新 PHP 循环中的每一行，您也可以在其中发送邮件。

更新

因此，假设 $result 是带有结果数组的 var。

foreach($result as $res){
    $sql = 'UPDATE users SET coins = coins+200 WHERE id = '.$res['id'];
    mail(/*WITH YOUR PARAMS*/); //email in $res['email'];
}