Populate select 2 with JSON data

function getTak (questionnaire, version) {

$(‘#_TAK’).children(‘option:not(:first)’).remove();

$.post(‘inl_sev_055_J_nvg.php’,{“QUESTIONNAIRE” : questionnaire, “VERSION” : version}, function(data) {

var i;

for (i = 0; i < data.length; i++) {

text = data[i];

newOption = new Option(text, i, false, false);

$(‘#_TAK’).append(newOption).trigger(‘change’);

}

}, ‘json’);

}

---

 

// — Parameters input ——————————————————–

$questionnaire = (isset($_REQUEST[‘QUESTIONNAIRE’])) ? $_REQUEST[‘QUESTIONNAIRE’] : ”;
$version = (isset($_REQUEST[‘VERSION’])) ? $_REQUEST[‘VERSION’] : ”;

// — Define containers ——————————————————-

$terugvoer = array();

// — Retrieve the present list of versions ———————————–

$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ “;

$db = new MysqliDb(‘CES’);

$selectStatus = $db->rawQuery($sql);

if ($selectStatus > 0) {

foreach ($selectStatus as $row) {

$terugvoer[] = $row[‘_TAK’];

}

}

echo json_encode($terugvoer);

?>