Webhook

<?php


require_once('db_connect.php');

$rest_json = file_get_contents("php://input");
$str = json_decode($rest_json, true);

if ($str['event'] == 'request'){
    mysql_query('UPDATE '. mysql_real_escape_string($newsletter_table) .' SET statut="3" WHERE email="'. $str['email'] .'"') or die('Erreur mysql');
}
else if($str['event'] == 'delivered'){
    mysql_query('UPDATE '. mysql_real_escape_string($newsletter_table) .' SET statut="1" WHERE email="'. $str['email'] .'"') or die('Erreur mysql');
}