I think I would like to generate a human readable table automatically from the database.
Why didn't you say this right at the start?
I thought you want to ease some queries developping some kind of dashboard or similar things.
Only to get a response table, use the API.
Here a rough example without any styling of the table.
Either with full header
or short header
Here the main part of the API script (in php)
Code:
/* Get the responses */
$response = $myJSONRPCClient->export_responses(
$sessionKey,
$survey_id,
'json', // Document type : pdf,csv,xls,doc,json
null, // Language code : null : default from survey
'complete', // Stautus complete|incomplete|all
'full', // Heading : code|full|abbreviated : question text, default code
'long', // answer : short|long , default : long
1, // First exported SAVEDID or NULL
100 // Last exported SAVEDID or NULL
);
$decodedString = base64_decode($response);
$aResponses = json_decode($decodedString, True);
// Find the first response ID
$aFirstResponse = $aResponses['responses'][0];
echo '<table style="border-collapse: collapse; text-align: left;">';
echo '<tr>';
// Insert column headers
foreach($aFirstResponse as $key => $value) {
echo '<th style="border: 1px solid #CCC; padding: 2px 7px;">'.$key .'</th>';
}
echo '</tr>';
foreach($aResponses['responses'] as $key => $row) {
echo '<tr>';
// Insert the data
foreach($row as $key => $item) {
echo '<td style="border: 1px solid #CCC; padding: 2px 7px;">'.$item .'</td>';
}
echo '</tr>';
}
echo '</table>';
// release the session key
$myJSONRPCClient->release_session_key( $sessionKey );
Joffm
