- Posts: 62
- Thank you received: 3
Ask the community, share ideas, and connect with other LimeSurvey users!
$myJSONRPCClient->export_responses_by_token($sSessionKey,$iSurveyID,$sDocumentType,$sToken,$sLanguageCode,$sCompletionStatus,$sHeadingType,$sResponseType);
$sDocumentType = 'json'; //pdf, csv, xls, doc, json $sLanguageCode = 'en'; $sCompletionStatus = 'complete'; // 'incomplete' or 'all' -- default: 'all' $sHeadingType = 'code'; // 'full' or 'abbreviated' -- default: 'code' $sResponseType = 'short'; // or 'long' -- default: 'short' $iFromResponseID = 10; $iToResponseID = 18; //(see get_response_ids() for range of possible ids) $aFields = array( 'id', '171768X29X1042','submitdate', '171768X7X42', '171768X7X44', '171768X7X45', '171768X7X1257', '171768X7X1258', '171768X7X1259', '171768X7X1260', '171768X7X1261', '171768X7X1262' ); $responses = $myJSONRPCClient->export_responses( $sSessionKey, $sid, $sDocumentType, $sLanguageCode, $sCompletionStatus, $sHeadingType, $sResponseType, $iFromResponseID, $iToResponseId, $aFields); // convert and echo to screen to review $strDecoded = base64_decode( $responses ); $res_json = json_decode($strDecoded); echo '<pre>'; print_r($res_json); echo '</pre>';
$fields = "71768X7X42 AS C1A, 71768X7X44 AS C1B, 71768X7X45 AS C1C, 71768X7X1257 AS C2A, 71768X7X1258 AS C2B, 71768X7X1259 AS C2C, 71768X7X1260 AS C3A, 71768X7X1261 AS C3B, 71768X7X1262 AS C3C"; $sql = "SELECT $fields FROM lime_survey_71768 WHERE id=14"; $result = $mysqli->query($sql) or $myError = $mysqli->error.__LINE__; if ( $result->num_rows > 0 ) { $row = $result->fetch_assoc(); echo '<pre>'; print_r($row); echo '</pre>'; } else { echo '<em>Error</em>'; }