TreeGrid / PHP / MySQL

I have working code using TreeGrid and XML but a problem I’m running into in some cases is the number of rows are too large so the browser freezes. So I’m trying to convert code code to use the server side feature. But I’m having trouble finding an example to work from. I also don’t know how the table schema should be laid out either. Any tips are greatly appreciated.

Thank you,
John

I found sample code but it seems it required the pro version of the connector to test.

There is no pro version of connector.
Samples of connector are using standard version of dhtmlx suite, so while they have all necessary to generate a data for the treegrid, they can’t show it on client side, without dhtmlx suite pro

Replace dhtmlx.js and dhtmlx.css in connector’s samples with same files from dhtmlx suite pro, and samples will work.

I’m now getting when running dhtmlxConnector/samples/tree/01_basic:

PHP Fatal error: Uncaught exception ‘Exception’ with message ‘MySQL operation failed
Table ‘tree_elements.tasks’ doesn’t exist’ in /api/dhtmlxConnector/codebase/db_common.php:965

I did load the dump.sql file and see the tree_elements database and tree_elements table only. Is there another dump file I need to load?

Thanks,
John

I found a sql dump file with the needed tables within the Java download package of the connector.