Category: PHP

Posted in HTML, Javascript, PHP, SQL

Javascript – Building arrays for Chart.js from JSON data

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

}

$(“#_UNIQUENUMBER”).prop(“disabled”, true);

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[‘_TAK’] = $row[‘_TAK’];
$tmp[‘_PERCENTAGE’] = $row[‘_PERCENTAGE’];

$terugvoer[] = $tmp;

}

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

echo json_encode($terugvoer);

Posted in HTML, PHP

PHP – Hyperlinks and images

Posted on by edleightonprogrammer

foreach ($myArray as $key => $value) {

$myURL = substr($myArray[$key][‘path’], 5);
$mySafeURL = str_replace(‘ ‘, ‘%20’, $myURL);
$mysrc = $myEnv . $mySafeURL;

if (substr($mysrc, -3) == ‘pdf’ || substr($mysrc, -3) == ‘PDF’) {

// — PDF Document —————————————–
echo “<a href=” . $mysrc . “>PDF Dokument / Document</a>”;

} else {

// — JPG or PNG ——————————————-
echo “<img width=’30% height=’30%’ src=” . $mysrc . ” onclick=window.open(this.src)>”;

}

echo “<hr>”;

}

Posted in Javascript, JSON, PHP, SQL

Javascript – Building arrays from JSON response data

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

Posted in PHP, zebra_form

Zebra_form – Select box

Posted on by edleightonprogrammer

$form->add(‘label’, ‘label_uniquenumber’, ‘_UNIQUENUMBER’, “CESUniquecompnumber”);

$obj = $form->add(‘select’, ‘_UNIQUENUMBER’);

$obj->add_options($reportArray);

$obj->set_attributes(array(
‘class’ => ‘input-field control form-control’,
‘style’ => ‘width:150px’
));

$obj->set_rule(array(

));

$obj->disable_spam_filter();

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 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>’;