I am using the dhtmlxConnector to populate my grid, I’d like to link one of the columns and open a dhtmlxWindow with the database id column, which is not shown in the grid and two other fields that are visible in the grid. When i specifiy the column type as link nothing happens for one and how do I modify the link to put in the id of the row?
Here is a code sample.
var dhxGrid;
parent.dhxLayout.cells("a").setWidth(200);
dhxGrid = parent.dhxLayout.cells("b").attachGrid();
dhxGrid.setImagePath("/js/dhtmlxSuite2.6/dhtmlxGrid/codebase/imgs/");
dhxGrid.setHeader("Username, Email Address, IP Address, Date, Active");
dhxGrid.attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter")
dhxGrid.setInitWidths("100,*")
dhxGrid.setColTypes("ro,ro,ro,ro,link");
dhxGrid.setColSorting("connector,connector,connector,connector,connector")
dhxGrid.enableSmartRendering(true)
dhxGrid.enableMultiselect(true)
dhxGrid.init();
dhxGrid.loadXML("connectors/userAdmin.php");
var dp = new dataProcessor("connectors/userAdmin.php");
dp.init(dhxGrid);
<?php
require_once("../config.php");
$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db($mysql_db);
require("../js/dhtmlxSuite2.6/dhtmlxConnector/codebase/grid_connector.php");
$grid = new GridConnector($res);
$grid->enable_log("temp.log",true);
$grid->dynamic_loading(100);
$grid->render_table("tz_members","id","usr,email,regIP,dt,userActive");
?>