Grid OptionsConnector like OptionsConnector for scheduler

Suite and Optimus Suite 5
#21

just to check the data, I wrote this code in uffici.php

[code]require_once("…/db_connect.php");
require_once("…/codebase/php-connector/grid_connector.php");
require_once("…/codebase/php-connector/db_mysqli.php");

$uffici = new GridConnector($db,“MySQLi”);
$uffici->render_table(“uffici”,“id”,“nomeCompleto”); [/code]

The output of uffici.php is

<?xml version="1.0" encoding="UTF-8"?> <rows> <row id="0420020060"> <cell>Corte d'Appello di Ancona</cell> </row> <row id="0720060064"> <cell>Corte d'Appello di Bari</cell> </row> <row id="0370060061"> <cell>Corte d'Appello di Bologna</cell> </row> <row id="0210080067"> <cell>Corte d'Appello di Bolzano - Bozen</cell> </row> <row id="0170290065"> <cell>Corte d'Appello di Brescia</cell> </row> ..... ..... much other stuff here ..... </rows>

#22

P.S. I also swithched to the latest version of PHP connector taken from github, but the problem is still there…

#23

The only thing that comes into my mind now is that the id/primary key of table “uffici” is a string, not an integer. May that be a problem?

#24

… and it is a string that has digits inside, and frequently it begins with one or more zeros

#25

mmm…
the following code does not work, either, and table “utenti” has a “normal” integer id/primary key

[code]<?php
require_once("…/db_connect.php");
require_once("…/codebase/php-connector/grid_connector.php");
require_once("…/codebase/php-connector/options_connector.php");
require_once("…/codebase/php-connector/db_mysqli.php");

$utenti = new OptionsConnector($db,“MySQLi”); // ADDED
$utenti->render_table(“utenti”,“id”,“id(value),username(label)”); // ADDED

$grid = new GridConnector($db,“MySQLi”);
$grid->set_options(“idUtente”, $utenti); // ADDED
$grid->render_table(“ufficiPreferiti”,“id”,“idUfficio,idRegistro,idUtente”);
?>[/code]

#26

SOLVED!

I have found the solution here
viewtopic.php?f=19&t=37774

even if I use the full dhtmlx.js file and not single dhtmlx components, I had to include connector.js, and it works