Excel "link" serverside ???

Hello

I know how to use coltype “link” via XML. But i’m loading data via connector:

if($_GET['id'] == "4") { 
   $grid->dynamic_loading(15);
   $grid->set_encoding("iso-8859-1");
   $grid->render_sql("SELECT wonr_intern,wonr_um,wo_typ,wo_group_id,upload_date,wo_stat, termin_stat,kd_nachname,kd_strasse,kd_hsnr,kd_hsnr_zus,kd_plz,kd_ort FROM sk_auftraege AS A INNER JOIN sk_kundenstamm AS B ON A.kdnr_intern = B.id ORDER BY A.upload_date DESC","wonr_intern","wonr_intern,wonr_um,wo_typ,wo_group_id,upload_date,wo_stat,termin_stat,kd_nachname,kd_strasse,kd_hsnr,kd_hsnr_zus,kd_plz,kd_ort"); 
}

How can i set the first column as “link” ?

Thank you

Is there really no way to set a column as a normal link ?

Please, provide the code of configuration of your grid.

Kunden suchen
  <script src="../../../dhtmlx/Grid/codebase/dhtmlxcommon.js"></script>
  <script src="../../../dhtmlx/Grid/codebase/dhtmlxgrid.js"></script>        
  <script src="../../../dhtmlx/Grid/codebase/dhtmlxgridcell.js"></script>
  <script src="../../../dhtmlx/Grid/codebase/excells/dhtmlxgrid_excell_grid.js"></script>
  <script src="../../../dhtmlx/Grid/codebase/excells/dhtmlxgrid_excell_link.js"></script>
  <script src="../../../dhtmlx/Grid/codebase/ext/dhtmlxgrid_filter.js" type="text/javascript"></script> 
  <script src="../../../dhtmlx/Grid/codebase/ext/dhtmlxgrid_pgn.js"></script>
  <script src="../../../dhtmlx/Grid/codebase/ext/dhtmlxgrid_hmenu.js"></script>
  <script src="../../../dhtmlx/Connector/connector.js"></script>
    
  <style>
      html, body {width: 100%; height: 100%; margin: 0px; overflow: hidden; background-color:white;}
     .grid_hover {background-color:#9CC;font-size:20px;}
	 .rows_even {background-color:#DFEFFF;}
	 .rows_uneven {background-color:#FFFFF0;}
	 .dhx_header_cmenu{background-color:#ffffff;border:2px outset silver;z-index:2;}
	 .dhx_header_cmenu_item{white-space:nowrap;}
  </style>
  <script type="text/javascript">
	 Grid = new Array();
	 
	 function doOnLoad() {		 
        Grid[1] = new dhtmlXGridObject('gridbox');
	    Grid[1].setImagePath("../../../dhtmlx/Grid/codebase/imgs/");
	    Grid[1].setHeader("INT,UM,TP,GR,Eingang,ER,TM,Kunde,Strasse,HS,,PLZ,Ort");
		Grid[1].attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_select_filter,#connector_select_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_select_filter");
	    Grid[1].setInitWidths("49,43,30,30,63,35,35,100,*,28,15,40,85");
	    Grid[1].setColAlign("center,center,center,center,center,center,center,left,left,center,center,center,left");
	    Grid[1].setColTypes("link,ro,ro,ro,ro,coro,coro,ro,ro,ro,ro,ro,ro");
	    Grid[1].enableTooltips("false,false,false,false,false,false,false,true,true,false,false,false,true");
        Grid[1].enableRowsHover(true, 'grid_hover'); 
        Grid[1].attachEvent("onXLS", function() {document.getElementById('loading').style.display = 'block';});
        Grid[1].attachEvent("onXLE", function() {document.getElementById('loading').style.display = 'none';});
		Grid[1].attachEvent("onEditCell", function(stage,rId,cInd,nValue,oValue){ 
	       if (stage == 0 && (cInd == 5 || cInd == 6)) { return false; } else { return true; } 
	    });
	    Grid[1].setSkin("clear");
	    Grid[1].enablePaging(true, 15, 5, "paging", true);
        Grid[1].setPagingSkin("bricks");
		
        Grid[1].init();
        Grid[1].enableHeaderMenu();
        Grid[1].enableAlterCss("rows_even", "rows_uneven");
		Grid[1].load("../../../dhtmlx/Data/XML/connector.php?id=4"); 
	 }
  </script> 

Any ideas ?

In connector’s package samples you can find a sample with server-side configuration of grid:
“samples\grid\09_server_side_configuration.html”

Here is the example of server-side code:

[code]<?php
require_once("…/config.php");
$res=mysql_connect($mysql_server,$mysql_user,$mysql_pass);
mysql_select_db($mysql_db);

require("../../codebase/grid_connector.php");
$grid = new GridConnector($res);

$config = new GridConfiguration();
$config->setHeader("ID,First Name,Last Name,Title,Office,Extn,Mobile,Email");
$config->attachHeader("#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter,#connector_text_filter");
$config->setColTypes("ro,ed,ed,ed,ed,ed,ed,ed");
$config->setColSorting("str,str,str,str,str,str,str,str");
$grid->set_config($config);
$grid->render_table("clubs");

?>[/code]

Thank you but how can i define a “link” ?

push

Here is the method defining the column types:
$config->setColTypes(“ro,ed,ed,ed,ed,ed,ed,ed”);

If you need a link in the first column just set “link” in the first argument of the method:
$config->setColTypes(“link,ed,ed,ed,ed,ed,ed,ed”);

docs.dhtmlx.com/doku.php?id=dhtm … cells#link