<?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: Need help with json data source</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/need-help-with-json-data-source</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/need-help-with-json-data-source/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>jgalak on Need help with json data source</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/need-help-with-json-data-source#p29199</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/need-help-with-json-data-source#p29199</guid>
        	        	<description><![CDATA[<p>I&#39;m very new to PHP/JavaScript/JQuery/JQGrid, so please bear with me.&#160;</p>
<p>I&#39;m trying to set up a very basic grid, just to test how things work.&#160;</p>
<p>Here&#39;s my grid definition:</p>
</p>
<p><input type='button' class='sfcodeselect' name='sfselectit7199' value='Select Code' data-codeid='sfcode7199' /></p>
<div class='sfcode' id='sfcode7199'>
<pre id=&#34;&#34;&#34;line1&#34;&#34;&#34;><span>   </span><span> &#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>script</span> <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>src</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; href=&#34;/blog/&#34;/blog/&#34;/blog/view-source:http:/192.168.1.70/phils/jsgrid/js/jquery-1.9.0.min.js&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank"></a><a rel=&#34;nofollow&#34; href=&#34;http://192.168.1.70/phils/jsgr&#34; target="_blank">http://192.168.1.70/phils/jsgr</a>.....9.0.min.js&#34; <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>type</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank">text/javascript</a>&#34;&#62;</span><span>&#160;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>script</span>&#62;</span><span>
    </span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>script</span> <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>src</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; href=&#34;/blog/&#34;/blog/&#34;/blog/view-source:http:/192.168.1.70/phils/jsgrid/js/i18n/grid.locale-en.js&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank"></a><a rel=&#34;nofollow&#34; href=&#34;http://192.168.1.70/phils/jsgr&#34; target="_blank">http://192.168.1.70/phils/jsgr</a>.....cale-en.js&#34; <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>type</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank">text/javascript</a>&#34;&#62;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>script</span>&#62;</span><span>
    </span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>script</span> <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>src</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; href=&#34;/blog/&#34;/blog/&#34;/blog/view-source:http:/192.168.1.70/phils/jsgrid/js/jquery.jqGrid.min.js&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank"></a><a rel=&#34;nofollow&#34; href=&#34;http://192.168.1.70/phils/jsgr&#34; target="_blank">http://192.168.1.70/phils/jsgr</a>.....rid.min.js&#34; <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>type</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank">text/javascript</a>&#34;&#62;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>script</span>&#62;</span><span>

    </span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>script</span> <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>type</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank">text/javascript</a>&#34;&#62;</span><span>
        $(function()
        {
            $(&#34;#list&#34;).jqGrid(
                {
                    url: &#34;<a rel=&#34;&#34;nofollow&#34;&#34; href=&#34;/blog/&#34;http:/192.168.1.70/phils/js&#38;quot&#34;&#34; target=&#34;_blank&#34; target="_blank">http://192.168.1.70/phils/js&#038;quot</a>;,
                    dataype: &#34;json&#34;,
                    mtype: &#34;GET&#34;,
                    colNames: [&#34;username&#34;, &#34;email&#34;],
                    colModel: [
                        {name: &#34;username&#34;},
                        {name: &#34;email&#34;},
                    ],
                    pager: &#34;#pager&#34;,
                    rowNum: 10,
                    rowList: [10, 20, 30],
                    sortname: &#34;id&#34;,
                    sortorder: &#34;desc&#34;,
                    viewrecords: true,
                    gridview: true,
                    autoencode: true,
                    caption: &#34;My first grid&#34;
                });
        });
    </span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>script</span>&#62;</span><span>

</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>head</span>&#62;</span><span>
</span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>body</span>&#62;</span><span>
    </span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>table</span> <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>id</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank">list</a>&#34;&#62;</span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>tr</span>&#62;</span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>td</span>&#62;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>td</span>&#62;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>tr</span>&#62;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>table</span>&#62;</span><span>
    </span><span>&#60;<span class=&#34;&#34;&#34;start-tag&#34;&#34;&#34;>div</span> <span class=&#34;&#34;&#34;attribute-name&#34;&#34;&#34;>id</span>=&#34;<a class=&#34;&#34;&#34;attribute-value&#34;&#34;&#34; target=&#34;&#34;_blank&#34;&#34; target="_blank">pager</a>&#34;&#62;</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>div</span>&#62;</span><span>

</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>body</span>&#62;</span><span>
</span><span>&#60;/<span class=&#34;&#34;&#34;end-tag&#34;&#34;&#34;>html</span>&#62;</span></pre>
</div>
<pre id="line1"><span><br />Here&#39;s the json (achieved by going to </span><span><a rel="nofollow" href="http://192.168.1.70/phils/js" target="_blank">http://192.168.1.70/phils/js</a> directly):<br /><br /></span><p><input type='button' class='sfcodeselect' name='sfselectit9354' value='Select Code' data-codeid='sfcode9354' /></p><div class='sfcode' id='sfcode9354'>{<br />&#34;total&#34;:&#34;1&#34;,<br />&#34;page&#34;:&#34;1&#34;,<br />&#34;records&#34;:&#34;2&#34;,<br />&#34;rows&#34;:[<br />{&#34;id&#34;:&#34;1&#34;,&#34;cell&#34;:[&#34;test1&#34;,&#34;test@test.com&#34;]},<br />{&#34;id&#34;:&#34;2&#34;,&#34;cell&#34;:[&#34;test2&#34;,&#34;test@test.com&#34;]}<br />]}</div><br />Firefox&#39; web console gives the error "[22:03:18.521] not <br />well-formed @ <a rel="nofollow" href="http://192.168.1.70/phils/jq:1" target="_blank">http://192.168.1.70/phils/jq:1</a>" (thats the file with the grid)<br /><br />Firebug gives the error "H is undefined Line 2" in jqery-1.9.0.min.js<br /><br />I&#39;ve checked and the return type of the json is "application/json".<br /><br />The grid comes up, but contains no data.  Any advice greatly appreciated.</pre>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow: hidden;">&#160;</div>
]]></description>
        	        	<pubDate>Mon, 22 Jul 2013 05:06:31 +0300</pubDate>
        </item>
</channel>
</rss>