Render_table with id

Suite and Optimus Suite 5
#1

According to documentation docs.dhtmlx.com/doku.php?id=tuto … y:gridlink I should be able to pass an id to the connector script, which renders table to filter just one record. This does not seem to work:

dev.connectfu.com:42001/dhtmlx/t … php?id=156

id is completely ignored.

This is the code for the connector:

<?php include('config.php'); include("../suite/dhtmlxConnector/codebase/dataview_connector.php"); $view = new DataViewConnector($dbh,"MySQL"); # <= $dbh comes from config.php $view->render_table('organization', 'organization_id', 'subdomain,register'); ?>

What am I doing wrong?

There is a secondary problem. The connector does not properly handle unicode characters contained within the database when creating XML:

A user with firstname “Jean-François” , lastname “Lemercier” turns into:

Here is a sample script: dev.connectfu.com:42001/dhtmlx/tut/users.php

To find the record, you have to view source and then search for the string above.

#2

Currently only FormConnector supports loading data by id behavior (not DataViewConnector as in your code)

There is a secondary problem. The connector does not properly handle unicode characters
Try to change your code as

$view = new DataViewConnector($dbh,"MySQL"); # <= $dbh comes from config.php $view->set_encoding("utf-8"); $view->render_table('organization', 'organization_id', 'subdomain,register');

Also, be sure to check collation in the database, it is quite possible that database itself convert characters during data saving|loading. ( calling mysql_query(“SET NAMES utf8”); before data loading may help as well )