jQuery Grid Plugin - jqGrid - Topic: How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0 Simple:Press Version 5.7.5.3 tifischer on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30691 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30691 I had to download 4.6.0 plus the example theme files that Tony provided above and then make sure the file names in the example are changed to match the files in the demo.  It works great. 

]]> Tue, 27 May 2014 18:15:18 +0300 tifischer on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30645 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30645 Thank you Tony.  That did it.  It must have been something about the install I downloaded.

Blessings,

TiffanyLaughLaughLaugh

]]> Tue, 20 May 2014 16:32:21 +0300 tony on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30644 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30644 Hello,

Here you are - Look at this example

]]> Tue, 20 May 2014 14:51:40 +0300 tifischer on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30643 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30643 Yes, I did fix the second problem…it wasn't so much a problem because it was a typo that occurred after I changed the text so as to not give out person information.

{"page":null,"total":0,"records":"14518","rows":[{"id":"1","cell":["1","Matthew","Testing","","test@demo",null,"1"]},{"id":"3","cell":["3","Jennifer","Testing","","test@demo",null,"0"]},{"id":"1028","cell":["1028","Watts","Testing","","test@demo",null,"0"]},{"id":"1029","cell":["1029","McKenna","Testing","","test@demo",null,"1"]},{"id":"1031","cell":["1031","Hoyt","Testing","","test@demo",null,"1"]}]}

Would you kindly share the working demo : )

Blessings,

Tiffany

]]> Tue, 20 May 2014 14:43:05 +0300 tony on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30641 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30641 Hello,

You should fix the second problem with the response. Do you have fix it.

I have a working demo with your json response, but fixed.

Kind Regards

]]> Tue, 20 May 2014 14:39:30 +0300 tifischer on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30636 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30636 Ok I updated the code to

           colNames:['personID','Type','lastName','firstName','email','middleName','address'],
           colModel:[
            //{name:'', sortable:true, index:'a.personType', width:25, hidden:false,search:false,hidedlg:true},
            //search ID on
            //{name:'', index:'a.personID', width:20, hidden:false,searchoptions:{sopt:['bw','cn','eq','ne','lt','gt','ew']}},
            //search ID off
            {name:'personID', index:'a.personID', width:20},
            {name:'Type', index:'isStudent', sortable:true, width:25},   
               {name:'lastName', index:'a.lastName', width:40},
               {name:'firstName', index:'a.firstName', width:30},
               {name:'email', sortable:true, index:'a.emailAddress', width:60},
               {name:'middleName', sortable:false,index:'middleName', width:35},
               {name:'address', sortable:false,index:'address', width:100},
           ],

But it still does not work.

]]> Mon, 19 May 2014 17:33:53 +0300 tony on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30634 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30634 Hello,

You have 2 errors in the example you provide:

1. The elements in colNames are diffrent from thise in colModel

2. In the response there is a error - a "is missed.

You have

...

{"id":"1031","cell":["1031","Hoyt","TempName5,"","angels@gmail.com",null,"1"]}

...

but it should be

...

{"id":"1031","cell":["1031","Hoyt","TempName5","","angels@gmail.com",null,"1"]}

...

]]> Mon, 19 May 2014 12:34:52 +0300 tifischer on How to install json jqGrid 4.6.0 http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30628 Help http://www.trirand.com/blog/?page_id=393/help/how-to-install-json-jqgrid-4-6-0#p30628 I was running 3.5.3 with jQuery 1.7.1v and wanted to upgrade to 4.6.0. PHP 5.3, MySQL 5.1, Apache 2.2

My data loads from the server echo json_encode($response); produces the following output (with testing data):

{"page":null,"total":0,"records":"14518","rows":[{"id":"1","cell":["1","Matthew","TempName2","","tifischer@gmail.com",null,"1"]},{"id":"3","cell":["3","Jennifer","TempName1","","jfischer@gmail.com",null,"0"]},{"id":"1028","cell":["1028","Watts","TempName3","","bluebonnets@gmail.com",null,"0"]},{"id":"1029","cell":["1029","McKenna","TempName4","","star@gmail.com",null,"1"]},{"id":"1031","cell":["1031","Hoyt","TempName5,"","angels@gmail.com",null,"1"]}]}

However, no grid is displayed.  My jQuery code is as fallows:

    <link rel="stylesheet" type="text/css" media="screen" href="jquery-ui-1.10.4.custom/css/redmond/jquery-ui-1.10.4.custom.css" />
    <link rel="stylesheet" type="text/css" media="screen" href="jqgrid.jqGrid-4.6.0/css/ui.jqgrid.css" />
    <script src="jquery.jqGrid-4.6.0/js/jquery-1.11.0.min.js" type="text/javascript"></script>
    <script src="jquery.jqGrid-4.6.0/js/jquery-ui-custom.min.js" type="text/javascript"></script>
    <script src="jquery.jqGrid-4.6.0/js/i18n/grid.locale-en.js" type="text/javascript"></script>
    <script type="text/javascript">
        $.jgrid.no_legacy_api = true;
        $.jgrid.useJSON = true;
    </script>
    <script src="jquery.jqGrid-4.6.0/plugins/ui.multiselect.js" type="text/javascript"></script>
    <script src="jquery.jqGrid-4.6.0/js/jquery.jqGrid.min.js" type="text/javascript"></script>
    <script src="jquery.jqGrid-4.6.0/plugins/jquery.tablednd.js" type="text/javascript"></script>
    <script src="jquery.jqGrid-4.6.0/plugins/jquery.contextmenu.js" type="text/javascript"></script>
 <!–   <script src="jqgrid.jqGrid-4.6.0/src/grid.loader.js" type="text/javascript"></script> –>
     <script type="text/javascript">
    $.jgrid.no_legacy_api = true;
    $.jgrid.useJSON = true;
    </script>

    <script type="text/javascript">
jQuery(document).ready(function(){
   
    jQuery("#person_list").jqGrid({       
           url:'server-update.php?q=1',
        datatype: "json",
           colNames:['ID','Type','Last','First','Email','Phone','Address','Custom','Registrations','Balance Due'],
           colModel:[
            //{name:'', sortable:true, index:'a.personType', width:25, hidden:false,search:false,hidedlg:true},
            //search ID on
            //{name:'', index:'a.personID', width:20, hidden:false,searchoptions:{sopt:['bw','cn','eq','ne','lt','gt','ew']}},
            //search ID off
            {name:'personID', index:'a.personID', width:20},
            {name:'isStudent', index:'isStudent', sortable:true, width:25},   
               {name:'lastName', index:'a.lastName', width:40},
               {name:'firstName', index:'a.firstName', width:30},
               {name:'email', sortable:true, index:'a.emailAddress', width:60},
               {name:'phone', sortable:false,index:'phone', width:35},
               {name:'address', sortable:false,index:'address', width:100},
           ],
           rowNum:7,
        autowidth: true,
           pager: '#pagerb',
           sortname: 'lastName',
           rowList:[10,20,50,100],
        viewrecords: true,
        sortorder: "asc",
        caption: "JSON Example",

    });
   
    jQuery("#person_list").jqGrid('navGrid','#pagerb',{edit:false,add:false,del:false});

</script>

…

                                                                 <table id="person_list" class="scroll" style="width:100% important!; font-family: Arial !important; font-size: 12px !important; color: #3a3a3a !important"></table>
                                                                     <div id="pagerb" class="scroll" style="text-align:center;"></div>

…

Can someone tell me why this does not display the data in the grid format?

Blessings!

]]> Fri, 16 May 2014 23:29:09 +0300