saving grid values to Database

[naveenMember]

Hi

I am looking for an example that helps me to save the grid values to Database. I am writing the code in JAVA. If you have code either in java or in PHP, please post it.

Thank you.

[DimitarParticipant]

Hello naveen,

Please take a look at the examples on PHP Integration in the documentation, especially the following: Build CRUD Web App with jqxGrid using PHP and MySQL.

Best Regards,
Dimitar

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

[naveenMember]

Thanks for the reply.

Is it possible to save the grid values to JAVA variables? thank you.

[Peter StoevKeymaster]

Hi naveen,

Unfortunately, we don’t have any knowledge in Java and can’t help you with that.

jQWidgets team
http://www.jqwidgets.com

[naveenMember]

Dimitar,

Let me know how to save all the grid value to PHP. I’ll convert it to JAVA. (If I am asking for java, then provide me PHP code).

I also tried using the below method but it only gives me only one row value.

var data = $(‘#grid’).jqxGrid(‘getrowdata’, 0);

I would like to know how to get all the grid values. Thank you.

[Peter StoevKeymaster]

Hi naveen,

getrowdata is a method which gets one row. getrows is another method which gets all rows. For CRUD operations with PHP, read the CRUD help topic in our help documentation: php-server-side-grid-crud.htm.

Best Regards,
Peter Stoev

jQWidgets team
http://www.jqwidgets.com

[naveenMember]

getrows is printing the data in below format instead of the actual data.

[object Object], [object Object], [object Object], [object Object], [object Object]

[Peter StoevKeymaster]

Hi naveen,

Yes, the getrows method returns an array of all rows displayed in the Grid.

Example:

var rows = $("#grid").jqxGrid('getrows');
var row1 = rows[0];
var row2 = rows[1];

Best Regards,
Peter Stoev

jQWidgets team
http://www.jqwidgets.com

[Author]

Posts