Guriddo » netpumber's Replies

netpumber

Guriddo

Forum Replies Created

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

Author

Replies

June 15, 2013 at 11:41 pm in reply to: jqgrid pager, php json file structure #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>

June 15, 2013 at 7:45 pm in reply to: jqgrid pager, php json file structure #101139

netpumber

Participant

No one can help me to fix this json output ?

July 8, 2011 at 8:50 pm in reply to: XML Parsing Error: junk after document element #98434

netpumber

Participant

I made two changes and the error changed :

change 1

$sord = $_GET['sord'];

INTO

$sord = 'invid';

change 2

$SQL = “SELECT invid, invdate, amount, tax,total, note FROM invheader ORDER BY $sidx $sord LIMIT $start , $limit”;

INTO

$SQL = “SELECT invid, invdate, amount, tax,total, note FROM invheader ORDER BY $sidx , $sord LIMIT $start , $limit”;

The XML error now be this :

XML Parsing Error: junk after document element
Location: http://localhost/SpDatabase/res/grid/
Line Number 62, Column 1:
11112001-01-10103.0045.00149.00
^

Author

Replies

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