<?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: comman php file for all template</title>
	<link>http://www.trirand.com/blog/?page_id=393/help/comman-php-file-for-all-template</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/comman-php-file-for-all-template/rss" rel="self" type="application/rss+xml" />
        <item>
        	<title>ram nihor singh on comman php file for all template</title>
        	<link>http://www.trirand.com/blog/?page_id=393/help/comman-php-file-for-all-template#p11796</link>
        	<category>Help</category>
        	<guid isPermaLink="true">http://www.trirand.com/blog/?page_id=393/help/comman-php-file-for-all-template#p11796</guid>
        	        	<description><![CDATA[<p>hii......</p>
<p>i want to create comman php file which is pass in url for all templates.i have written jquery code in all templates for different listing.i have got only one column data rather than whole data that is main problem any one help me for resolve it.my code is..</p>
</p>
<p>&#60;?php</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 />$table_name=$_GET[&#39;tbname&#39;];<br />$colname=explode(",",$_GET[&#39;col&#39;]);<br />//$colname1=$colname[0];<br />if(!$sidx) $sidx =1;<br />// connect to the database<br />$db = mysql_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;)<br />or die("Connection Error: " . mysql_error());</p>
<p>mysql_select_db(&#39;ourhealt_ourhdb&#39;) or die("Error conecting to db.");<br />$result = mysql_query("SELECT COUNT(*) AS count FROM $table_name");<br />$row = mysql_fetch_array($result,MYSQL_ASSOC);<br />$count = $row[&#39;count&#39;];</p>
<p>if( $count &#62;0 ) {<br />&#160;&#160;&#160; $total_pages = ceil($count/$limit);<br />} else {<br />&#160;&#160;&#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 * FROM $table_name 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;</p>
<p>$i=0;<br />while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {<br />&#160;&#160;&#160; <br />&#160;&#160;&#160; //$responce-&#62;rows[$i][&#39;id&#39;]=$row[id];<br />&#160;&#160;&#160; for($m=0;$m&#60;count($colname);$m++)<br />&#160;&#160;&#160; {<br />&#160;&#160;&#160;&#160;&#160; $responce-&#62;rows[$i][&#39;cell&#39;]=array($row[$colname[$m]]);<br />&#160;&#160;&#160;&#160;&#160; $i++;<br />}&#160;&#160; </p>
<p>}&#160;&#160;&#160;&#160; <br />echo json_encode($responce);</p>
<p>?&#62;</p>
]]></description>
        	        	<pubDate>Wed, 11 Nov 2009 07:14:01 +0200</pubDate>
        </item>
</channel>
</rss>