我使用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查询!否则你很快就会被黑。