<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel>
	<title>jQuery Grid Plugin - jqGrid - Topic: Paging Help Desperately</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/paging-help-desperately</link>
	<description><![CDATA[Grid plugin]]></description>
	<generator>Simple:Press Version 5.7.5.3</generator>
	<atom:link href="http://www.trirand.com/blog/?page_id=393/help/paging-help-desperately/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>amithasija on Paging Help Desperately</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/paging-help-desperately#p17489</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/paging-help-desperately#p17489</guid>
        	        	<description><![CDATA[<p>Done 🙂</p>
</p>
<p>Hope it will help somebody.</p>
</p>
<p>Javascript Code</p>
</p>
<p>var actionHandlerGrid = "&#60;?php echo WEBSITE_URL ?&#62;admin/contact/grid";</p>
<p>&#160;&#160; &#160;</p>
<p>jQuery("#single").jqGrid({<br />&#160;&#160; &#160;scrollrows : true,<br />&#160; &#160;&#160;&#160; &#160;url:actionHandlerGrid,<br />&#160;&#160; &#160;datatype: "json",<br />&#160;&#160; &#160;height: 255, width: 860,<br />&#160; &#160;&#160;&#160; &#160;colNames:[&#39;Id&#39;,&#39;Country Name&#39;, &#39;Area&#39;],<br />&#160; &#160;&#160;&#160; &#160;colModel:[<br />&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;id&#39;,index:&#39;id&#39;, width:65, sorttype:&#39;int&#39;}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;country_name&#39;,index:&#39;country_name&#39;, width:150}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;{name:&#39;area&#39;,index:&#39;area&#39;, width:100} ],<br />&#160; &#160;&#160;&#160; &#160;rowNum:10,<br />&#160; &#160;&#160;&#160; &#160;rowList:[10,20,30],<br />&#160; &#160;&#160;&#160; &#160;pager: &#39;#psingle&#39;,<br />&#160; &#160;&#160;&#160; &#160;sortname: &#39;country_name&#39;,<br />&#160;&#160;&#160; viewrecords: true,<br />&#160;&#160;&#160; sortorder: "desc",<br />&#160;&#160;&#160; caption:"Navigator Example",<br />&#160;&#160; &#160;height:150<br />});<br />jQuery("#single").jqGrid(&#39;navGrid&#39;,&#39;#psingle&#39;,<br />{del:false,add:false,edit:false}, //options<br />{height:280,reloadAfterSubmit:false}, // edit options<br />{}, // add options<br />{reloadAfterSubmit:false}, // del options<br />{} // search options<br />);</p>
<p>Php Code</p>
</p>
<p>function gridAction() {</p>
<p>&#160;&#160; &#160;<br />&#160;&#160; &#160;$page = $this-&#62;getRequest()-&#62;getParam(&#39;page&#39;);<br />&#160;&#160; &#160;$limit = $this-&#62;getRequest()-&#62;getParam(&#39;rows&#39;);<br />&#160;&#160; &#160;$sidx = $this-&#62;getRequest()-&#62;getParam(&#39;sidx&#39;);<br />&#160;&#160; &#160;$sord = $this-&#62;getRequest()-&#62;getParam(&#39;sord&#39;);<br />&#160;&#160; &#160;$totalrowsData = $this-&#62;getRequest()-&#62;getParam(&#39;totalrows&#39;);</p>
<p>&#160;&#160; &#160;if(!$sidx){ $sidx =1; }<br />&#160;&#160; &#160;$totalrows = isset($totalrowsData) ? $totalrowsData: false; <br />&#160;&#160; &#160;if($totalrows) { <br />&#160;&#160; &#160;&#160;&#160; &#160;$limit = $totalrows;<br />&#160;&#160; &#160;} </p>
<p>&#160;&#160; &#160;$objCountry = new Country();<br />&#160;&#160; &#160;$count = $objCountry-&#62;fetchMyCount();</p>
<p>&#160;&#160; &#160;if( $count &#62;0 ) { <br />&#160;&#160; &#160;&#160;&#160; &#160;$total_pages = ceil($count/$limit);<br />&#160;&#160; &#160;} else { <br />&#160;&#160; &#160;&#160;&#160; &#160;$total_pages = 0;<br />&#160;&#160; &#160;} </p>
<p>&#160;&#160; &#160;if ($page &#62; $total_pages) $page=$total_pages;<br />&#160;&#160; &#160;if ($limit&#60;0) $limit = 0; <br />&#160;&#160; &#160;$start = $limit*$page - $limit; // do not put <br />&#160;&#160; &#160;if ($start&#60;0) $start = 0; </p>
<p>&#160;&#160; &#160;<br />&#160;&#160; &#160;&#160;&#160; &#160;<br />&#160;&#160; &#160;$countries_data =&#160; $objCountry-&#62;getRequiredData($start, $limit);</p>
<p>&#160;&#160; &#160;//$countries_data = $objCountry-&#62;fetchAll($objCountry-&#62;select()-&#62;limit($start, $limit));</p>
<p>&#160;&#160; &#160;$responce-&#62;page = $page; $responce-&#62;total = $total_pages; $responce-&#62;records = $count;<br />&#160;&#160; &#160;$i=0; </p>
<p>&#160;&#160; &#160;foreach($countries_data as $data) {</p>
<p>&#160;&#160; &#160;&#160;&#160; &#160;$responce-&#62;rows[$i][&#39;id&#39;]=$data[&#39;id&#39;];<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;$responce-&#62;rows[$i][&#39;cell&#39;]=array($data[&#39;id&#39;],$data[&#39;country_name&#39;],$data[&#39;area&#39;]);<br />&#160;&#160; &#160;&#160;&#160; &#160;$i++;<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160; <br />&#160;&#160; &#160;echo json_encode($responce); die;</p>
<p>}</p>
]]></description>
        	        	<pubDate>Thu, 27 May 2010 14:40:58 +0300</pubDate>
        </item>
        <item>
        	<title>amithasija on Paging Help Desperately</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/paging-help-desperately#p17481</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/paging-help-desperately#p17481</guid>
        	        	<description><![CDATA[<div class="content">
<div id="commentbody-12407">
<p>Hi,</p>
<p>I m getting issues in paging, i has 202 rows but showing pag1 of 1  with 10 records at time.please suggest.</p>
<p>My Code</p>
<p>var actionHandlerGrid = &#8220;admin/contact/grid&#8221;;</p>
<p>jQuery(&#8221;#multiple37&#8243;).jqGrid({<br /> url:actionHandlerGrid,<br /> datatype: &#8220;json&#8221;,<br /> height: 255, width: 860,<br /> colNames:[&#39;Index&#39;,&#39;Name&#39;, &#39;Code&#39;],<br /> colModel:[<br /> {name:&#39;id&#39;,index:&#39;id&#39;, width:65, sorttype:&#39;int&#39;},<br /> {name:&#39;country_name&#39;,index:&#39;country_name&#39;, width:150},<br /> {name:&#39;area&#39;,index:&#39;area&#39;, width:100} ],<br /> rowNum:10,<br /> rowTotal: 20,<br /> rowList : [10,30,50],<br /> loadonce:true,<br /> mtype: &#8220;GET&#8221;,<br /> rownumbers: true,<br /> rownumWidth: 40,<br /> gridview: true,<br /> pager: &#8216;#pmultiple37&#8242;,<br /> sortname: &#8216;id&#8217;,<br /> viewrecords: true,<br /> sortorder: &#8220;asc&#8221;,<br /> caption: &#8220;Multiple search on local Data&#8221; });</p>
<p>jQuery(&#8221;#multiple37&#8243;).jqGrid(&#8217;navGrid&#8217;,&#39;#pmultiple37&#8242;,{del:false,add:false,edit:false},{},{},{},{});</p>
</p>
<p>Php Code File Return</p>
</p>
<div class="netInfoResponseText  netInfoText ">
<pre><p><input type='button' class='sfcodeselect' name='sfselectit8623' value='Select Code' data-codeid='sfcode8623' /></p><div class='sfcode' id='sfcode8623'>{"page":"1","total":21,"records":202,"rows":[{"id":"9","cell":["9","Albania","Europe"]}.....</div><p><input type='button' class='sfcodeselect' name='sfselectit5086' value='Select Code' data-codeid='sfcode5086' /></p><div class='sfcode' id='sfcode5086'>}]}</div></pre>
</div>
<p>regards</p>
<p>amit</p>
</div>
</div>
]]></description>
        	        	<pubDate>Thu, 27 May 2010 09:53:53 +0300</pubDate>
        </item>
</channel>
</rss>