davidsomerset
Forum Replies Created
Viewing 3 replies - 1 through 3 (of 3 total)
-
Forum: Plugins
In reply to: [WPF-jqGrid] No data showing in tableI’ve figured it out. When loading the JSON data, the returned result contained a PHP error generated by the call to
ob_cleaninwpf-jqdata.php. Commenting out that line fixes the problem for now:<br /> <b>Notice</b>: ob_clean(): failed to delete buffer. No buffer to delete in <b>/directory/path/wpf-jqgdata.php</b> on line <b>71</b><br />I’m not sure if this is a bug in my config options or the plugin, but it works now!
Forum: Plugins
In reply to: [WPF-jqGrid] No data showing in tableSure – the table structure is as follows:
item_id – int(11)
item_name – varchar(255)
item_description – varchar(500)
item_price float – No
date_served – varchar(100)
glutenfree – int(11)
nutfree – int(11)
shellfishfree – int(11)
eatsmart – int(11)
vegan – int(11)
is_breakfast – int(11)
is_lunch – int(11)
is_dinner – int(11)Although I was having the same issue when I tried to display the included sample table, so I don’t think it’s the DB table.
The HTML for the table is pasted below:
<div id="edit-menu-form"> <!-- SHORTCODE ATTIVO DI WPF-jqGrid per la Tabella wp_menu VER. 0.12 --> <div class="ui-jqgrid ui-widget ui-widget-content ui-corner-all" id="gbox_wpfjqg_1" dir="ltr" style="width: 1079px;"><div class="ui-widget-overlay jqgrid-overlay" id="lui_wpfjqg_1"></div><div class="loading ui-state-default ui-state-active" id="load_wpfjqg_1" style="display: none;">Loading...</div><div class="ui-jqgrid-view" id="gview_wpfjqg_1" style="width: 1079px;"><div class="ui-jqgrid-titlebar ui-widget-header ui-corner-top ui-helper-clearfix"><a role="link" href="javascript:void(0)" class="ui-jqgrid-titlebar-close HeaderButton" style="right: 0px;"><span class="ui-icon ui-icon-circle-triangle-n"></span></a><span class="ui-jqgrid-title">Menu Items</span></div><div class="ui-state-default ui-jqgrid-hdiv" style="width: 1079px;"><div class="ui-jqgrid-hbox"><table class="ui-jqgrid-htable" style="width:1079px" role="grid" aria-labelledby="gbox_wpfjqg_1" cellspacing="0" cellpadding="0" border="0"><thead><tr class="ui-jqgrid-labels" role="rowheader"><th id="wpfjqg_1_item_id" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 150px; display: none;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_id" class="ui-jqgrid-sortable">Item Id<span class="s-ico" style=""><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_item_name" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_name" class="ui-jqgrid-sortable">Item Name<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_item_description" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_description" class="ui-jqgrid-sortable">Item Description<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_item_price" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_item_price" class="ui-jqgrid-sortable">Item Price<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_date_served" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_date_served" class="ui-jqgrid-sortable">Date Served<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_glutenfree" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_glutenfree" class="ui-jqgrid-sortable">Glutenfree<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_nutfree" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_nutfree" class="ui-jqgrid-sortable">Nutfree<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_shellfishfree" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_shellfishfree" class="ui-jqgrid-sortable">Shellfishfree<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_eatsmart" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_eatsmart" class="ui-jqgrid-sortable">Eatsmart<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_vegan" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_vegan" class="ui-jqgrid-sortable">Vegan<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_is_breakfast" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_is_breakfast" class="ui-jqgrid-sortable">Is Breakfast<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_is_lunch" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 90px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_is_lunch" class="ui-jqgrid-sortable">Is Lunch<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th><th id="wpfjqg_1_is_dinner" role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="width: 89px;"><span class="ui-jqgrid-resize ui-jqgrid-resize-ltr" style="cursor: col-resize;"> </span><div id="jqgh_wpfjqg_1_is_dinner" class="ui-jqgrid-sortable">Is Dinner<span class="s-ico" style="display:none"><span sort="asc" class="ui-grid-ico-sort ui-icon-asc ui-state-disabled ui-icon ui-icon-triangle-1-n ui-sort-ltr"></span><span sort="desc" class="ui-grid-ico-sort ui-icon-desc ui-state-disabled ui-icon ui-icon-triangle-1-s ui-sort-ltr"></span></span></div></th></tr><tr class="ui-search-toolbar" role="rowheader"><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr" style="display: none;"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_id" id="gs_item_id" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_name" id="gs_item_name" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_description" id="gs_item_description" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="item_price" id="gs_item_price" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="date_served" id="gs_date_served" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="glutenfree" id="gs_glutenfree" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="nutfree" id="gs_nutfree" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="shellfishfree" id="gs_shellfishfree" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="eatsmart" id="gs_eatsmart" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="vegan" id="gs_vegan" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="is_breakfast" id="gs_is_breakfast" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="is_lunch" id="gs_is_lunch" value=""></div></th><th role="columnheader" class="ui-state-default ui-th-column ui-th-ltr"><div style="position:relative;height:100%;padding-right:0.3em;"><input type="text" style="width:95%;padding:0px;" name="is_dinner" id="gs_is_dinner" value=""></div></th></tr></thead></table></div></div><div class="ui-jqgrid-bdiv" style="height: 100%; width: 1079px;"><div style="position:relative;"><div></div><table id="wpfjqg_1" tabindex="0" cellspacing="0" cellpadding="0" border="0" role="grid" aria-multiselectable="false" aria-labelledby="gbox_wpfjqg_1" class="ui-jqgrid-btable" style="width: 1079px;"><tbody><tr class="jqgfirstrow" role="row" style="height:auto"><td role="gridcell" style="height:0px;width:150px;display:none;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:90px;"></td><td role="gridcell" style="height:0px;width:89px;"></td></tr></tbody></table></div></div></div><div class="ui-jqgrid-resize-mark" id="rs_mwpfjqg_1"> </div><div id="wpfjqgNav_1" class="ui-state-default ui-jqgrid-pager ui-corner-bottom" dir="ltr" style="width: 1079px;"><div id="pg_wpfjqgNav_1" class="ui-pager-control" role="group"><table cellspacing="0" cellpadding="0" border="0" class="ui-pg-table" style="width:100%;table-layout:fixed;height:100%;" role="row"><tbody><tr><td id="wpfjqgNav_1_left" align="left"><table cellspacing="0" cellpadding="0" border="0" class="ui-pg-table navtable" style="float:left;table-layout:auto;"><tbody><tr><td class="ui-pg-button ui-corner-all" title="Add new row" id="add_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-plus"></span></div></td><td class="ui-pg-button ui-corner-all" title="Edit selected row" id="edit_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-pencil"></span></div></td><td class="ui-pg-button ui-corner-all" title="Delete selected row" id="del_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-trash"></span></div></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td class="ui-pg-button ui-corner-all" title="Find records" id="search_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-search"></span></div></td><td class="ui-pg-button ui-corner-all" title="Reload Grid" id="refresh_wpfjqg_1"><div class="ui-pg-div"><span class="ui-icon ui-icon-refresh"></span></div></td></tr></tbody></table></td><td id="wpfjqgNav_1_center" align="center" style="white-space: pre; width: 297px;"><table cellspacing="0" cellpadding="0" border="0" style="table-layout:auto;" class="ui-pg-table"><tbody><tr><td id="first_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-first"></span></td><td id="prev_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-prev"></span></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td dir="ltr">Page <input class="ui-pg-input" type="text" size="2" maxlength="7" value="0" role="textbox"> of <span id="sp_1_wpfjqgNav_1"></span></td><td class="ui-pg-button ui-state-disabled" style="width:4px;"><span class="ui-separator"></span></td><td id="next_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-next"></span></td><td id="last_wpfjqgNav_1" class="ui-pg-button ui-corner-all"><span class="ui-icon ui-icon-seek-end"></span></td><td dir="ltr"><select class="ui-pg-selbox" role="listbox"><option role="option" value="2">2</option><option role="option" value="5">5</option><option role="option" value="10" selected="selected">10</option><option role="option" value="25">25</option><option role="option" value="50">50</option><option role="option" value="500">500</option></select></td></tr></tbody></table></td><td id="wpfjqgNav_1_right" align="right"><div dir="ltr" style="text-align:right" class="ui-paging-info"></div></td></tr></tbody></table></div></div></div> <div id="wpfjqgSearch_1" class="fm-button ui-state-default ui-corner-all fm-button-icon-right ui-reset">Search<span class="ui-icon ui-icon-search"></span></div> <script type="text/javascript"> var lastSel; jQuery('#wpfjqg_1').jqGrid({ url: 'https://localhost:8888/wordpress/wp-admin//admin-ajax.php?action=ajax-wpfjqg&nonce=56d3710d95&table=wp_menu', datatype: 'json', colNames: ['Item Id','Item Name','Item Description','Item Price','Date Served','Glutenfree','Nutfree','Shellfishfree','Eatsmart','Vegan','Is Breakfast','Is Lunch','Is Dinner'], colModel: [{title:'Item Id',name:'item_id',index:'item_id',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,hidden:true,key:true}, {title:'Item Name',name:'item_name',index:'item_name',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'left',editoptions:{'size':20}, editrules:{required: true,}}, {title:'Item Description',name:'item_description',index:'item_description',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'left',editoptions:{'size':20}, editrules:{required: true,}}, {title:'Item Price',name:'item_price',index:'item_price',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'right', formatter:'number', formatoptions: {decimalSeparator:',', thousandsSeparator: '.', decimalPlaces: 2, defaulValue: 0},editoptions:{'size':20}, editrules:{required: true,}}, {title:'Date Served',name:'date_served',index:'date_served',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'left',editoptions:{'size':20}, editrules:{required: true,}}, {title:'Glutenfree',name:'glutenfree',index:'glutenfree',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,edittype: 'checkbox'}, {title:'Nutfree',name:'nutfree',index:'nutfree',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Shellfishfree',name:'shellfishfree',index:'shellfishfree',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Eatsmart',name:'eatsmart',index:'eatsmart',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Vegan',name:'vegan',index:'vegan',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Is Breakfast',name:'is_breakfast',index:'is_breakfast',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Is Lunch',name:'is_lunch',index:'is_lunch',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, {title:'Is Dinner',name:'is_dinner',index:'is_dinner',searchoptions:{sopt:['bw','cn','eq','ne','ew','nu','nn']},editable:true,align:'center', formatter: 'checkbox', formatoptions: { disabled: true}, editoptions: { value: '1:0' }, edittype: 'checkbox', editrules: {required: false}, searchoptions: { sopt: ['eq','ne','nu','nn']}, searchrules:{integer:true, minValue:0, maxValue:1}}, ], pager: '#wpfjqgNav_1', rowNum: 10, rowList: [2, 5, 10, 25, 50, 500], autowidth: true, sortname: '1', sortorder: 'asc', viewrecords: true, jsonReader: { repeatitems: false }, width: 640, caption: 'Menu Items', height: '100%', editurl: 'https://localhost:8888/wordpress/wp-admin//admin-ajax.php?action=ajax-wpfjqg&nonce=56d3710d95&table=wp_menu', edit_options:{'closeAfterEdit':true}, /* fjqg_onlineEdit */ onSelectRow: function(ids) { if(ids == null) { ids=0; } } }); /* autofilter */ jQuery('#wpfjqg_1').jqGrid('filterToolbar',{stringResult:true, searchOnEnter:false}); </script><script type="text/javascript"> masterGrid = jQuery('#wpfjqg_1').jqGrid('navGrid', '#wpfjqgNav_1', { edit: true, add: true, del: true }, //options {recreateForm: true, beforeShowForm: function (form) {jQuery('#Id', form).attr('readonly', 'readonly');}, closeAfterEdit: true, width: 400, reloadAfterSubmit: true }, // edit options {recreateForm: true, closeAfterAdd: true, reloadAfterSubmit: true }, // add options {reloadAfterSubmit: true }, // del options {} // search options ); //standard search button jQuery('#wpfjqgSearch_1').click(function () { jQuery('#wpfjqg_1').jqGrid('searchGrid', { sopt: ['cn', 'bw', 'eq', 'ne', 'lt', 'gt', 'ew'] } ); }); </script> </div>I know this is not the easiest thing in the world to read, so let me know if you need the information in another form. I’m not sure how to directly message someone via WP comments.
Thanks for the quick response! This is time sensitive, so I really appreciate the help.
Forum: Plugins
In reply to: [WPF-jqGrid] No data showing in tableJust so you have some more information – I am using the built-in Sunny theme for display, and the table only contains columns of type “int”, “varchar”, and “float”.
And finally, like Michael. am also running WP in a subdirectory on my site. I could not see the error that he did though.
Viewing 3 replies - 1 through 3 (of 3 total)