Start Building Professional
Web Apps Today

dhtmlxgrid- PHP-MySql- tables with a large number of columns

I have the pro version of dhtmlxgrid and have been developing applications using PHP and mySql.

I have been using the standard PHP scriopts that come with the Pro version for interfacing with MySql.

With a MySql table with a few rows ( say 6) the scripts are working perfectly. However, when I try and run the scripts tied to a MySql table with 25 columns the scripts are not working correctly. The data in the table is displayed on the grid correctly but the scripts to create a new row or update an existibng row in the database do not update the database.

I have checked and rechecked but cannot see what the problem is.

Has anyone else experienced this problem?

Any guidance would be appreciated.

regards

Angus

Most probably you have a field with name or type which require special kind of escaping while using in SQL queries. ( the name of fields used only in update|insert queries which are not works for you )

If problem still occurs for you – please send problematic table schema.

 

While common code provided with dataProcessor lib can be used as fast solution, you always can create a custom one, which will work exactly for your situation, please check attached sample which can be used instead of common server side script