sorry missed the data..

Now data which I am getting is

{“userdata”:[],”rows”:[{“ID”:”1″,”parent”:null,”level”:0,”isLeaf”:”true”,”loaded”:”true”,”expanded”:”true”},{“ID”:”1″,”parent”:null,”level”:0,”isLeaf”:”true”,”loaded”:”true”,”expanded”:”true”}],”total”:2,”page”:1}

Hello,

Thanks for the response.I will give it a try.

Started with my first grid. Data connection is OK. I can see data fetched from database in json format but still my grid is blank.

Data displayed in jason as below:

{“records”:0,”page”:0,”total”:0,”rows”:[{
“ID”:1,”parent”:”0″},{“ID”:2,”parent”:”0″}]}

Table Information :

Name : parent

Column : ID,parent

Rows : (1,0)(2,0)

Here is php code :

<?php
ini_set(“display_errors”,1);

require_once ‘../jq-config.php’;
// include the driver class
require_once ABSPATH.”php/PHPSuito/DBdrivers/jqGridPdo.php”;
// include the jqGrid Class
require_once ABSPATH.”php/PHPSuito/jqTreeGrid.php”;
// Connection to the server
$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
$conn->query(“SET NAMES utf8”);
// Create the jqTreeGrid instance
$tree = new jqTreeGrid($conn);

$tree->SelectCommand = “SELECT * FROM parent”;

// set the table and primary key
$tree->table = ‘parent’;
$tree->setPrimaryKeyId(‘ID’);
// set tree model and table configuration
$tree->setTreeModel(‘nested’);
$tree->setTableConfig(array(‘id’=>’ID’, ‘left’=>’null’, ‘right’=>’null’,’level’=>’0′));

// autoloading nodes
$tree->autoLoadNodes = true;
// show any error (if any ) from server
$tree->showError = true;

$tree->setColModel();

$tree->setUrl(‘mygrid.php’);
$tree->dataType = ‘json’;
// Some nice setting
$tree->setColProperty(‘ID’,array(“label”=>”ID”, “width”=>170));
$tree->setColProperty(‘parent’,array(“label”=>”parent”, “width”=>170));

// and finaly set the expand column and height to auto
$tree->setGridOptions(array(
“ExpandColumn”=>”ID”,
“height”=>”auto”,
“sortname”=>”ID”
));
$tree->renderTree(‘#tree’, ‘#pager’, true,null, null, true, true);

• This reply was modified 10 years, 9 months ago by abhinav30.