Guriddo » Topic: How to integrate jqGrid with CakePHP

How to integrate jqGrid with CakePHP

Guriddo
How to integrate jqGrid with CakePHP

This topic has 15 replies, 5 voices, and was last updated 9 years, 1 month ago by guriddo.support.

Creator

Topic
October 12, 2008 at 8:27 pm #72201

myles
Participant

Good Day to All!

First I would like to thank the creators of jqGrid for an awesome grid and documentation.

My question is can we use a function instead of using a php file url to

have pagination?

I mean instead of using the code snippet below:
Creator

Topic

Viewing 15 replies - 1 through 15 (of 15 total)

Author

Replies
October 13, 2008 at 1:36 am #83816

tony
Keymaster

Hello,

The final release have something like

datatype : function(pdata){

// call your own function here

// use addXmlData or addJSONData methods

}

Regards

Tony

October 13, 2008 at 2:54 am #83818

myles
Participant

What did you mean final release? you mean version 3.3?

Can you please explain more on your sample I am a little bit confused.

All I want to do is use jqGrid in CakePHP but the problems is in CakePHP

you have to access data through a Controller or Controller Components.

And in the samples it gets data through a PHP page.

Can anybody enlighten me on this.

Thanks and Regards,

Myles

October 13, 2008 at 4:01 am #83820

tony
Keymaster

Hello,

It is a little confused for me, but the current published version

3.3. is preview release. Final will be in Tuesday.

Regards

Tony

October 13, 2008 at 8:59 pm #83826

myles
Participant

To simplyfy my question,

How can I use jqGrid with CakePHP?

Thanks and Regards,

Myles

October 14, 2008 at 3:47 am #83827

tony
Keymaster

Hello,

Since I do not know CakePHP – but if you can call direct via url a function

as of your code it is a really simple: (suppose JSON)

datatype : function(pdata){

$.ajax({

url: 'yourfunctionhere',

data: pdata,

complete : function(response,status) {

if(status=='success'){

var mygrid =

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:””;
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Times New Roman”;}

jQuery(gridid)[0];

mygrid.addJSONData(eval(”(”+response.responseText+”)”));

}

}

…

})

}

Hope this helps

Regards

Tony

October 20, 2008 at 8:50 pm #83902

myles
Participant

Thank very much for the response.

By the way with the code above how can I implement pagination and

filtering of data?

Can jqGrid pass values through the function parameters to get data for

pagination and filtering data instead of passing through the URL?

Like

October 20, 2008 at 9:07 pm #83903

myles
Participant

I mean can I use jqGrid like the code snippet below:

datatype : function(pdata){

$.ajax({

url: 'getJsOnData(page, rows, sidx, sord)',

data: pdata,

October 21, 2008 at 1:18 am #83909

tony
Keymaster

Hello,

That is you solution except that pdata contain all the needed pagging parameters – i.e. pdata is actually postData array.

If you can not use pdata you can do it in you function this way

datatype : function(pdata){

…

$.ajax({

url: 'getJsOnData(pdata.page, pdata.rows, pdata.sidx, pdata.sord)',

November 14, 2008 at 11:18 pm #84244

xuding
Participant

Dude, I have just done the integration after half day trying..

Let me know if you still need help with it since thi is a old post.

December 12, 2008 at 1:54 am #84543

myles
Participant

Yes if you have can have a sample in your implementation please post here.

Thanks in advance

January 22, 2009 at 7:58 pm #84995

xuding
Participant

Since Cakephp follows MVC, model. and jqgrid is getting data from

April 16, 2009 at 11:47 pm #86449

xuding
Participant

I have wrote a simply tutorial of integration on my blog:

jqGrid is now Guriddo!

May 15, 2009 at 3:45 am #86882

myles
Participant

Thanks for the effort in making a tutorial and also a sample I try it

February 15, 2017 at 1:04 pm #125838

trevrobwhite
Participant

I know this is a really old thread, but does anyone know if this tutorial is still available?

I’m just moving over to CakePHP and are running into a bit of trouble where to place the files, paths, should the main content be in the controller or view etc.

Thanks.

February 17, 2017 at 10:33 am #125839

guriddo.support
Participant

Hello,

I can’t find the link too. Seems to be broken. Will try to search on the web.

Kind Regards,
Will

Guriddo Support Team
Author

Replies