Hello, I have a little problem with my grid. In my grid I would like to build a select box. Unfortunately I can not get it. The select box is always empty.
Can someone help me?
In the screen that you see it is empty.
Here my Code example.
View
[code]
mygrid = new dhtmlXGridObject(‘gridbox’);
mygrid.setImagePath(‘ext/codebase/imgs/’);
//mygrid.setEditable(false);
mygrid.setHeader(“<?PHP echo ID; ?>, <?PHP echo LABEL; ?>,<?PHP echo ITEMTYP; ?>,<?PHP echo AKTIV; ?>”);
mygrid.setInitWidths(“33,,,60”);
mygrid.setColTypes(“ro,ed,coro,ch”);
mygrid.setColAlign(“center,left,left,left”);
mygrid.setSkin(“dhx_web”);
mygrid.setColSorting(“int,str,int,int”);
mygrid.attachHeader(" ,#text_filter,#select_filter,#select_filter");
mygrid.init();
mygrid.enableSmartRendering(true);
mygrid.loadXML("modules/connector/SiteItems.php?id=<?PHP echo $id;?>");
var myDataProcessor = new dataProcessor("modules/connector/update_SiteItems.php");
myDataProcessor.init(mygrid);
</script>[/code]
Connector
[code]<?PHP
require_once("../../conf/db.php");
require_once("../../ext/codebase/connector/options_connector.php");
require_once("../../ext/codebase/connector/grid_connector.php");
$res=@mysql_connect($db_host,$db_benutzer,$db_passwort);
if (!$res) {
logging ('Keine Datenbankverbindung möglich.', 'ERROR','db');
}
mysql_select_db($db_datenbank);
$grid = new GridConnector($res,"MySQL");
$grid->set_encoding("ISO-8859-1");
$grid->dynamic_loading(100);
$options = new OptionsConnector($res);
$options->render_table("itemTyp","iditemTyp","iditemTyp,bezeichnung");
$grid->set_options("iditemTyp",$options);
$grid->render_sql("SELECT iditems, label, iditemTyp, aktiv FROM items WHERE idSites=".$_GET["id"],"iditems","iditems,label,iditemTyp,aktiv");
@mysql_close($res);
?>[/code]