Don't display data

QuestionsDon't display data
Fernando asked 6 years ago

Hi, i've purchased the Full Package to mount an SQL Server connection.

The connection is OK, i can see the table header but data is not displayed.

Thanks in advance.

Cheers,
Fernando.

1 Answers
Abu Ghufran answered 6 years ago

Hi,

Pasting from faq:

Q) How to debug no records (blank grid)?

Few considerations before use

1) include the jqgrid_dist.php file before any thing rendered to output.
2) Check the ajax response of grid,

Also make sure, you call '$g->render();' function before any HTML is rendered
(echo'd) to output, as it expect exact JSON format for ajax calls

Use firefox->firebug->net->ajax-call of grid->response. You will see the output there, in case of any error. It should be proper JSON format data in order to render grid

Review this tutorial for '[debugging with firebug](https://phpgrid.desk.com/customer/portal/articles/926266)'.

To enable debugging errors,

1) Turn errors on. Goto jqgrid_dist.php make it 'on'

ini_set("display_errors","on"); // changed from off to on

2) If you are using non-mysql database, Goto file jqgrid_dist.php

$g = new jqgrid($db);

$g->con->debug = 1; // changed from 0 to 1r

Your Answer

6 + 11 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!