Guriddo » Topic: Beginer Search box no result please help

Beginer Search box no result please help

Guriddo
Beginer Search box no result please help

This topic has 8 replies, 3 voices, and was last updated 16 years, 4 months ago by admin.

Creator

Topic

December 8, 2009 at 12:15 am #74903

any

Participant

Hello

I've downloaded and installed jqgrid 3.6.1 and succeded in display datas form mysql database. I'm able to sort datas by clicking columns, show 10 20 or 30 records in grid, go to the next records… and open search box. Problem is when I'm click searching datas are not filtered.

Thank you for your help

html page

<span class="doctype"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"></span><br /><<span class="start-tag">html</span><span class="attribute-name"> xmlns</span>=<span class="attribute-value">"http://www.w3.org/1999/xhtml" </span><span class="attribute-name">xml:lang</span>=<span class="attribute-value">"en" </span><span class="attribute-name">lang</span>=<span class="attribute-value">"en"</span>><br /><<span class="start-tag">head</span>><br /><<span class="start-tag">meta</span><span class="attribute-name"> http-equiv</span>=<span class="attribute-value">"Content-Type" </span><span class="attribute-name">content</span>=<span class="attribute-value">"text/html; charset=utf-8"</span>><br /><<span class="start-tag">title</span>>My First Grid</<span class="end-tag">title</span>><br /> <br /><<span class="start-tag">link</span><span class="attribute-name"> rel</span>=<span class="attribute-value">"stylesheet" </span><span class="attribute-name">type</span>=<span class="attribute-value">"text/css" </span><span class="attribute-name">media</span>=<span class="attribute-value">"screen" </span><span class="attribute-name">href</span>=<span class="attribute-value">"css/ui-lightness/jquery-ui-1.7.2.custom.css"</span>><br /><<span class="start-tag">link</span><span class="attribute-name"> rel</span>=<span class="attribute-value">"stylesheet" </span><span class="attribute-name">type</span>=<span class="attribute-value">"text/css" </span><span class="attribute-name">media</span>=<span class="attribute-value">"screen" </span><span class="attribute-name">href</span>=<span class="attribute-value">"css/ui.jqgrid.css"</span>><br /><<span class="start-tag">link</span><span class="attribute-name"> rel</span>=<span class="attribute-value">"stylesheet" </span><span class="attribute-name">type</span>=<span class="attribute-value">"text/css" </span><span class="attribute-name">media</span>=<span class="attribute-value">"screen" </span><span class="attribute-name">href</span>=<span class="attribute-value">"css/jquery.searchFilter.css"</span>><br /> <br /><<span class="start-tag">style</span>><br />html, body {<br />    margin: 0;<br />    padding: 0;<br />    font-size: 75%;<br />}<br /></<span class="end-tag">style</span>><br /><<span class="start-tag">script</span><span class="attribute-name"> src</span>=<span class="attribute-value">"js/jquery-1.3.2.min.js" </span><span class="attribute-name">type</span>=<span class="attribute-value">"text/javascript"</span>></<span class="end-tag">script</span>><br /><<span class="start-tag">script</span><span class="attribute-name"> src</span>=<span class="attribute-value">"js/i18n/grid.locale-fr.js" </span><span class="attribute-name">type</span>=<span class="attribute-value">"text/javascript"</span>></<span class="end-tag">script</span>><br />

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>My First Grid</title> <link rel="stylesheet" type="text/css" media="screen" href="css/ui-lightness/jquery-ui-1.7.2.custom.css"> <link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css"> <link rel="stylesheet" type="text/css" media="screen" href="css/jquery.searchFilter.css"> <style> html, body { margin: 0; padding: 0; font-size: 75%; } </style> <script src="js/jquery-1.3.2.min.js" type="text/javascript"></script> <script src="js/i18n/grid.locale-fr.js" type="text/javascript"></script>

<<span class="start-tag">script</span><span class="attribute-name"> type</span>=<span class="attribute-value">"text/javascript"</span>><br />	jQuery.jgrid.useJSON = true;<br /></<span class="end-tag">script</span>><br /><<span class="start-tag">script</span><span class="attribute-name"> src</span>=<span class="attribute-value">"js/jquery.jqGrid.min.js" </span><span class="attribute-name">type</span>=<span class="attribute-value">"text/javascript"</span>></<span class="end-tag">script</span>><br /><<span class="start-tag">script</span><span class="attribute-name"> type</span>=<span class="attribute-value">"text/javascript"</span>><br />   jQuery.extend(jQuery.jgrid,{<br />      parse:function(jsstring) {<br />         return JSON.parse(jsstring);<br />      }<br />   });<br /></<span class="end-tag">script</span>><br /><br /><br /><br /><br /><<span class="start-tag">script</span><span class="attribute-name"> type</span>=<span class="attribute-value">"text/javascript"</span>><br />jQuery().ready(function (){ <br />  jQuery("#list").jqGrid({<br />    url:&#39;grid.php?q=1&#39;,<br />    datatype: &#39;xml&#39;,<br />    colNames:[&#39;numero&#39;,&#39;organisme&#39;, &#39;maj&#39;],<br />    colModel :[ <br />      {name:&#39;NUM&#39;, index:&#39;numero&#39;, width:55}, <br />      {name:&#39;ORG&#39;, index:&#39;organisme&#39;, width:90}, <br />      {name:&#39;MAJ&#39;, index:&#39;maj&#39;, width:80, align:&#39;right&#39;}<br />    ],<br />    pager: &#39;#pager&#39;,<br />    rowNum:10,<br />    rowList:[10,20,30],<br />    sortname: &#39;numero&#39;,<br />    sortorder: &#39;desc&#39;,<br />    viewrecords: true,<br />    caption: &#39;My first grid&#39;,<br />    sortname: &#39;numero&#39;, <br />        width:800,<br />    height:400,<br /><br />  }); jQuery("#list").jqGrid(&#39;navGrid&#39;,&#39;#pager&#39;,{edit:true,add:false,del:false});<br /><br />jQuery("#s2").click( function() { jQuery("#list").jqGrid(&#39;setGridParam&#39;,{sortname:"numero",sortorder:"asc"}).trigger("reloadGrid");<br />  }); <br />jQuery("#s1").click (function() { jQuery("#list").searchGrid( {sopt:[&#39;cn&#39;,&#39;bw&#39;,&#39;eq&#39;,&#39;ne&#39;,&#39;lt&#39;,&#39;gt&#39;,&#39;ew&#39;]} ); <br /> }); <br />  }); <br /></<span class="end-tag">script</span>><br /> <br /></<span class="end-tag">head</span>><br /><<span class="start-tag">body</span>><br /><<span class="start-tag">table</span><span class="attribute-name"> id</span>=<span class="attribute-value">"list"</span>></<span class="end-tag">table</span>> <br /><<span class="start-tag">div</span><span class="attribute-name"> id</span>=<span class="attribute-value">"pager"</span>></<span class="end-tag">div</span>> <br />

<<span class="start-tag">a</span><span class="attribute-name"> href</span>=<span class="attribute-value">"javascript:void(0)" </span><span class="attribute-name">id</span>=<span class="attribute-value">"s2"</span>>Set Sort to amount column</<span class="end-tag">a</span>><<span class="start-tag">a</span><span class="attribute-name"> href</span>=<span class="attribute-value">"javascript:void(0)" </span><span class="attribute-name">id</span>=<span class="attribute-value">"s1"</span>>Seaerch</<span class="end-tag">a</span>><br /></<span class="end-tag">body</span>><br /></<span class="end-tag">html</span>>

<a href="javascript:void(0)" id="s2">Set Sort to amount column</a><a href="javascript:void(0)" id="s1">Seaerch</a> </body> </html>

<br />php file<br /><br />

1	<br />php file<br /><br />

$limit = $_GET['rows'];


// get index row - i.e. user click to sort. At first time sortname parameter -
// after that the index from colModel 
$sidx = $_GET['sidx']; 
// sorting order - at first time sortorder 
$sord = $_GET['sord']; 
// if we not pass at first time index use the first column for the index or what you want
if(!$sidx) $sidx =1; 
mysql_connect("localhost", "xxxxxx", "xxxxxx") or die("Connection Error: " . mysql_error()); 
mysql_select_db("BDDRIPEINTRANET") or die("Connection Error: " . mysql_error()); 
// calculate the number of rows for the query. We need this for paging the result 
$result = mysql_query("SELECT COUNT(*) AS count FROM organismes"); 
$row = mysql_fetch_array($result,MYSQL_ASSOC); 
$count = $row['count']; 
// calculate the total pages for the query 
if( $count > 0 && $limit > 0) { 
 $total_pages = ceil($count/$limit); 
} else { 
 $total_pages = 0; 
} 
// if for some reasons the requested page is greater than the total 
// set the requested page to total page 
if ($page > $total_pages) $page=$total_pages;
// calculate the starting position of the rows 
$start = $limit*$page - $limit;
// if for some reasons start position is negative set it to 0 
// typical case is that the user type 0 for the requested page 
if($start <0) $start = 0; 
// the actual query for the grid data 
$SQL = "SELECT numero, organisme, maj FROM organismes ORDER BY $sidx $sord LIMIT $start , $limit";
$result = mysql_query( $SQL ) or die("Couldn't execute A.".mysql_error()); 
if ( stristr($_SERVER["HTTP_ACCEPT"],"application/xhtml+xml") ) {
header("Content-type: application/xhtml+xml;charset=utf-8"); } else { 
header("Content-type: text/xml;charset=utf-8"); 
} $et = ">"; 
echo "";
$s .= "".$page."";
$s .= "".$total_pages."";
$s .= "".$count."";
// be sure to put text data in CDATA
while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
 $s .= "";            
 $s .= "". $row[numero]."";
 $s .= "". $row[organisme]."";
 $s .= "";
 $s .= "". $row[maj]."";
 $s .= "";
 $s .= "";
}
$s .= "";

echo $s; ?>

<br />

Creator

Topic

Viewing 8 replies - 1 through 8 (of 8 total)

Author

Replies
December 8, 2009 at 6:22 pm #91305

tony
Keymaster

Hello,

In your script there is nothing when you perform sort. Could you please see how this is done into the demo in order to have idea what to do.

Best Regards

Tony

December 9, 2009 at 1:30 am #91333

admin
Keymaster

Hello

Thank you for you fast reply and sorry for my bad english. I ve developped by myself an application for my job (local authoritiy/international cooperation). Application was at the beginning created on local network with ms access, access data pages and html intranet pages with some js scripts. Now i'm trying to create “real” website with mysql, php… that's new

December 11, 2009 at 1:09 am #91366

tony
Keymaster

Hello,

Sorry, the link does not work for me.

Best Regards

Tony

December 11, 2009 at 6:53 pm #91380

admin
Keymaster

sorry http://www.nord-international.fr/dripe/test%20tableaux/jqgrid.html

thanks again

December 11, 2009 at 6:54 pm #91381

admin
Keymaster

the first one show you where i install jqgrid and : http://www.nord-international.fr/dripe/test%20tableaux/grid.html is my custom example

December 13, 2009 at 5:40 pm #91402

tony
Keymaster

Hello,

For me everthing is working correct. You should check your server side code on how you accept the parameters from

the search dialog and how you perform the serch. Again in the demo package there is such one. Just look at server.php file from

the same package.

Best Regards

Tony

December 14, 2009 at 1:34 pm #91424

admin
Keymaster

Hi

I ve checked server.php and rewritted it completly and kept only the first example case.

still have the datas but can't perfom search.

When i click search button i've got an error jquery.js object required at line 12

below my server.php content

<?php
include(“dbconfig.php”);

$page = $_GET['page'];
$limit = $_GET['rows'];
$sidx = $_GET['sidx'];
$sord = $_GET['sord'];

December 26, 2009 at 8:24 pm #91675

admin
Keymaster

Hello, well I think the reason why your filter isn't working is because of your MySQL syntax. After your FROM table_name statement add WHERE 1 = 1

this way when you try to filter it will work correctly because the php code expects a where clause to already exist and in MySQL you can not have two where clauses as it will return a syntax error.
Author

Replies