Map Column Header to MySQL Table Field

Hello Everyone,

I feel like I’m missing something fundamental about how data is transferred between dhtmlxConnector and dhtmlxGrid and I’m hoping someone here can help me out.

Basically it appears to me that data is transferred between the connector and the grid by order for both load, update, and insert. However, since my grid has data in it from multiple tables I can’t figure out how to get the right data from the grid mapped into the SQL insert command.

Grid Header


PHP Connector Code


As you can see the following fields are not included in the PHP Connector Code: ID and MGR. Is there a way to bind the header name, example “Project”, to a database field name, example “fk_project”? I noticed that the Visual Designer has a Name field with a tool tip of Element’s ID, I thought maybe I should set the Name to equal the data base field name, but, I haven’t been able to find any other documentation of that ID.

Thank you,