<?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: Data doesn"t load in the Grid (Json encoding)</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding</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/data-doesnt-load-in-the-grid-json-encoding/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>infsy on Data doesn"t load in the Grid (Json encoding)</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding#p15092</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding#p15092</guid>
        	        	<description><![CDATA[<p>I am ashamed !!!! <img class="spSmiley" style="margin:0" title="Embarassed" src="/blog/wp-content/forum-smileys/sf-embarassed.gif" alt="Embarassed" /></p>
<p>Thank you very much for your help !</p>
]]></description>
        	        	<pubDate>Tue, 23 Feb 2010 12:29:36 +0200</pubDate>
        </item>
        <item>
        	<title>sam zhou on Data doesn"t load in the Grid (Json encoding)</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding#p15062</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding#p15062</guid>
        	        	<description><![CDATA[<p>pls change datatype from xml to json in your js code...</p>
]]></description>
        	        	<pubDate>Tue, 23 Feb 2010 09:37:44 +0200</pubDate>
        </item>
        <item>
        	<title>infsy on Data doesn"t load in the Grid (Json encoding)</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding#p15055</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/data-doesnt-load-in-the-grid-json-encoding#p15055</guid>
        	        	<description><![CDATA[<p>Hi,</p>
</p>
<p>I&#39;m trying to load data in a grid with Json enconding. Everything works fine, except that nothing appear in the Grid !!!???</p>
<p>I shearched in logs something wrong, but no. I verifyed that data is correctly extract from my database (mysql).</p>
<p>I don&#39;t understand what kind of problem could be it.</p>
</p>
<p>Please Help !</p>
<p>Thk&#39;s a lot..</p>
</p>
<p>Configuration :</p>
<p>Jquery 1.4.2 (same problem with 1.3.2)</p>
<p>Jquery-ui 1.7.2</p>
<p>JQgrid 3.6.4.</p>
</p>
<p>My JS file :</p>
</p>
<p><input type='button' class='sfcodeselect' name='sfselectit2758' value='Select Code' data-codeid='sfcode2758' /></p>
<div class='sfcode' id='sfcode2758'>jQuery(document).ready(function(){<br />jQuery(&#34;#list&#34;).jqGrid({<br />&#160;&#160;&#160; url:&#39;../fonctions/ajax/ajax_search.php&#39;,<br />&#160;&#160;&#160; datatype: &#34;xml&#34;,<br />&#160;&#160;&#160; mtype: &#39;GET&#39;,<br />&#160;&#160;&#160; colNames:[&#39;NFic&#39;,&#39;Date&#39;,&#39;Organisme&#39;,&#39;Objet&#39;,&#39;Gravit&#233;&#39;,&#39;Etat&#39;,&#39;Dirisi&#39;,&#39;Cirisi&#39;],<br />&#160;&#160;&#160; colModel:[ {name:&#39;ID&#39;,index:&#39;ID&#39;, width:55},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;Date_Debut&#39;,index:&#39;Date_Debut&#39;, width:90},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;Armee&#39;,index:&#39;Armee&#39;, width:100},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;Libelle&#39;,index:&#39;Libelle&#39;, width:80, align:&#34;right&#34;, sortable:false},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;Gravite&#39;,index:&#39;Gravite&#39;, width:80, align:&#34;right&#34;},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;Etat&#39;,index:&#39;Etat&#39;, width:80,align:&#34;right&#34;},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;dirisi&#39;,index:&#39;dirisi&#39;, width:80,align:&#34;right&#34;},<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; {name:&#39;cirisi&#39;,index:&#39;cirisi&#39;, width:80,align:&#34;right&#34;} ],<br />&#160; rowNum:10,<br />&#160; rowList:[10,20,30],<br />&#160; pager: &#39;#pager&#39;,<br />&#160; sortname: &#39;ID&#39;,<br />&#160; viewrecords: true,<br />&#160; sortorder: &#34;desc&#34;,<br />&#160; caption:&#34;Recherche de Fic&#34; }).navGrid(&#39;#pager&#39;,{edit:false,add:false,del:false});<br />});</div>
<p>My PHP file :</p>
</p>
<p><input type='button' class='sfcodeselect' name='sfselectit5504' value='Select Code' data-codeid='sfcode5504' /></p>
<div class='sfcode' id='sfcode5504'>&#60;?php<br />session_start();</p>
<p>include_once($_SESSION[&#34;chemin&#34;].&#39;/bdd/FicDAO.class.php&#39;);<br />include_once($_SESSION[&#34;chemin&#34;].&#39;/class/Config.class.php&#39;);<br />include_once($_SESSION[&#34;chemin&#34;].&#39;/bdd/FiltreDAO.class.php&#39;);<br />//require_once($_SESSION[&#34;chemin&#34;].&#39;/class/jqGrid/jquery.jqGrid.min.js&#39;);</p>
<p>$page = $_GET[&#39;page&#39;]; // get the requested page<br />$limit = $_GET[&#39;rows&#39;]; // get how many rows we want to have into the grid<br />$sidx = $_GET[&#39;sidx&#39;]; // get index row - i.e. user click to sort<br />$sord = $_GET[&#39;sord&#39;]; // get the direction<br />if(!$sidx) $sidx =1;</p>
<p>$filtres = getFiltreByUser($_SESSION[&#34;ut_id&#34;]);</p>
<p>$dao = new FicDAO();<br />$sql = $dao-&#62;getSQLsearchFic($filtres);<br />$count=$dao-&#62;createViewUser($sql,$_SESSION[&#34;ut_id&#34;]);<br />$dao-&#62;close();</p>
<p>if( $count &#62;0 )<br />&#160;&#160;&#160; { $total_pages = ceil($count/$limit); }<br />&#160;&#160;&#160; else { $total_pages = 0; }<br />if ($page &#62; $total_pages) $page=$total_pages;<br />$start = $limit*$page - $limit; // do not put $limit*($page - 1)</p>
<p>$db = new PDO (&#34;mysql:host=&#34;.Config::$host.&#34;;dbname=&#34;.Config::$database.&#34;&#34;, Config::$user, Config::$pass);<br />$sql=&#34;select ID, Date_Debut, Armee, Libelle, Gravite, Etat, dirisi, cirisi from view&#34;.$_SESSION[&#34;ut_id&#34;]<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; . &#34; ORDER BY $sidx $sord LIMIT $start , $limit&#34;;<br />$db-&#62;exec(&#39;SET CHARACTER SET utf8&#39;);<br />$stm = $db-&#62;query($sql);</p>
<p>$responce-&#62;page = $page;<br />$responce-&#62;total = $total_pages;<br />$responce-&#62;records = $count;</p>
<p>$i=0;<br />while($row = $stm-&#62;fetch(PDO::FETCH_ASSOC)) {<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $responce-&#62;rows[$i][&#39;id&#39;]=$row[&#39;ID&#39;];<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $responce-&#62;rows[$i][&#39;cell&#39;]=array($row[&#39;ID&#39;],$row[&#39;Date_Debut&#39;],$row[&#39;Armee&#39;],$row[&#39;Libelle&#39;],$row[&#39;Gravite&#39;],$row[&#39;Etat&#39;],$row[&#39;dirisi&#39;],$row[&#39;cirisi&#39;]);<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; $i++;<br />&#160;&#160;&#160;&#160;&#160;&#160;&#160; }</p>
<p>echo json_encode($responce);</p>
<p>?&#62;</p>
</div>
]]></description>
        	        	<pubDate>Mon, 22 Feb 2010 19:54:14 +0200</pubDate>
        </item>
</channel>
</rss>