it works, thanks

i use trial/limited demo

Here is the code

require_once ‘../../lib/conf/_jq-config.php’;
require_once ‘../../lib/ext/PHPSuito5/DBdrivers/jqGridPdo.php’;
require_once ‘../../lib/ext/PHPSuito5/jqTreeGrid.php’;

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
$tree = new jqTreeGrid($conn);
$tree->SelectCommand = “SELECT * FROM adj_table”;
$tree->table = ‘adj_table’;
$tree->setPrimaryKeyId(’emp_id’);
$tree->setTreeModel(‘adjacency’);
$tree->setTableConfig(array(‘id’=>’emp_id’, ‘parent’=>’boss_id’));
$tree->showError = true;
$tree->setColModel();
$tree->setUrl(‘loadlib_show_tree.php’);
$tree->dataType = ‘json’;
$tree->renderTree(‘#tree’, ‘#pager’, true,null, null, true, true);

• This reply was modified 10 years ago by azat.kilibayev.