EasyUI Datagrid JSON information

require_once($_SERVER[‘DOCUMENT_ROOT’].’/xyz/db/MysqliDb.php’);

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

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

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

$terugvoer = array();
$tmp = array();

// — Retrieve the list of UPLOADID’s by DEPARTMENT —————————

$sql = “SELECT upload_id, _UPLOADID FROM uploads
WHERE _TAK = ‘$tak’ AND _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ “;

$db = new MysqliDb(‘CES’);

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

if ($selectStatus > 0) {

foreach ($selectStatus as $row) {

$tmp[‘_UPLOADID’] = $row[‘_UPLOADID’];

$uploadid = $row[‘_UPLOADID’];
$isn = $row[‘upload_id’];

// — Add buttons with event parameters ———————————

$tmp[‘view’] = ‘<a onclick=”viewDoc (\”.$uploadid.’\’)”
<button class=”btn btn-info fa fa-info-circle”> </button></a>’;

// ———————————————————————–

$tmp[‘delete’] = ‘<a onclick=”Delete (\”.$uploadid.’\’)”
<button class=”btn btn-danger fa fa-trash”> </button></a>’;

// ———————————————————————–

$terugvoer[] = $tmp;

}

}

echo json_encode($terugvoer);

?>