I have searched for the above issue and it looks like it has been raised by many but did not come across any solution.
-dhtmlxSuite v.5.1.0 Professional Evaluation
-dhtmlxConnector for PHP v.1.5
First question are there compatibility issues between the dhtmlxSuite and connector one uses.
Second question. I’m building my grid and pulling data from a MySQL database but I get the error above.
var b = main_layout.cells(‘b’);
var grid_1 = b.attachGrid();
grid_1.setHeader(["Serial #","First Name","Middle Name","lname","Gender","Age","Disability"]); grid_1.setColTypes("ro,ro,ro,ro,ro,ro,ro"); grid_1.setColSorting('str,str,str,str,str,int,str'); grid_1.setInitWidths('*,*,*,*,*,*,*'); grid_1.init(); grid_1.load('controller/gc_beneficiary.php', 'xml');
My server side connector:
$conn = new GridConnector($mysqli,"MySQLi"); $conn->enable_log("C:/Temp/log.txt",true); $sql = "SELECT * FROM beneficiary AS b ORDER BY b.fname ASC"; $conn->render_sql($sql,"serialno","fname,mname,lname,gender,age,disability");