romaneduardo on single search not working

Sat, 05 Jun 2010 02:32:15 +0300

Hi Tim.

Thanks for your response.

It was certainly a problem in PHP to SQL.

I mistakenly thought Jqgrid did everything. And of course, PHP and MYSQL code must be written by each user. Mainly MYSQL code for search functions.

The search module works for me as it is, but it was a difficult task to achieve.

For anyone who has the same doubt, the lesson learned is that: the code to execute searches with Jqgrid must be written yourself. The demos are just that, demos!

Thanks again Tim.

tim on single search not working

Sun, 30 May 2010 01:58:56 +0300

This is a PHP to SQL issue, not a jqGrid issue.

From what I can see, not understanding anything about PHP, your

case 'invid':

is not being applied to the varialbe $wh

To troubleshoot this put your debugger on and look at the output for $wh inside your

switch ($examp) {
case 1:

statement.

or just look at the actual SQL being sent to the database.

tim

romaneduardo on single search not working

Sun, 30 May 2010 01:15:01 +0300

( apologize, and publish this post but do not see )

I do not understand why it does not work.

execute search

I hope, one row with result INV NO 654

but result same

my files:

grid.php

<!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>Primera matriz</title>

<link rel="stylesheet" type="text/css" media="screen" href="css/vader/jquery-ui-1.8.custom.css" />
<link rel="stylesheet" type="text/css" media="screen" href="css/ui.jqgrid.css" />

<script src="js/jquery-1.4.2.min.js" type="text/javascript"></script>
<script src="js/i18n/grid.locale-sp.js" type="text/javascript"></script>
<script src="js/jquery.jqGrid.min.js" type="text/javascript"></script>

</head>
<body>
<table id="list"></table>
<div id="pager"></div>
</body>
</html>

ejemplo.php

<?php
include("dbconfig.php");
// coment the above lines if php 5
//include("JSON.php");
//$json = new Services_JSON();
// end comment
$examp = $_REQUEST["q"]; //query number

$page = $_REQUEST['page']; // get the requested page
$limit = $_REQUEST['rows']; // get how many rows we want to have into the grid
$sidx = $_REQUEST['sidx']; // get index row - i.e. user click to sort
$sord = $_REQUEST['sord']; // get the direction
if(!$sidx) $sidx =1;

$wh = "";
$searchOn = Strip($_REQUEST['_search']);
if($searchOn=='true') {
   $sarr = Strip($_REQUEST);
   foreach( $sarr as $k=>$v) {
       switch ($k) {
           case 'invid':
           case 'invdate':
           case 'note':
               $wh .= " AND ".$k." LIKE '".$v."%'";
               break;
           case 'amount':
           case 'tax':
           case 'total':
               $wh .= " AND ".$k." = ".$v;
               break;
       }
   }
}
//echo $wh;
// connect to the database
$db = mysql_connect($dbhost, $dbuser, $dbpassword)
or die("Connection Error: " . mysql_error());

mysql_select_db($dbs) or die("Error conecting to db.");

switch ($examp) {
    case 1:
       $result = mysql_query("SELECT COUNT(*) AS count FROM invheader".$wh);
       $row = mysql_fetch_array($result,MYSQL_ASSOC);
       $count = $row['count'];

       if( $count >0 ) {
           $total_pages = ceil($count/$limit);
       } else {
           $total_pages = 0;
       }
        if ($page > $total_pages) $page=$total_pages;
       $start = $limit*$page - $limit; // do not put $limit*($page - 1)
        if ($start<0) $start = 0;
        $SQL = "SELECT invid, invdate, amount, tax,total, note FROM invheader".$wh." ORDER BY ".$sidx." ".$sord. " LIMIT ".$start." , ".$limit;
       $result = mysql_query( $SQL ) or die("Could not execute query.".mysql_error());
        $responce->page = $page;
        $responce->total = $total_pages;
        $responce->records = $count;
        $i=0;
       while($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
           $responce->rows[$i]['invid']=$row['invid'];
            $responce->rows[$i]['cell']=array($row['invid'],$row['invdate'],$row['amount'],$row['tax'],$row['total'],$row['note']);
            $i++;
       }
       //echo $json->encode($responce); // coment if php 5
        echo json_encode($responce);

        break;
    case 3:
}
mysql_close($db);

Help, please.

jQuery Grid Plugin - jqGrid - Topic: single search not working

romaneduardo on single search not working

tim on single search not working

romaneduardo on single search not working