php – 使用Twilio接收SMS并将其存储在数据库中

这是一个相关的引用：

When Twilio receives a message for one of your Twilio numbers it makes
a synchronous HTTP request to the message URL configured for that
number,and expects to receive TwiML in response. Twilio sends the
following parameters with its request as POST parameters or URL query
parameters,depending on which HTTP method you’ve configured.

您应该只在PHP的$_REQUEST []变量中包含数据字段.

$_REQUEST [‘MessageSid’] – 消息的34个字符唯一标识符.可用于稍后从REST API检索此消息.

$_REQUEST [‘SmsSid’] – 与MessageSid值相同.为了向后兼容而弃用并包含在内.

$_REQUEST [‘AccountSid’] – 与此消息关联的帐户的34个字符ID.

$_REQUEST [‘From’] – 发送此消息的电话号码.

$_REQUEST [‘To’] – 收件人的电话号码.

$_REQUEST [‘Body’] – 消息的文本正文.最多1600个字符.

$_REQUEST [‘NumMedia’] – 与您的消息关联的媒体项目数

以下是您可能与MySQL数据库一起使用的示例查询.您还应该向Twilio发回适当的TWIXML响应,并在运行此类查询之前清理接收到的数据.

$sql = "INSERT INTO messages (sid,from,body) 
        VALUES (
                 '".$_REQUEST['MessageSid']."','".$_REQUEST['From']."','".$_REQUEST['Body']."'
               )";