Ok, we've built the survey. Now how do we send it to our subscribers?
When you're ready to send the survey to your subscribers, this recipe will gather all active subscribers together, build the message, and send it.
It will then record the response for tracking so that we can see which answer is the popular choice or not.
Ok, let's send our survey to our users. In the same place you uploaded the files in the previous recipe, create a new file and name it send-survey.php:
<?php
include("config.php");
include("pdo.class.php");
include 'Services/Twilio.php';
$qid = $_GET['qid'];
$_SESSION['survey'] = $qid; // we store the survey in session so we can retrieve it later
$pdo = Db::singleton();
$client = new Services_Twilio($accountsid, $authtoken);
$survey = $pdo->query("SELECT * FROM survey WHERE ID='{$qid}'");
if( $survey->rowCount() >= 1 ){...