Adding tracking for each user_Twilio Cookbook（Second Edition）-QQ阅读男生历史网

书名：Twilio Cookbook（Second Edition）
作者名：Roger Stringer
本章字数：239字
更新时间：2021-07-16 12:06:39

Adding tracking for each user

We want to be able to track each user's response to the survey we sent and this is how we will do that.

In the previous recipe, we stored the phone number, survey ID, and the unique session ID for each person we sent the survey to.

Now we want to store each user's response for tracking later.

Getting ready

The complete source code for this recipe can be found in the Chapter3/ folder.

How to do it...

Let's set up tracker.php that listens for responses from our subscribers using the following steps:

On your web server, create a file and name it tracker.php with the following code:

<?php
include("config.php");
include("pdo.class.php");
$pdo = Db::singleton();
if( isset($_POST['Body']) ){
  $phone = $_POST['From'];
  $phone = str_replace('+','',$phone);
  $action = strtolower($_POST['Body']);
  $sid = $_POST['SmsSid'];
  $sql = "UPDATE responses SET answer='{$action}' WHERE phone_number='{$phone}' AND sms_sid='{$sid}'";
  $pdo->exec( $sql );
  $msg = "Your answer has been recorded";
  print_sms_reply($msg);
}
function print_sms_reply ($sms_reply){
  echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";    
  echo "<Response>\n<Sms>\n";
  echo $sms_reply;
  echo "</Sms></Response>\n";
}
?>

Finally, you have to point your Twilio phone number to it.

Insert the URL to this page in the SMS Request URL box. Then, any calls that you receive on this number will be processed via tracker.php.

How it works...

When a user replies to a survey, the tracker.php file is triggered.

We then perform a look-up based on their phone number and unique session ID and store their response in the Responses table.

Then, when we display the results later, we can use the responses, associate them with the answers we sent, and get a look at what people think.

本周热推：

Getting Started with tmux Moodle for Mobile Learning Professional Scala Learning iBeacon Twilio Cookbook