Posted in PHP, SQL

PHP – The switch statement

Posted on by edleightonprogrammer

switch ($event) {

case “TAK”:
$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ AND _FINAL = ” “;

$db = new MysqliDb(‘CES’);

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

break;

case “FIN”:
$sql = “SELECT DISTINCT _TAK FROM questionnaire WHERE _TEMPLATE = ‘$questionnaire’ AND _VERSION = ‘$version’ AND _FINAL = ‘Y’ “;

$db = new MysqliDb(‘CES’);

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

break;

default:
echo “Fout / Fault”;

}

Posted in DOM, Javascript

Javascript – Disabling form elements a better way

Posted on by edleightonprogrammer

function processForm(form) {

var inputs=document.getElementsByTagName(‘input’);

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

inputs[i].disabled = true;

}

// ————————————————————-

var inputs=document.getElementsByTagName(‘textarea’);

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

inputs[i].disabled = true;

}

// ————————————————————-

// var controls = form.elements;

// for (var i=0, iLen=controls.length; i<iLen; i++) {

// controls[i].disabled = true;

// }

// ————————————————————-

statementEvaluation();

$(‘#btnDocupload’).hide();
$(‘#btnPrintMyPDF’).hide();
$(‘#btnFinalize’).hide();

}

Posted in Javascript, JQuery, JSON

Javascript – Populating Select 2 from JSON data

Posted on 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);

?>

Posted in HTML, Javascript

Javascript – Validating input

Posted on by edleightonprogrammer

function Validate(txt) {

txt.value = txt.value.replace(/[^a-zA-Z 0-9\n\r]+/g, ”);

}

 

<td><textarea rows=”2″ name=_CANCOMMENT’ + item.quest_id + ‘ id=_CANCOMMENT’ + item.quest_id + ‘ onkeyup = “Validate(this)” ‘ + ‘ onblur = “updateDetail(‘ + item.quest_id + ‘,’ + item._ACTUALPOINTS + ‘)” ‘ + ‘” class=”input-field control form-control” style=”width:400px”>’ + item._CANCOMMENT + ‘</textarea> </td>

Posted in JSON, PHP, SQL

MySQL – Retrieving data for EasyUI datagrid

Posted on 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);

?>

Posted in Font awesome, HTML, PHP

Info icon

Posted on by edleightonprogrammer

echo ‘<i style=”float:right; color:#AFAFAF;padding-right: 10px;” title=”Program inl_sev_064_Z_ver.php, Template inl_sev_065_T_ver.php, JSON inl_sev_066_J_ver.php” class=”fa fa-info-circle”></i>’;

echo ‘<br>’;