I'm trying to understand how the trigger callbacks work. I have a trigger on a place with a callback url that I'm trying to record the json that is passed to it. The actual callback is working (I can run it with trigger/run/:id) but I'm not understanding how the json is passed to the callback. I would like to take some of the info from the json and record it to a db. The php code looks something like this:
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// Grabs the json here
$request_body = file_get_contents('php://input');
$json = json_decode($request_body, true);
$name = $json["post"]["user"]["user_id"];
$sql = "INSERT INTO table1 VALUES (NULL, '$name')";
mysqli_query($con,$sql);
$result = mysqli_query($con,"SELECT * FROM table1");
while($row = mysqli_fetch_array($result))
{
echo $row['id'] . ". User: " . $row['username'];
echo "<br>";
}
mysqli_close($con);
I'm assuming when the trigger is run, the json is passed to the callback but I'm not getting any records showing. Any help understanding how it works is appreciated!