<?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: Grid Empty</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/grid-empty</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/grid-empty/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>tony on Grid Empty</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/grid-empty#p6155</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/grid-empty#p6155</guid>
        	        	<description><![CDATA[<p>Hello,</p>
<p>This is not jqGrid problem.</p>
<p>Regards</p>
<p>Tony</p>
]]></description>
        	        	<pubDate>Mon, 20 Apr 2009 06:16:44 +0300</pubDate>
        </item>
        <item>
        	<title>adryano on Grid Empty</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/grid-empty#p6108</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/grid-empty#p6108</guid>
        	        	<description><![CDATA[<p>I use data from php, grid return empty. I see error in fire bug:</p>
<pre>&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;40&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant t1 - assumed &#39;t1&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant fg - assumed &#39;fg&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;40&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant t1 - assumed &#39;t1&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant fg - assumed &#39;fg&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;40&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant t1 - assumed &#39;t1&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant fg - assumed &#39;fg&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;40&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant t1 - assumed &#39;t1&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant fg - assumed &#39;fg&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;40&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant cd - assumed &#39;cd&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant t1 - assumed &#39;t1&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
&#60;br /&#62;
&#60;b&#62;Notice&#60;/b&#62;:  Use of undefined constant fg - assumed &#39;fg&#39; in &#60;b&#62;C:\\wamp\\www\\grid\\g1.php&#60;/b&#62; on line
 &#60;b&#62;41&#60;/b&#62;&#60;br /&#62;
{"page":"1","total":1,"records":"5","rows":[{"cd":"5","cell":["5","hh","10"]},{"cd":"4","cell":["4","nos"
,"4"]},{"cd":"3","cell":["3","ele","3"]},{"cd":"2","cell":["2","tu","2"]},{"cd":"1","cell":["1","eu"
,"1"]}]}</pre>
</p>
<p>My files:</p>
<p>&#60;?php<br />include("grid/dbconfig.php");<br />//since we want to use a JSON data we should include<br />//encoder and decoder for JSON notation<br />//If you use a php &#62;= 5 this file is not needed<br />include("grid/JSON.php");</p>
<p>// create a JSON service<br />$json = new Services_JSON();</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;<br />// connect to the database<br />$db = mysql_connect($dbhost, $dbuser, $dbpassword)<br />or die("Connection Error: " . mysql_error());</p>
<p>mysql_select_db($database) or die("Error conecting to db.");<br />$result = mysql_query("SELECT COUNT(*) AS count FROM tabela_teste");<br />$row = mysql_fetch_array($result,MYSQL_ASSOC);<br />$count = $row[&#39;count&#39;];</p>
<p>if( $count &#62;0 ) {<br />&#160;$total_pages = ceil($count/$limit);<br />} else {<br />&#160;$total_pages = 0;<br />}<br />if ($page &#62; $total_pages) $page=$total_pages;<br />$start = $limit*$page - $limit; // do not put $limit*($page - 1)<br />$SQL = "SELECT cd,t1,fg FROM tabela_teste ORDER BY $sidx $sord LIMIT $start , $limit";<br />$result = mysql_query( $SQL ) or die("Couldn t execute query.".mysql_error());</p>
<p>$responce-&#62;page = $page;<br />$responce-&#62;total = $total_pages;<br />$responce-&#62;records = $count;<br />$i=0;<br />while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {<br />&#160;&#160;&#160; $responce-&#62;rows[$i][&#39;cd&#39;]=$row[cd];<br />&#160;&#160;&#160; $responce-&#62;rows[$i][&#39;cell&#39;]=array($row[cd],$row[t1],$row[fg]);<br />&#160;&#160;&#160; $i++;<br />}&#160;&#160;&#160;&#160;&#160;&#160;&#160; <br />echo json_encode($responce);<br />?&#62;</p>
<p>html:</p>
<p>&#60;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "<a href="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" target="_blank">http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd</a>"&#62;<br />&#60;html xmlns="<a href="http://www.w3.org/1999/xhtml" target="_blank">http://www.w3.org/1999/xhtml</a>"&#62;<br />&#60;head&#62;<br />&#60;meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /&#62;<br />&#60;title&#62;Untitled Document&#60;/title&#62;<br />&#60;!-- In head section we should include the style sheet for the grid --&#62;<br />&#60;link rel="stylesheet" type="text/css" media="screen" href="grid/themes/sand/grid.css" /&#62;</p>
<p>&#60;!-- Of course we should load the jquery library --&#62;<br />&#60;script src="grid/jquery.js" type="text/javascript"&#62;&#60;/script&#62;</p>
<p>&#60;!-- and at end the jqGrid Java Script file --&#62;<br />&#60;script src="grid/jquery.jqGrid.js" type="text/javascript"&#62;&#60;/script&#62;<br />&#60;link rel=&#39;stylesheet&#39; type=&#39;text/css&#39; media=&#39;screen&#39; href=&#39;grid/themes/jqModal.css&#39; /&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/jqDnR.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/jqModal.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/json2.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/grid.locale-pt-br.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/jquery.tablednd.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/grid.base.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/grid.formedit.js&#39;&#62;&#60;/script&#62;<br />&#60;script type=&#39;text/javascript&#39; src=&#39;grid/js/grid.import.js&#39;&#62;&#60;/script&#62;<br />&#60;script type="text/javascript"&#62;<br />jQuery(document).ready(function(){<br />jQuery("#list2").jqGrid({<br />&#160;&#160; &#160;<a href="&#39;http://localhost/grid/g1.php?q=2&#39;" target="_blank">url:&#39;</a><a href="http://localhost/grid/g1.php?q=2&#038;#39" rel="nofollow" target="_blank">http://localhost/grid/g1.php?q=2&#038;#39</a>;,<br />&#160;datatype: "json",<br />&#160;<br />&#160;//mtype: &#39;GET&#39;,<br />&#160;multiselect: true,<br />&#160;toolbar :[true,"bottom"],&#160;&#160; //?? how to use this toolbar ??<br />&#160;&#160; &#160;colNames:[&#39;cd&#39;,&#39;fg&#39;, &#39;t1&#39;],<br />&#160;&#160; &#160;colModel:[<br />&#160;&#160; &#160;&#160;{name:&#39;cd&#39;,index:&#39;cd&#39;, sorttype:"int"},<br />&#160;&#160; &#160;&#160;{name:&#39;fg&#39;,index:&#39;fg&#39;, width:90},<br />&#160;&#160; &#160;&#160;{name:&#39;t1&#39;,index:&#39;t1&#39;, sorttype:"int"}<br />&#160;&#160;<br />&#160;&#160; &#160;],<br />&#160;&#160; &#160;rowNum:5,<br />&#160;&#160; &#160;rowList:[5,20,30],<br />&#160;&#160; &#160;imgpath: &#39;grid/themes/sand/images&#39;,<br />&#160;&#160; &#160;pager: jQuery(&#39;#pager2&#39;),<br />&#160;&#160; &#160;sortname: &#39;cd&#39;,<br />&#160;&#160;&#160; viewrecords: true,<br />&#160;&#160;&#160; sortorder: "desc",<br />&#160;&#160;&#160; caption:"JSON Example"<br />}).navGrid(&#39;#pager2&#39;,{edit:true,add:true,del:true});</p>
<p>});</p>
</p>
<p>&#60;/script&#62;</p>
<p>&#60;/head&#62;</p>
<p>&#60;body&#62;<br />&#60;table id="list2" class="scroll" cellpadding="0" cellspacing="0"&#62;&#60;/table&#62;<br />&#60;div id="pager2" class="scroll" style="text-align:center;"&#62;&#60;/div&#62;</p>
]]></description>
        	        	<pubDate>Thu, 16 Apr 2009 07:37:45 +0300</pubDate>
        </item>
</channel>
</rss>