Need a code sample for obvious use case

[tuthmosisMember]

Greetings !

Looking at the code posted here by Dimitar, the only thing that could be missing for me is the binding necessary to update, create or delete rows.

Use Case:
– An Employee grid displaying MySQL stored data.
– “Employee” table containing foreign key column that points to a “cities” table.
– The grid must display a dropdown box for the city… This city column must display the city names and not the city ID.
– Of course, the grid is inline editable so if the employee phone number or city gets changed by the user, an AJAX transaction must occur to update the appropriate tables.

This seams to me like an obvious use case for an editable grid connected to an SQL database.

Can someone point me to an example showing how to do this using jqxgrid ?

P.S. I code using PHP on server side…And JSON for data transfer.

Thanks !

[Peter StoevKeymaster]

Hi,

Here are some samples with Foreign Key Columns:

– http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridkeyvaluescolumnwitharray.htm?web
– http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/gridkeyvaluecolumn.htm?web
– http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/foreignkeycolumn.htm?web

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[tuthmosisMember]

Thanks but i already knew those samples and this is why i posted my question in the first place…

If you look at the last link :
– http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/foreignkeycolumn.htm?web

The grid is not editable and so no dropdown and no code showing me how to ensure proper binding in case of a value being changed in that foreign key column…

But again… it should be something obvious as this Use Case is often implemented in many back office applications so i theres got to be some sample showing this simple logic.

Thx

[Peter StoevKeymaster]

Hi,

The only demo which is not editable is the one is that you posted. The other 2 samples are with Editable Foreign Key columns.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts