Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
jqGridPHP 4.3.2.0 - No Data In Table
17/05/2012
20:06
Avatar
sshults
New Member
Members
Forum Posts: 1
Member Since:
17/05/2012
sp_UserOfflineSmall Offline

Hi!

I tested the demo version of jqGridPHP and it worked great.  Then, the next day, I got an expired script warning.  Okay, fine - we purchased a license and downloaded the file sent via the link from the email.  I cleared out the directory containing the old jqGridPHP stuff, updated jq-config.php with my database information (MySQL) and then refreshed the page.

Nothing.  I didn't change the code on my PHP page or anything but nothing loaded.  I check the source and see something like this:

<table id='grid'></table><div id='pager'></div><script type='text/javascript'>jQuery(document).ready(function($) {jQuery('#grid').jqGrid({"width":"650","hoverrows":false,"viewrecords":true,"jsonReader":{"repeatitems":false,"subgrid":{"repeatitems":false},"id":"sales_order","cell":""},"xmlReader":{"repeatitems":false,"subgrid":{"repeatitems":false}},"gridview":true,"url":"LoadShippingBranchReport.php","editurl":"LoadShippingBranchReport.php","cellurl":"LoadShippingBranchReport.php","rowNum":100,"height":600,"autowidth":true,"altRows":true,"pgbuttons":true,"sortable":true,"datatype":"json","colModel":[{"label":"SO","name":"sales_order","index":"sales_order","sorttype":"string","key":true,"editable":true},{"label":"Cus #","name":"orh_cus_no","index":"orh_cus_no","sorttype":"int","editable":true},{"label":"Cus PO#","name":"orh_cus_po_no","index":"orh_cus_po_no","sorttype":"blob","editable":true},{"label":"IS","name":"orh_slp_is","index":"orh_slp_is","sorttype":"blob","editable":true},{"label":"ALC","name":"ord_alc_cd","index":"ord_alc_cd","sorttype":"string","editable":true},{"label":"Customer","name":"cus_nm","index":"cus_nm","sorttype":"string","editable":true},{"label":"Description","name":"description","index":"description","sorttype":"string","editable":true},{"label":"Grp","name":"ord_prg","index":"ord_prg","sorttype":"string","editable":true},{"label":"Sz","name":"ord_size","index":"ord_size","sorttype":"string","editable":true},{"label":"Grd","name":"ord_grd","index":"ord_grd","sorttype":"string","editable":true},{"label":"Pcs","name":"ord_ord_unt","index":"ord_ord_unt","sorttype":"int","editable":true},{"label":"LBS","name":"ord_ord_wgt","index":"ord_ord_wgt","sorttype":"int","editable":true},{"label":"Ord Dt","name":"orh_ord_dt","index":"orh_ord_dt","sorttype":"string","editable":true},{"label":"Due Dt","name":"orh_due_dt","index":"orh_due_dt","sorttype":"string","editable":true},{"label":"Sts","name":"ord_ost","index":"ord_ost","sorttype":"string","editable":true},{"name":"orh_ost_dt","index":"orh_ost_dt","sorttype":"string","editable":true},{"label":"SH","name":"orh_shp_hld_cd","index":"orh_shp_hld_cd","sorttype":"blob","editable":true},{"label":"FP","name":"ord_prt_wko","index":"ord_prt_wko","sorttype":"string","editable":true},{"label":"Note","name":"inside_sales_note","index":"inside_sales_note","sorttype":"blob","editable":true}],"postData":{"oper":"grid"},"prmNames":{"page":"page","rows":"rows","sort":"sidx","order":"sord","search":"_search","nd":"nd","id":false,"filter":"filters","searchField":"searchField","searchOper":"searchOper","searchString":"searchString","oper":"oper","query":"grid","addoper":"add","editoper":"edit","deloper":"del","excel":"excel","subgrid":"subgrid","totalrows":"totalrows","autocomplete":"autocmpl"},"loadError":function(xhr,status, err){ try {jQuery.jgrid.info_dialog(jQuery.jgrid.errors.errcap,'<div class="ui-state-error">'+ xhr.responseText +'</div>', jQuery.jgrid.edit.bClose,{buttonalign:'right'});} catch(e) { alert(xhr.responseText);} },"pager":"#pager"});jQuery('#grid').jqGrid('navGrid','#pager',{"edit":false,"add":false,"del":false,"search":false,"refresh":true,"view":false,"excel":true,"pdf":false,"csv":false,"columns":false},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150,"errorTextFormat":function(r){ return r.responseText;}},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150,"errorTextFormat":function(r){ return r.responseText;}},{"errorTextFormat":function(r){ return r.responseText;}},{"drag":true,"closeAfterSearch":true,"multipleSearch":true},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150});jQuery('#grid').jqGrid('navButtonAdd','#pager',{id:'pager_excel', caption:'',title:'Export To Excel',onClickButton : function(e)

{

try {

jQuery("#grid").jqGrid('excelExport',{tag:'excel', url:'LoadShippingBranchReport.php'});

} catch (e) {

window.location= 'LoadShippingBranchReport.php?oper=excel';

}

},buttonicon:'ui-icon-newwin'});jQuery('#grid').jqGrid('filterToolbar',{"stringResult":true});

});</script>

If I turn on debugging with $grid->debug = true; and $grid->queryGrid(); then the result is returned:

{"records":"3894","page":1,"total":195,"rows":[{"sales_order":"27-803662-6","no":"6425","po_no":"","is":"","alc_cd":"CU","nm":"","description":"","prg":"155R","size":"3.5","grd":"RTA","unt":"39","wgt":"160","dt":"04\/15\/2010","due_dt":"12\/31\/2013","ost":"BLK","ost_dt":"07\/06\/2011","shp_hld_cd":"Y","prt_wko":"Y","note":""}}

I have no idea why this suddenly stopped working.  Also, all of the topics I read with json and jqGrid say that there should be an id and cell field in the json text but jqGrid isn't generating this.  Again, I didn't change anything in my code when going from the demo to the full version.

Help!

17/05/2012
20:27
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

Hello,

Please post your problem here:

http://www.trirand.net/forum/

Not sure, but maybe you will need to re download the PHP demo , clearing the browser cache before downloading the new demo.

Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
45 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information