What I was trying to do is find a way to get to create the dataFields and columns from a php and sql file based on the sql statement dynamically.
I was not sure if dataFields and columns can except JSON input.
$(document).ready(function () {
var theme = getTheme();
var url = “gridData.php”;
var source =
{
datatype: “json”,
datafields: ‘datafieldsJSON.php’,
id: ‘id’,
url: url,
root: ‘data’
};
var dataAdapter = new $.jqx.dataAdapter(source);
$(“#jqxgrid”).jqxGrid(
{
width: 670,
source: dataAdapter,
theme: theme,
columnsresize: true,
columns: ‘columnsJSON.php’
});
});
