接收 webhook 数据并将它们保存在 db 中 [英] Receiving webhook data and save them in db

问题描述

我想处理由 trello webhook 发送的数据.用于 webhook 发布到像 site.com/tracker.php 之类的网址

I want to handle data, that is sended by a trello webhook. There for the webhook posts to a url like site.com/tracker.php

在 tracker.php 中，我想将数据保存在数据库中.为此，我需要获取一些参数.

In the tracker.php I want to save the data in a database. For that I need to get some params.

这是我收到的代码示例 (https://trello.com/docs/开始/webhooks.html):

This is a example of the code I receive (https://trello.com/docs/gettingstarted/webhooks.html):

{
   "action": {
      "id":"51f9424bcd6e040f3c002412",
      "idMemberCreator":"4fc78a59a885233f4b349bd9",
      "data": {
         "board": {
            "name":"Trello Development",
            "id":"4d5ea62fd76aa1136000000c"
         },
         "card": {
            "idShort":1458,
            "name":"Webhooks",
            "id":"51a79e72dbb7e23c7c003778"
         },
         "voted":true
      },
      "type":"voteOnCard",
      "date":"2013-07-31T16:58:51.949Z",
      "memberCreator": {
         "id":"4fc78a59a885233f4b349bd9",
         "avatarHash":"2da34d23b5f1ac1a20e2a01157bfa9fe",
         "fullName":"Doug Patti",
         "initials":"DP",
         "username":"doug"
      }
   },
   "model": {
      "id":"4d5ea62fd76aa1136000000c",
      "name":"Trello Development",
      "desc":"Trello board used by the Trello team to track work on Trello.  How meta!\n\nThe development of the Trello API is being tracked at https://trello.com/api\n\nThe development of Trello Mobile applications is being tracked at https://trello.com/mobile",
      "closed":false,
      "idOrganization":"4e1452614e4b8698470000e0",
      "pinned":true,
      "url":"https://trello.com/b/nC8QJJoZ/trello-development",
      "prefs": {
         "permissionLevel":"public",
         "voting":"public",
         "comments":"public",
         "invitations":"members",
         "selfJoin":false,
         "cardCovers":true,
         "canBePublic":false,
         "canBeOrg":false,
         "canBePrivate":false,
         "canInvite":true
      },
      "labelNames": {
         "yellow":"Infrastructure",
         "red":"Bug",
         "purple":"Repro'd",
         "orange":"Feature",
         "green":"Mobile",
         "blue":"Verified"
      }
   }
}

这是我当前的 tracker.php 文件:

And this is my current tracker.php file:

<?php

$json = $_POST["actions"];
$action = json_decode($json);
$action_id = $action->id;
$card_id = $action->data->card->id;
var_dump($array);

我的问题:

• $_POST["actions"] 对吗?或者我在 []
里面需要什么
• 我想要获取 $action->data->card->id 的方式对吗?
• 有没有办法查看var_dump的结果?不知道如何查看 webhook 帖子的结果..

推荐答案

我不得不使用这个:

$json = file_get_contents('php://input');
$action = json_decode($json, true);

据我了解，json 请求不会自动拆分为 $_POST.因此，您必须使用输入本身.

As far as I understand the json request is not automaticly split into the $_POST. Thus you have to use the input itself.

需要 json_decode 中的 true 参数来获取关联数组.没有它，我只有一个空数组.

The true-parameter in json_decode is needed to get an associative array. Without it I only got an empty array.

这篇关于接收 webhook 数据并将它们保存在 db 中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！