Guriddo » Topic: jqgrid pager, php json file structure

jqgrid pager, php json file structure

Guriddo
jqgrid pager, php json file structure

This topic has 2 replies, 1 voice, and was last updated 13 years ago by netpumber.

Creator

Topic

June 15, 2013 at 12:22 pm #81028

netpumber

Participant

I have this php code for counting the number of pages

and retrieve data from database, but something is going wrong

with the pager as i can see.

Specifically i think that there is a problem with the json file structure.

Here is the php code:

<div class="sfcode">public function getLogsList($page,$limit,$sidx,$sord)<br />
{<br />
init_mysql();<br />
<br />
$return_array = array();<br />
$row_array = array();<br />
<br />
// Getting pages number (for jqGrid pager)<br />
<br />
if(!$sidx) $sidx =1;<br />
$result = mysql_query("SELECT COUNT(*) AS count FROM logs");<br />
$row = mysql_fetch_array($result);<br />
$count = $row[&#39;count&#39;];<br />
<br />
if( $count >0 ) {<br />
$total_pages = ceil($count/$limit);<br />
} else {<br />
$total_pages = 0;<br />
}<br />
<br />
if ($page > $total_pages) $page=$total_pages;<br />
$start = $limit*$page - $limit;<br />
<br />
$row_array[&#39;page&#39;] = $page;<br />
$row_array[&#39;total&#39;] = $total_pages;<br />
$row_array[&#39;records&#39;] = $count;<br />
<br />
array_push($return_array,$row_array);<br />
<br />
// Getting data for jqGrid table<br />
<br />
$data =  mysql_query("SELECT * FROM logs ORDER BY log_id DESC");<br />
<br />
if(mysql_num_rows($data))<br />
{<br />
while($row = mysql_fetch_array($data))<br />
{<br />
<br />
$row_array[&#39;log_id&#39;] = $row[&#39;log_id&#39;];<br />
$row_array[&#39;ip&#39;] = $row[&#39;ip&#39;];<br />
$row_array[&#39;hostname&#39;] = $row[&#39;host&#39;];<br />
$row_array[&#39;log&#39;] = $row[&#39;input&#39;];<br />
$row_array[&#39;date&#39;] = $row[&#39;date&#39;];<br />
<br />
array_push($return_array,$row_array);<br />
}<br />
}<br />
<br />
echo json_encode($return_array);<br />
}</div>

<div class="sfcode">public function getLogsList($page,$limit,$sidx,$sord)

{

init_mysql();

$return_array = array();

$row_array = array();

// Getting pages number (for jqGrid pager)

if(!$sidx) $sidx =1;

$result = mysql_query("SELECT COUNT(*) AS count FROM logs");

$row = mysql_fetch_array($result);

$count = $row['count'];

if( $count >0 ) {

$total_pages = ceil($count/$limit);

} else {

$total_pages = 0;

}

if ($page > $total_pages) $page=$total_pages;

$start = $limit*$page - $limit;

$row_array['page'] = $page;

$row_array['total'] = $total_pages;

$row_array['records'] = $count;

array_push($return_array,$row_array);

// Getting data for jqGrid table

$data = mysql_query("SELECT * FROM logs ORDER BY log_id DESC");

if(mysql_num_rows($data))

{

while($row = mysql_fetch_array($data))

{

$row_array['log_id'] = $row['log_id'];

$row_array['ip'] = $row['ip'];

$row_array['hostname'] = $row['host'];

$row_array['log'] = $row['input'];

$row_array['date'] = $row['date'];

array_push($return_array,$row_array);

}

echo json_encode($return_array);

}</div>

The json file looks like this :

[{"page":"1","total":2,"records":"34"},{"page":"1","total":2,"records":"34","log_id":"108","ip":"127.0.0.1","hostname":"","log":"having 1=1","date":"09-06-2013 22:05:57"},{"page":"1","total":2,"records":"34","log_id":"107","ip":"127.0.0.1","hostname":"","log":"//","date":"09-06-2013 22:05:57"},.....}]

[{"page":"1","total":2,"records":"34"},{"page":"1","total":2,"records":"34","log_id":"108","ip":"127.0.0.1","hostname":"","log":"having 1=1","date":"09-06-2013 22:05:57"},{"page":"1","total":2,"records":"34","log_id":"107","ip":"127.0.0.1","hostname":"","log":"//","date":"09-06-2013 22:05:57"},.....}]

as you can see page , total and records are printed each time and

that why i think that something is going wrong with the structure of json file.

Is there any way to fix it ?

Thanks.

Creator

Topic

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

Author

Replies

June 15, 2013 at 7:45 pm #101139

netpumber

Participant

No one can help me to fix this json output ?

June 15, 2013 at 11:41 pm #101140

netpumber

Participant

I've change a little the code but still have to change more..

<div class="sfcode">     if(!$sidx) $sidx =1;<br />
$result = mysql_query("SELECT COUNT(*) AS count FROM logs");<br />
$row = mysql_fetch_array($result);<br />
$count = $row[&#039;count&#039;];<br />
<br />
if( $count &gt;0 ) {<br />
$total_pages = ceil($count/$limit);<br />
} else {<br />
$total_pages = 0;<br />
}<br />
<br />
if ($page &gt; $total_pages) $page=$total_pages;<br />
$start = $limit*$page - $limit;<br />
<br />
$pages_array = array("page"=&gt; $page , "total" =&gt; $total_pages , "records" =&gt; $count);<br />
<br /><br />
array_push($return_array,$pages_array);<br />
<br />
// Getting data for jqGrid table<br />
<br />
$data =  mysql_query("SELECT * FROM logs ORDER BY log_id DESC");<br />
<br />
if(mysql_num_rows($data))<br />
{<br />
while($row = mysql_fetch_array($data))<br />
{<br />
$row_array[&#039;rows&#039;][&#039;log_id&#039;] = $row[&#039;log_id&#039;];<br />
$row_array[&#039;rows&#039;][&#039;ip&#039;] = $row[&#039;ip&#039;];<br />
$row_array[&#039;rows&#039;][&#039;hostname&#039;] = $row[&#039;host&#039;];<br />
$row_array[&#039;rows&#039;][&#039;log&#039;] = $row[&#039;input&#039;];<br />
$row_array[&#039;rows&#039;][&#039;date&#039;] = $row[&#039;date&#039;];<br />
<br />
array_push($return_array,$row_array);<br />
}<br />
}<br />
<br />
echo json_encode($return_array);</div>

<div class="sfcode"> if(!$sidx) $sidx =1;

$result = mysql_query("SELECT COUNT(*) AS count FROM logs");

$row = mysql_fetch_array($result);

$count = $row['count'];

if( $count >0 ) {

$total_pages = ceil($count/$limit);

} else {

$total_pages = 0;

}

if ($page > $total_pages) $page=$total_pages;

$start = $limit*$page - $limit;

$pages_array = array("page"=> $page , "total" => $total_pages , "records" => $count);

array_push($return_array,$pages_array);

// Getting data for jqGrid table

$data = mysql_query("SELECT * FROM logs ORDER BY log_id DESC");

if(mysql_num_rows($data))

{

while($row = mysql_fetch_array($data))

{

$row_array['rows']['log_id'] = $row['log_id'];

$row_array['rows']['ip'] = $row['ip'];

$row_array['rows']['hostname'] = $row['host'];

$row_array['rows']['log'] = $row['input'];

$row_array['rows']['date'] = $row['date'];

array_push($return_array,$row_array);

}

echo json_encode($return_array);</div>

Author

Replies

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

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

jqgrid pager, php json file structure

Search Forum

Recent Replies

Forum Statistics

UserOnline