我使用mailgun api中的webhooks来通知我何时发送了电子邮件。
我使用requestbin服务查看正在发送的数据:

domain: domain.com
token: 6o02nxnu-7grjkvkzxdyn2lsm0w7fagidgxzon8-cucz8u15w0
signature: a4d27e390495691fb4b8fb76b3b8a71c90cf8cd467140f5c3d36e023ec343e5c
Message-Id: <20140721155006.120305.72293@domain.com>
timestamp: 1405957808
X-Mailgun-Sid: WyJjZjMyNCIsICJjaHJpc3NlY2tsZXJAZ21haWwuY29tIiwgIjAxNzBiNSJd
message-headers: [["Received", "by luna.mailgun.net with HTTP; Mon, 21 Jul 2014 15:50:06 +0000"], ["Content-Type", ["multipart/alternative", {"boundary": "21586684bc984a0cbc485d4a862fc34c"}]], ["Mime-Version", "1.0"], ["Subject", "Please Check Your Account"], ["From", "Sender Name <testemail@domain.com>"], ["To", "Chris <anotheremail@gmail.com>"], ["X-Mailgun-Sid", "WyJjZjMyNCIsICJjaHJpc3NlY2tsZXJAZ21haWwuY29tIiwgIjAxNzBiNSJd"], ["Date", "Mon, 21 Jul 2014 15:50:08 +0000"], ["Sender", "testemail@domain.com"]]
recipient: email@domain.com
event: delivered

我现在试图使用他们通过post数组发送的信息,并将其插入到我的数据库中。
我可以直接从发送的post数组中获取以下变量:
$recipient_email = $_POST['recipient']; //This works
$timestamp = $_POST['timestamp']; //This works

我无法直接从post数组获取以下变量。它们位于我不熟悉的“消息头”变量中的数据类型中。我怎样才能拿到这些?
$sender_name = ?;
$sender_email = ?;
$recipient_name = ?;
$subject = ?;

$sql = 'INSERT into mail SET
        from_name = "'.$sender_name.'",
        from_email = "'.$sender_email.'",
        to_name = "'.$recipient_name.'",
        to_email = "'.$recipient_email.'",
        subject = "'.$subject.'",
        date = "'.$timestamp.'"';

$result = $conn->query($sql) or die(mysqli_error($conn));

最佳答案

好吧,message-headers是一个数组。对于每个子数组,第一项(键0)是“标签”,第二项(键1)是“值”。所以你可以这样做:

foreach ($POST['message-headers']} as $i => $header) {
    switch( $header[0] ) {
        case 'Subject'
            $subject = $header[1];
            break;
        case 'Sender'
            $sender_email = $header[1];
            break;
        /* Any other cases that I'm too lazy for now ...*/
    }
}

(虽然构建一个$header[0]与变量名的映射,然后简单地循环而不使用switch可能更容易阅读,但这只是我的品味。)
但是请参数化SQL查询!否则你很快就会被黑。

09-10 05:10
查看更多