<?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: Help: load data in json format using ci</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/help-load-data-in-json-format-using-ci</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/help-load-data-in-json-format-using-ci/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>pohondigital on Help: load data in json format using ci</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/help-load-data-in-json-format-using-ci#p27446</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/help-load-data-in-json-format-using-ci#p27446</guid>
        	        	<description><![CDATA[<p>first, sory if my english is not good..</p>
<p>i develop a web using code igniter, and i have trouble when i want to load data to my grid</p>
<p>this is my code: the controller</p>
<div class="sfspoiler">
<div class="sfreveal"><a onclick="sfjtoggleLayer(&#39;sfspoilercontent1&#39;);" href="javascript:void(0);">Reveal Spoiler</a></div>
<div id="sfspoilercontent1" class="sfspoilercontent">
<p>&#60;?php if(!defined(&#39;BASEPATH&#39;)) exit (&#39;No direct script access allowed&#39;);</p>
<p>class Buku extends CI_Controller{<br />&#160;&#160; &#160;function __construct(){<br />&#160;&#160; &#160;&#160;&#160; &#160;parent::__construct();<br />&#160;&#160; &#160;&#160;&#160; &#160;$this-&#62;load-&#62;model(&#39;m_buku&#39;);<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160;<br />&#160;&#160; &#160;function index(){<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160;<br />&#160;&#160; &#160;function Tampilkan_buku(){<br />&#160;&#160; &#160;&#160;&#160; &#160;$data = $this-&#62;m_buku-&#62;tampilkan_buku();<br />&#160;&#160; &#160;&#160;&#160; &#160;$this-&#62;load-&#62;view(&#39;daftar_buku&#39;,json_encode($data));<br />&#160;&#160; &#160;}</p>
<p>}</p>
<p>/* End of file buku.php */<br />/* Location: ./application/controllers/buku.php */</p>
</p>
</div>
</div>
<p>the model</p>
<div class="sfspoiler">
<div class="sfreveal"><a onclick="sfjtoggleLayer(&#39;sfspoilercontent2&#39;);" href="javascript:void(0);">Reveal Spoiler</a></div>
<div id="sfspoilercontent2" class="sfspoilercontent">
<p>&#60;?php if(!defined(&#39;BASEPATH&#39;)) exit (&#39;No direct script access allowed&#39;);</p>
<p>class M_Buku extends CI_Model{<br />&#160;&#160; &#160;function __construct(){<br />&#160;&#160; &#160;&#160;&#160; &#160;parent::__construct();<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160;<br />&#160;&#160; &#160;function Total_record(){<br />&#160;&#160; &#160;&#160;&#160; &#160;return $this-&#62;db-&#62;count_all(&#39;tbl_buku&#39;);<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160;<br />&#160;&#160; &#160;function Tampilkan_buku(){<br />&#160;&#160; &#160;&#160;&#160; &#160;return $this-&#62;db-&#62;get(&#39;tbl_buku&#39;)-&#62;result_array();<br />&#160;&#160; &#160;}<br />&#160;&#160; &#160;<br />}</p>
<p>/* End of file model_buku.php */<br />/* Location: ./application/models/model_buku.php */</p>
</p>
</div>
</div>
<p>the views</p>
<div class="sfspoiler">
<div class="sfreveal"><a onclick="sfjtoggleLayer(&#39;sfspoilercontent3&#39;);" href="javascript:void(0);">Reveal Spoiler</a></div>
<div id="sfspoilercontent3" class="sfspoilercontent">
<p>&#60;body&#62;<br />&#60;table id="tabel_buku"&#62;&#60;/table&#62;<br />&#60;div id="pager2&#8243;&#62;&#60;/div&#62;</p>
<p>&#60;/body&#62;<br />&#60;/html&#62;</p>
<p>&#60;script type="text/javascript"&#62;<br />&#160;&#160; &#160;$(document).ready(function(){<br />&#160;&#160; &#160;&#160;&#160; &#160;jQuery("#tabel_buku").jqGrid({ <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;url: &#39;&#60;?=base_url();?&#62;buku/tampilkan_buku&#39;,<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;datatype: "json", <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;colNames:[&#39;Kode Buku&#39;,&#39;Judul Buku&#39;, &#39;Pengarang&#39;, &#39;Penerbit&#39;,&#39;Tahun&#39;,&#39;Jumlah&#39;,&#39;Keterangan&#39;], <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;colModel:[ {name:&#39;kode_buku&#39;, index:&#39;kode_buku&#39;,&#160; width:100}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;judul_buku&#39;,index:&#39;judul_buku&#39;, width:300},<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;pengarang&#39;, index:&#39;pengarang&#39;,&#160; width:100}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;penerbit&#39;,&#160; index:&#39;penerbit&#39;,&#160;&#160; width:100, align:"right"}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;tahun&#39;,&#160;&#160;&#160;&#160; index:&#39;tahun&#39;,&#160;&#160;&#160;&#160;&#160; width:80, align:"right"}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;jumlah&#39;,&#160;&#160;&#160; index:&#39;jumlah&#39;,&#160;&#160;&#160;&#160; width:50, align:"right"}, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; {name:&#39;keterangan&#39;,index:&#39;keterangan&#39;, width:150, sortable:false} <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;], <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;rowNum:20, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;rowList:[20,40,60],<br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;pager: &#39;#pager2&#39;, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;sortname: &#39;kode_buku&#39;, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;viewrecords: true, <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;sortorder: "desc", <br />&#160;&#160; &#160;&#160;&#160; &#160;&#160;&#160; &#160;caption:"Daftar Buku" <br />&#160;&#160; &#160;&#160;&#160; &#160;}); <br />&#160;&#160; &#160;&#160;&#160; &#160;<br />&#160;&#160; &#160;&#160;&#160; &#160;jQuery("#tabel_buku").jqGrid(&#39;navGrid&#39;,&#39;#pager2&#39;,{edit:false,add:false,del:false});<br />&#160;&#160; &#160;});<br />&#60;/script&#62;</p>
</p>
</div>
</div>
]]></description>
        	        	<pubDate>Sun, 30 Sep 2012 13:50:34 +0300</pubDate>
        </item>
</channel>
</rss>