JSON – My PHP / Javascript / JQuery notes

Javascript, JSON, PHP, SQL

Javascript – Building arrays from JSON response data

Posted on December 18, 2018 by edleightonprogrammer

function getPerformanceinfo (){

var myLabelarray = [];
var myActualarray = [];

$.post(‘inl_sev_078_J_vrs.php’, {“UNIQUENO” : myReportref }, function(response) {

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

myLabelarray[i] = response[i]._TAK;

myActualarray[i] = response[i]._PERCENTAGE;

}

myChartjs (myLabelarray, myActualarray);

}, ‘json’)

}

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

$uniqueno = (isset($_REQUEST[‘UNIQUENO’])) ? $_REQUEST[‘UNIQUENO’] : ”;

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

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

// — Extract the category names and weights ——————————

$sql = “SELECT _QUESTIONNAIRE, _VERSION, _TAK, _PERCENTAGE FROM performance WHERE _UNIQUENO = ‘$uniqueno’ “;

$db = new MysqliDb(‘CES’);

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

foreach ($selectStatus as $row) {

$tmp[‘_QUESTIONNAIRE’] = $row[‘_QUESTIONNAIRE’];
$tmp[‘_VERSION’] = $row[‘_VERSION’];
$tmp[‘_TAK’] = $row[‘_TAK’];
$tmp[‘_PERCENTAGE’] = $row[‘_PERCENTAGE’];

$terugvoer[] = $tmp;

}

// echo ‘<pre>’;
// print_r($terugvoer);
// echo ‘</pre>’;

echo json_encode($terugvoer);

Javascript, JQuery, JSON

Javascript – Populating Select 2 from JSON data

Posted on December 7, 2018 by edleightonprogrammer

function getVersion (questionnaire) {

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

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

var i;

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

text = data[i];

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

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

}

}, ‘json’);

}

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

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

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

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

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

$sql = “SELECT DISTINCT _VERSION FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire'”;

$db = new MysqliDb(‘CES’);

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

if ($selectStatus > 0) {

foreach ($selectStatus as $row) {

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

}

// echo ‘<pre>’;
// print_r($terugvoer);
// echo ‘</pre>’;

echo json_encode($terugvoer);

JSON, PHP, SQL

MySQL – Retrieving data for EasyUI datagrid

Posted on December 5, 2018December 5, 2018 by edleightonprogrammer

<?php

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

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

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

// — Retrieve the list of questions by DEPARTMENT —————————–

$sql = “SELECT _DATE, _TIME, _USERID, _NAME, _ACTIVITY FROM audit”;

$db = new MysqliDb(‘CES’);

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

if ($selectStatus > 0) {

$tmp[‘message’] = ‘Central evaluation system – Questions loaded successfully’;
$tmp[‘success’] = ‘Y’;

foreach ($selectStatus as $row) {

$tmp[‘_DATE’] = $row[‘_DATE’];
$tmp[‘_TIME’] = $row[‘_TIME’];

$tmp[‘_USERID’] = $row[‘_USERID’];
$tmp[‘_NAME’] = $row[‘_NAME’];

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

$terugvoer[] = $tmp;

}

echo json_encode($terugvoer);

Javascript, JQuery, JSON, NOTY

Javascript – Yes / No NOTY buttons

Posted on December 5, 2018 by edleightonprogrammer

function deleteDocs () {

var uploadid = <?php echo ($uploadid); ?>;

$.noty.closeAll()

var n = noty({

text : ‘<?php echo $translation->getValue(“CESDoyouwanttoDELETEyourUPLOADEDDOCUMENTSfromthedatabase”)?>’,
type : ‘confirm’,
dismissQueue : false,
layout : ‘top’,
theme : ‘defaultTheme’,

buttons : [

{addClass: ‘btn btn-success’, text:'<?php echo (“Yes”)?>’, onClick:

function($noty) {

$noty.close();

$.post(‘inl_sev_066_J_ver.php’,{“UPLOADID” : uploadid,

“event” :’STOOR’}, function(response) {

// alert (“Javascript object – response : ” + JSON.stringify(response, null, 4));

if (response[0].success == “Y”) {

$.noty.closeAll();

var n = noty({
dismissQueue: false,
timeout : 2000,
text : response[0].message,
type : ‘success’,
layout : ‘top’
});

} else {

$.noty.closeAll();

var n = noty({
dismissQueue: false,
text : response[0].message,
type : ‘error’,
layout : ‘top’
});

}

}, ‘json’)

}

}, // YES Button

{addClass: ‘btn btn-danger’, text:'<?php echo (“No”)?>’, onClick:

function($noty) {

$noty.close();

noty({text:'<?php echo (“Cancelled”)?>’, type: ‘error’,timeout:1000});

} // “NO” Button

}

] // Noty button array

}) // Noty

}

Javascript, JQuery, JSON

Javascript / JQuery – $.getJSON and $.post

Posted on December 5, 2018December 5, 2018 by edleightonprogrammer

$.getJSON(‘inl_sev_034_E_vrs.php?TEMPLATE=’ + template + “&DEPT=” + dept, function(data) {

var myData = data;

// alert (“Javascript object – data : ” + JSON.stringify(data));

});

$.post(‘inl_sev_035_J_skp.php’,{

“DEPT” : dept,
“TEMPLATE” : template,
“VERSION” : version,
“MYDATA” : myData,

“event” :’STOOR’}, function(response) {

}, ‘json’)

JSON, PHP

PHP – Convert stdClass object to array

Posted on November 29, 2018 by edleightonprogrammer

$myUploadinfo = $upload->getUploadDetails($uploadid);

$myUploadinfoarray = json_decode(json_encode($myUploadinfo), True);

Shift array up one level

$myArray = array_shift($myUploadinfoarray);
foreach ($myArray as $key => $value) {

$fileid = $value[‘file_id’];

$result = $upload->deleteFile($fileid);

}

JSON

Javascript – Posting using json

Posted on November 27, 2018November 27, 2018 by edleightonprogrammer

$.post(‘inl_sev_004_J_skp.php’,{

“QUESTION” : question,
“YN” : yn,
“COMMENTONLY” : commentonly,
“DEPT” : dept,

“event” :’STOOR’}, function(response) {

// alert (“Javascript object – response : ” + JSON.stringify(response, null, 4));

}

}, ‘json’)