or
<?php $sRootDir = "../.."; require_once ($sRootDir.'/lib/Kendo/DataSourceResult.php'); require_once ($sRootDir.'/lib/Kendo/Autoload.php'); require_once ($sRootDir."/include/includeDomain.php"); require_once ($sRootDir."/include/includeLib.php"); if ($_SERVER['REQUEST_METHOD'] == 'POST') { header('Content-Type: application/json'); $sType = $_GET["type"]; $sRequest = json_decode(file_get_contents('php://input')); //Password data removed $pResult = new DataSourceResult(**dns**, **user**, **password**); $aColumns = array('CLIENTEMEA', 'CLIENTNAME', 'CLIENTKVK'); switch($sType) { case 'create': $sResult = $pResult->create('RULES_CLIENTS', $aColumns, $sRequest->models, 'CLIENTEMEA'); break; case 'read': $sResult = $pResult->read('RULES_CLIENTS', $aColumns, $sRequest); break; case 'update': $sResult = $pResult->update('RULES_CLIENTS', $aColumns, $sRequest->models, 'CLIENTEMEA'); break; case 'destroy': $sResult = $pResult->destroy('RULES_CLIENTS', $sRequest->models, 'CLIENTEMEA'); break; } echo json_encode($sResult, JSON_NUMERIC_CHECK); $FileName = "testFile.txt"; $FileHandle = fopen($FileName, 'w') or die("can't open file"); fwrite($FileHandle, json_encode($sResult, JSON_NUMERIC_CHECK)); fclose($FileHandle); exit; } require_once($sRootDir."/html/tpbilling/client/index2.html");?><div id="grid"></div><script>jQuery(function(){jQuery("#grid").kendoGrid({"columns":[{"field":"CLIENTEMEA","width":100,"title":"Client EMEA"},{"field":"CLIENTNAME","width":400,"title":"Client Name"},{"field":"CLIENTKVK","width":100,"title":"KVK Number"}],"dataSource":{"transport":{"create":{"url":"../../tpbilling/client/test.php?type=create","contentType":"application\/json","type":"POST"},"read":{"url":"../../tpbilling/client/test.php?type=read","contentType":"application\/json","type":"POST"},"update":{"url":"../../tpbilling/client/test.php?type=update","contentType":"application\/json","type":"POST"},"destroy":{"url":"../../tpbilling/client/test.php?type=destroy","contentType":"application\/json","type":"POST"},"parameterMap":function(data) {return kendo.stringify(data);}},"batch":true,"pageSize":20,"schema":{"data":"data","errors":"errors","model":{"id":"CLIENTEMEA","fields":[{"field":"CLIENTEMEA","type":"number","validation":{"required":true}},{"field":"CLIENTNAME","type":"string","validation":{"required":true}},{"field":"CLIENTKVK","type":"number","validation":{"required":true}}]},"total":"total"}},"toolbar":[{"name":"create"}],"height":430,"editable":"popup","pageable":true});}); </script>