Hi, please have a look what’s wrong here?
I’ve done a server side configured grid with 3 combo fields, but they are not working! Neither from database nor from array. Here is a link to this grid: smag.kh.ua/1/
$dhtmlRes = mysql_connect($configSettings['db']['host'], $configSettings['db']['user'], $configSettings['db']['pass']);
mysql_select_db($configSettings['db']['name']);
mysql_query("SET NAMES utf8");
require_once("../admin/common/codebase/connector/grid_config.php");
require_once("../admin/common/codebase/connector/grid_connector.php");
$grid = new GridConnector($dhtmlRes);
$config = new GridConfiguration();
$config->setHeader("name,script,print,paging,multi,categorized,enabled");
$config->setColIds("name,script,print,paging,multi,categorized,enabled");
$config->setColTypes("ed,ed,ch,ch,co,co,coro");
$config->setInitWidths('200,200,130,90,120,100,120');
$config->setColAlign('left,left,center,center,center,center,center');
$grid->set_encoding("utf8");
$grid->set_config($config);
$options = new OptionsConnector($dhtmlRes);
$options->render_sql("SELECT id as value, script as label FROM entities", "id", "id(value),script(label)");
$grid->set_options("categorized", $options); //1
$grid->set_options("enabled", $options); //2
$grid->set_options("multi", array("1" => "one", "2"=>"two","3" => "three")); //3
$grid->render_table("entities", "id", "id,script,print,paging,multi,categorized,enabled");
Please advise how to fix the combo fields.
Thank you.
Alex.