Guriddo » Topic: jqgrid passIng two parameters SELECT … FROM … WHERE … = $param1,$param2

jqgrid passIng two parameters SELECT … FROM … WHERE … = $param1,$param2

Guriddo
jquery passing parameters
jqgrid passIng two parameters SELECT … FROM … WHERE … = $param1,$param2

Tagged: jquery passing parameters

This topic has 2 replies, 2 voices, and was last updated 10 years, 8 months ago by JL.

Creator

Topic

September 24, 2015 at 12:03 pm #124383

Participant

Hello new window with right data, but the jqgrid is empty ,

First, thank you for your grid.

I meet a problem with passing to parameters to the jqgrid. I have read the posts and I have followed the published solutions, but none works.

Here is my code.

Quote:

&lt;?php
require_once &#039;../../jq-config_dps.php&#039;;
// include the jqGrid Class
require_once ABSPATH.&quot;php/PHPSuito/jqGrid.php&quot;;
// include the driver class
require_once ABSPATH.&quot;php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;
// Connection to the server
$nxs = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
// Tell the db that we use utf-8
$nxs-&gt;query(&quot;SET NAMES utf8&quot;);

//La date du mois
$annee = &#039;2015&#039;;
$mois = &#039;09&#039;;
//$jour = now.getDate();
$tpsDbt = $annee.&#039;-&#039;.$mois.&#039;-&#039;.&#039;01&#039;;
$tpsFin = $annee.&#039;-&#039;.$mois.&#039;-&#039;.&#039;30&#039;;

echo $tpsDbt;

// requête préparée
$query = &quot;SELECT dpsID, dpsQui, dpsQuoi, dpsPrx, dpsQud, dpsUbi, dpsCrdCrt, dpsPaiement, dpsDmn, dpsCtg, dpsGns, dpsSpc, dpsDfr, dpsTag, dpsVcc FROM dps WHERE dpsQud &gt;= ? and dpsQud &lt;= ?&quot;;
// Create the jqGrid instance
$grid = new jqGridRender($nxs);
// Write the SQL Query
$grid-&gt;SelectCommand = $query;
// Set the table to where you add the data
$grid-&gt;table = &#039;dps&#039;;
$grid-&gt;setPrimaryKeyId(&#039;dpsID&#039;);
// Set output format to json
$grid-&gt;dataType = &#039;json&#039;;
// Let the grid create the model
$grid-&gt;setColModel(null, array($tpsDbt,$tpsFin));
//$grid-&gt;queryGrid(null, array($tpsDbt,$tpsFin));
// Set the url from where we obtain the data
$grid-&gt;setUrl(&#039;grid.php&#039;);
$grid-&gt;addCol(array(&quot;name&quot;=&gt;&quot;Actions&quot;,&quot;formatter&quot;=&gt;&quot;actions&quot;,&quot;editable&quot;=&gt;false,&quot;sortable&quot;=&gt;false,&quot;resizable&quot;=&gt;false,&quot;fixed&quot;=&gt;true,&quot;width&quot;=&gt;60,&quot;formatoptions&quot;=&gt;array(&quot;keys&quot;=&gt;true) ),&quot;first&quot;);

$grid-&gt;setColProperty(&quot;dpsQud&quot;, array(&quot;name&quot;=&gt;&quot;Quand&quot;,&quot;formatter&quot;=&gt;&quot;date&quot;,&quot;formatoptions&quot;=&gt;array(&quot;reformatAfterEdit&quot;=&gt;true, &quot;srcformat&quot;=&gt;&quot;Y-m-d&quot;,&quot;newformat&quot;=&gt;&quot;m/d/Y&quot;)));
// Set some grid options
$grid-&gt;setGridOptions(array(&quot;rowNum&quot;=&gt;30,&quot;rowList&quot;=&gt;array(30,60,90),&quot;sortname&quot;=&gt;&quot;dpsQud&quot;));
// Enable footerdata an tell the grid to obtain it from the request
$grid-&gt;setGridOptions(array(&quot;footerrow&quot;=&gt;true,&quot;userDataOnFooter&quot;=&gt;true));
// Enable footerdata an tell the grid to obtain it from the request
$grid-&gt;setGridOptions(array(&quot;footerrow&quot;=&gt;true,&quot;userDataOnFooter&quot;=&gt;true));
// At end call footerData to put total label
$grid-&gt;callGridMethod(&#039;#grid&#039;, &#039;footerData&#039;, array(&quot;set&quot;,array(&quot;dpsQuoi&quot;=&gt;&quot;Total:&quot;)));
// Set which parameter to be sumarized
$summaryrows = array(&quot;dpsPrx&quot;=&gt;array(&quot;dpsPrx&quot;=&gt;&quot;SUM&quot;));
// Date formatting and settings - editing
$grid-&gt;setDbDate(&#039;Y-m-d&#039;);
//$grid-&gt;setDbTime(&#039;Y-m-d H:i:s&#039;);
//User date see formatter data. Birthdate is a defined as datetime
$grid-&gt;setUserDate(&#039;Y-m-d&#039;);
// the same as formatter
//$grid-&gt;setUserTime(&#039;Y-m-d&#039;);
// serching date
$grid-&gt;datearray = array(&#039;dpsQud&#039;);
// Enable toolbar searching
$grid-&gt;navigator = true;
$grid-&gt;setNavOptions(&#039;navigator&#039;, array(&quot;del&quot;=&gt;true,&quot;search&quot;=&gt;true,&quot;refresh&quot;=&gt;true));
$grid-&gt;setNavOptions(&#039;edit&#039;, array(&quot;height&quot;=&gt;&#039;auto&#039;,&quot;dataheight&quot;=&gt;&quot;auto&quot;, &quot;width&quot;=&gt;&quot;auto&quot;, &quot;reloadAfterSubmit&quot;=&gt;true));
$grid-&gt;setNavOptions(&#039;add&#039;, array(&quot;height&quot;=&gt;&#039;auto&#039;,&quot;dataheight&quot;=&gt;&quot;auto&quot;, &quot;width&quot;=&gt;&quot;auto&quot;, &quot;reloadAfterSubmit&quot;=&gt;true));
// Enjoy
$grid-&gt;renderGrid(&#039;#grid&#039;,&#039;#pager&#039;,true, $summaryrows, array($tpsDbt,$tpsFin), true,true);

<?php

require_once '../../jq-config_dps.php';

// include the jqGrid Class

require_once ABSPATH."php/PHPSuito/jqGrid.php";

// include the driver class

require_once ABSPATH."php/PHPSuito/DBdrivers/jqGridPdo.php";

// Connection to the server

$nxs = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

// Tell the db that we use utf-8

$nxs->query("SET NAMES utf8");

//La date du mois

$annee = '2015';

$mois = '09';

//$jour = now.getDate();

$tpsDbt = $annee.'-'.$mois.'-'.'01';

$tpsFin = $annee.'-'.$mois.'-'.'30';

echo $tpsDbt;

// requête préparée

$query = "SELECT dpsID, dpsQui, dpsQuoi, dpsPrx, dpsQud, dpsUbi, dpsCrdCrt, dpsPaiement, dpsDmn, dpsCtg, dpsGns, dpsSpc, dpsDfr, dpsTag, dpsVcc FROM dps WHERE dpsQud >= ? and dpsQud <= ?";

// Create the jqGrid instance

$grid = new jqGridRender($nxs);

// Write the SQL Query

$grid->SelectCommand = $query;

// Set the table to where you add the data

$grid->table = 'dps';

$grid->setPrimaryKeyId('dpsID');

// Set output format to json

$grid->dataType = 'json';

// Let the grid create the model

$grid->setColModel(null, array($tpsDbt,$tpsFin));

//$grid->queryGrid(null, array($tpsDbt,$tpsFin));

// Set the url from where we obtain the data

$grid->setUrl('grid.php');

$grid->addCol(array("name"=>"Actions","formatter"=>"actions","editable"=>false,"sortable"=>false,"resizable"=>false,"fixed"=>true,"width"=>60,"formatoptions"=>array("keys"=>true) ),"first");

$grid->setColProperty("dpsQud", array("name"=>"Quand","formatter"=>"date","formatoptions"=>array("reformatAfterEdit"=>true, "srcformat"=>"Y-m-d","newformat"=>"m/d/Y")));

// Set some grid options

$grid->setGridOptions(array("rowNum"=>30,"rowList"=>array(30,60,90),"sortname"=>"dpsQud"));

// Enable footerdata an tell the grid to obtain it from the request

$grid->setGridOptions(array("footerrow"=>true,"userDataOnFooter"=>true));

// Enable footerdata an tell the grid to obtain it from the request

$grid->setGridOptions(array("footerrow"=>true,"userDataOnFooter"=>true));

// At end call footerData to put total label

$grid->callGridMethod('#grid', 'footerData', array("set",array("dpsQuoi"=>"Total:")));

// Set which parameter to be sumarized

$summaryrows = array("dpsPrx"=>array("dpsPrx"=>"SUM"));

// Date formatting and settings - editing

$grid->setDbDate('Y-m-d');

//$grid->setDbTime('Y-m-d H:i:s');

//User date see formatter data. Birthdate is a defined as datetime

$grid->setUserDate('Y-m-d');

// the same as formatter

//$grid->setUserTime('Y-m-d');

// serching date

$grid->datearray = array('dpsQud');

// Enable toolbar searching

$grid->navigator = true;

$grid->setNavOptions('navigator', array("del"=>true,"search"=>true,"refresh"=>true));

$grid->setNavOptions('edit', array("height"=>'auto',"dataheight"=>"auto", "width"=>"auto", "reloadAfterSubmit"=>true));

$grid->setNavOptions('add', array("height"=>'auto',"dataheight"=>"auto", "width"=>"auto", "reloadAfterSubmit"=>true));

// Enjoy

$grid->renderGrid('#grid','#pager',true, $summaryrows, array($tpsDbt,$tpsFin), true,true);

The query works, the right data appear, but in a new window!, while on the page, the grid is empty: see the attached image.

If I try with

$grid -> $querygrid(null, array($tpsDbt,$tpsFin));

then all appear in plain text, see below

Quote:

&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;meta charset=&quot;UTF-8&quot;&gt;
&lt;title&gt;jqGrid PHP Demo&lt;/title&gt;
&lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;../../../../css/jquery-ui.css&quot; /&gt;
&lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;../../../../css/trirand/ui.jqgrid.css&quot; /&gt;
&lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;../../../../css/ui.multiselect.css&quot; /&gt;
&lt;link rel=&quot;stylesheet&quot; type=&quot;text/css&quot; media=&quot;screen&quot; href=&quot;hr_css.css&quot; /&gt;
&lt;style type=&quot;text&quot;&gt;
html, body {
margin: 0; /* Remove body margin/padding */
padding: 0;
overflow: hidden; /* Remove scroll bars on browser window */
font-size: 75%;
}&lt;/style&gt;
&lt;script src=&quot;../../../../js/jquery.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;../../../../js/trirand/i18n/grid.locale-en.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;../../../../js/trirand/jquery.jqGrid.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt; &lt;script type=&quot;text/javascript&quot;&gt;
$.jgrid.no_legacy_api = true;
$.jgrid.useJSON = true;
$.jgrid.defaults.width = &quot;2100&quot;;
$.jgrid.defaults.height = &quot;100%&quot;;
&lt;/script&gt;&lt;script src=&quot;../../../../js/jquery-ui.min.js&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
&lt;script&gt;
//session_start();
//$tpsDbt=$_POST[&#039;tpsDbt&#039;];
//$_SESSION[&#039;tpsDbt&#039;]=$tpsDbt;
&lt;/script&gt;
&lt;/head&gt;
&lt;body&gt;

<!DOCTYPE html>

<html>

<head>

<title>jqGrid PHP Demo</title>

html, body {

margin: 0; /* Remove body margin/padding */

padding: 0;

overflow: hidden; /* Remove scroll bars on browser window */

font-size: 75%;

}</style>

$.jgrid.no_legacy_api = true;

$.jgrid.useJSON = true;

$.jgrid.defaults.width = "2100";

$.jgrid.defaults.height = "100%";

</script><script src="../../../../js/jquery-ui.min.js" type="text/javascript"></script>

//session_start();

//$tpsDbt=$_POST['tpsDbt'];

//$_SESSION['tpsDbt']=$tpsDbt;

</script>

</head>

<body>


2015-09-01{&quot;records&quot;:&quot;20&quot;,&quot;page&quot;:1,&quot;total&quot;:1,&quot;rows&quot;:[{&quot;dpsID&quot;:&quot;316&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;tpg&quot;,&quot;dpsPrx&quot;:&quot;3.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-01&quot;,&quot;dpsUbi&quot;:&quot;www&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;transports&quot;,&quot;dpsCtg&quot;:&quot;transports publics&quot;,&quot;dpsGns&quot;:&quot;tpg&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;317&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;csm prs&quot;,&quot;dpsPrx&quot;:&quot;9.70&quot;,&quot;dpsQud&quot;:&quot;2015-09-01&quot;,&quot;dpsUbi&quot;:&quot;point coop&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;csm&quot;,&quot;dpsCtg&quot;:&quot;prs&quot;,&quot;dpsGns&quot;:&quot;&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;320&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;csm prs&quot;,&quot;dpsPrx&quot;:&quot;1.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-01&quot;,&quot;dpsUbi&quot;:&quot;SDL&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;csm&quot;,&quot;dpsCtg&quot;:&quot;prs&quot;,&quot;dpsGns&quot;:&quot;boissons&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;325&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;csm prs&quot;,&quot;dpsPrx&quot;:&quot;11.30&quot;,&quot;dpsQud&quot;:&quot;2015-09-02&quot;,&quot;dpsUbi&quot;:&quot;p\u00e2tisserie rue du rh\u00f4ne&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;csm&quot;,&quot;dpsCtg&quot;:&quot;prs&quot;,&quot;dpsGns&quot;:&quot;nourriture&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;326&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;dons&quot;,&quot;dpsPrx&quot;:&quot;1.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-02&quot;,&quot;dpsUbi&quot;:&quot;place bel-air&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;rue&quot;,&quot;dpsGns&quot;:&quot;&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;328&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;csm prs boissons&quot;,&quot;dpsPrx&quot;:&quot;3.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-02&quot;,&quot;dpsUbi&quot;:&quot;grand-rue&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;csm&quot;,&quot;dpsCtg&quot;:&quot;prs&quot;,&quot;dpsGns&quot;:&quot;boissons&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;330&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;parking&quot;,&quot;dpsPrx&quot;:&quot;1.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-05&quot;,&quot;dpsUbi&quot;:&quot;parking cornavin&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;transports&quot;,&quot;dpsCtg&quot;:&quot;voiture&quot;,&quot;dpsGns&quot;:&quot;parking&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;331&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;dons qu\u00eate&quot;,&quot;dpsPrx&quot;:&quot;17.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-06&quot;,&quot;dpsUbi&quot;:&quot;Notre-Dame&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;\u00e9glise&quot;,&quot;dpsGns&quot;:&quot;qu\u00eate&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;332&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;vincent&quot;,&quot;dpsPrx&quot;:&quot;400.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-05&quot;,&quot;dpsUbi&quot;:&quot;maison&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;enfants&quot;,&quot;dpsCtg&quot;:&quot;vincent&quot;,&quot;dpsGns&quot;:&quot;crt&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;333&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;cadeau no\u00e9mie&quot;,&quot;dpsPrx&quot;:&quot;210.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-09&quot;,&quot;dpsUbi&quot;:&quot;la cadrerie&quot;,&quot;dpsCrdCrt&quot;:&quot;1&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;cadeaux&quot;,&quot;dpsCtg&quot;:&quot;enfants&quot;,&quot;dpsGns&quot;:&quot;nom\u00e9ie&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;334&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;\u00e9glise qu\u00eate&quot;,&quot;dpsPrx&quot;:&quot;10.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-09&quot;,&quot;dpsUbi&quot;:&quot;Saint-joseph Gabrielle Dufour Kowalska&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;\u00e9glise&quot;,&quot;dpsGns&quot;:&quot;qu\u00eate&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;335&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;csm prs&quot;,&quot;dpsPrx&quot;:&quot;4.50&quot;,&quot;dpsQud&quot;:&quot;2015-09-09&quot;,&quot;dpsUbi&quot;:&quot;coop rue du rh\u00f4ne&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;csm&quot;,&quot;dpsCtg&quot;:&quot;prs&quot;,&quot;dpsGns&quot;:&quot;nourriture&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;336&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;dons&quot;,&quot;dpsPrx&quot;:&quot;2.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-09&quot;,&quot;dpsUbi&quot;:&quot;rue&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;rue&quot;,&quot;dpsGns&quot;:&quot;&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;337&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;csm prs nourriture&quot;,&quot;dpsPrx&quot;:&quot;4.75&quot;,&quot;dpsQud&quot;:&quot;2015-09-16&quot;,&quot;dpsUbi&quot;:&quot;p\u00e2tisserie rue du rh\u00f4ne&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;csm&quot;,&quot;dpsCtg&quot;:&quot;prs&quot;,&quot;dpsGns&quot;:&quot;nourriture&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;338&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;dons place bel-air cor&quot;,&quot;dpsPrx&quot;:&quot;1.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-16&quot;,&quot;dpsUbi&quot;:&quot;place bel-air&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;rue&quot;,&quot;dpsGns&quot;:&quot;musique&quot;,&quot;dpsSpc&quot;:&quot;cor des alpes&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;339&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;cadeau&quot;,&quot;dpsPrx&quot;:&quot;89.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-22&quot;,&quot;dpsUbi&quot;:&quot;la com\u00e9die&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;cadeaux&quot;,&quot;dpsGns&quot;:&quot;anniversaire&quot;,&quot;dpsSpc&quot;:&quot;UJ&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;340&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;dons&quot;,&quot;dpsPrx&quot;:&quot;3.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-22&quot;,&quot;dpsUbi&quot;:&quot;la com\u00e9die&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;dons&quot;,&quot;dpsCtg&quot;:&quot;pourboire&quot;,&quot;dpsGns&quot;:&quot;&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;pourboire&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;341&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;t\u00e9l\u00e9phone portable 160120&quot;,&quot;dpsPrx&quot;:&quot;150.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-20&quot;,&quot;dpsUbi&quot;:&quot;www&quot;,&quot;dpsCrdCrt&quot;:&quot;1&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;fml&quot;,&quot;dpsCtg&quot;:&quot;160120&quot;,&quot;dpsGns&quot;:&quot;&quot;,&quot;dpsSpc&quot;:&quot;&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;342&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;don cadeau anniversaire marc&quot;,&quot;dpsPrx&quot;:&quot;100.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-22&quot;,&quot;dpsUbi&quot;:&quot;cure ch\u00eane-bourg&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;don&quot;,&quot;dpsCtg&quot;:&quot;cadeau&quot;,&quot;dpsGns&quot;:&quot;anniversaire&quot;,&quot;dpsSpc&quot;:&quot;marc passera&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;don cadeau anniversaire&quot;,&quot;dpsVcc&quot;:&quot;0&quot;},{&quot;dpsID&quot;:&quot;343&quot;,&quot;dpsQui&quot;:&quot;prs&quot;,&quot;dpsQuoi&quot;:&quot;don \u00e9cole vente p\u00e2tisseries&quot;,&quot;dpsPrx&quot;:&quot;5.00&quot;,&quot;dpsQud&quot;:&quot;2015-09-23&quot;,&quot;dpsUbi&quot;:&quot;pont-de-la-machine&quot;,&quot;dpsCrdCrt&quot;:&quot;0&quot;,&quot;dpsPaiement&quot;:&quot;0&quot;,&quot;dpsDmn&quot;:&quot;don&quot;,&quot;dpsCtg&quot;:&quot;rue&quot;,&quot;dpsGns&quot;:&quot;\u00e9cole &quot;,&quot;dpsSpc&quot;:&quot;vente de p\u00e2tisseries&quot;,&quot;dpsDfr&quot;:&quot;&quot;,&quot;dpsTag&quot;:&quot;don rue \u00e9cole&quot;,&quot;dpsVcc&quot;:&quot;0&quot;}]}&lt;table id=&#039;grid&#039;&gt;&lt;/table&gt;
&lt;div&gt;&lt;/div&gt;
&lt;script type=&#039;text/javascript&#039;&gt;jQuery(document).ready(function($) {jQuery(&#039;#grid&#039;).jqGrid({&quot;hoverrows&quot;:false,&quot;viewrecords&quot;:true,&quot;jsonReader&quot;:{&quot;repeatitems&quot;:false,&quot;subgrid&quot;:{&quot;repeatitems&quot;:false}},&quot;xmlReader&quot;:{&quot;repeatitems&quot;:false,&quot;subgrid&quot;:{&quot;repeatitems&quot;:false}},&quot;gridview&quot;:true,&quot;url&quot;:&quot;grid.php&quot;,&quot;editurl&quot;:&quot;grid.php&quot;,&quot;cellurl&quot;:&quot;grid.php&quot;,&quot;rowNum&quot;:30,&quot;rowList&quot;:[30,60,90],&quot;sortname&quot;:&quot;dpsQud&quot;,&quot;footerrow&quot;:true,&quot;userDataOnFooter&quot;:true,&quot;datatype&quot;:&quot;json&quot;,&quot;colModel&quot;:[],&quot;postData&quot;:{&quot;oper&quot;:&quot;grid&quot;},&quot;prmNames&quot;:{&quot;page&quot;:&quot;page&quot;,&quot;rows&quot;:&quot;rows&quot;,&quot;sort&quot;:&quot;sidx&quot;,&quot;order&quot;:&quot;sord&quot;,&quot;search&quot;:&quot;_search&quot;,&quot;nd&quot;:&quot;nd&quot;,&quot;id&quot;:&quot;dpsID&quot;,&quot;filter&quot;:&quot;filters&quot;,&quot;searchField&quot;:&quot;searchField&quot;,&quot;searchOper&quot;:&quot;searchOper&quot;,&quot;searchString&quot;:&quot;searchString&quot;,&quot;oper&quot;:&quot;oper&quot;,&quot;query&quot;:&quot;grid&quot;,&quot;addoper&quot;:&quot;add&quot;,&quot;editoper&quot;:&quot;edit&quot;,&quot;deloper&quot;:&quot;del&quot;,&quot;excel&quot;:&quot;excel&quot;,&quot;subgrid&quot;:&quot;subgrid&quot;,&quot;totalrows&quot;:&quot;totalrows&quot;,&quot;autocomplete&quot;:&quot;autocmpl&quot;},&quot;loadError&quot;:function(xhr,status, err){ try {jQuery.jgrid.info_dialog(jQuery.jgrid.errors.errcap,&#039;
&lt;div class=&quot;ui-state-error&quot;&gt;&#039;+ xhr.responseText +&#039;&lt;/div&gt;
&#039;, jQuery.jgrid.edit.bClose,{buttonalign:&#039;right&#039;});} catch(e) { alert(xhr.responseText);} },&quot;pager&quot;:&quot;#pager&quot;});jQuery(&#039;#grid&#039;).jqGrid(&#039;navGrid&#039;,&#039;#pager&#039;,{&quot;edit&quot;:true,&quot;add&quot;:true,&quot;del&quot;:true,&quot;search&quot;:true,&quot;refresh&quot;:true,&quot;view&quot;:false,&quot;excel&quot;:true,&quot;pdf&quot;:false,&quot;csv&quot;:false,&quot;columns&quot;:false},{&quot;drag&quot;:true,&quot;resize&quot;:true,&quot;closeOnEscape&quot;:true,&quot;dataheight&quot;:&quot;auto&quot;,&quot;errorTextFormat&quot;:function(r){ return r.responseText;},&quot;height&quot;:&quot;auto&quot;,&quot;width&quot;:&quot;auto&quot;,&quot;reloadAfterSubmit&quot;:true},{&quot;drag&quot;:true,&quot;resize&quot;:true,&quot;closeOnEscape&quot;:true,&quot;dataheight&quot;:&quot;auto&quot;,&quot;errorTextFormat&quot;:function(r){ return r.responseText;},&quot;height&quot;:&quot;auto&quot;,&quot;width&quot;:&quot;auto&quot;,&quot;reloadAfterSubmit&quot;:true},{&quot;errorTextFormat&quot;:function(r){ return r.responseText;}},{&quot;drag&quot;:true,&quot;closeAfterSearch&quot;:true,&quot;multipleSearch&quot;:true},{&quot;drag&quot;:true,&quot;resize&quot;:true,&quot;closeOnEscape&quot;:true,&quot;dataheight&quot;:150});jQuery(&#039;#grid&#039;).jqGrid(&#039;navButtonAdd&#039;,&#039;#pager&#039;,{id:&#039;pager_excel&#039;, caption:&#039;&#039;,title:&#039;Export To Excel&#039;,onClickButton : function(e)
{
try {
jQuery(&quot;#grid&quot;).jqGrid(&#039;excelExport&#039;,{tag:&#039;excel&#039;, url:&#039;grid.php&#039;});
} catch (e) {
window.location= &#039;grid.php?oper=excel&#039;;
}
},buttonicon:&#039;ui-icon-newwin&#039;});jQuery(&#039;#grid&#039;).jqGrid(&#039;footerData&#039;,&quot;set&quot;,{&quot;dpsQuoi&quot;:&quot;Total:&quot;});
});&lt;/script&gt;

&lt;/div&gt;
&lt;div&gt;&lt;/div&gt;
&lt;/html&gt;

2015-09-01{"records":"20","page":1,"total":1,"rows":[{"dpsID":"316","dpsQui":"prs","dpsQuoi":"tpg","dpsPrx":"3.00","dpsQud":"2015-09-01","dpsUbi":"www","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"transports","dpsCtg":"transports publics","dpsGns":"tpg","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"317","dpsQui":"prs","dpsQuoi":"csm prs","dpsPrx":"9.70","dpsQud":"2015-09-01","dpsUbi":"point coop","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"csm","dpsCtg":"prs","dpsGns":"","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"320","dpsQui":"prs","dpsQuoi":"csm prs","dpsPrx":"1.00","dpsQud":"2015-09-01","dpsUbi":"SDL","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"csm","dpsCtg":"prs","dpsGns":"boissons","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"325","dpsQui":"prs","dpsQuoi":"csm prs","dpsPrx":"11.30","dpsQud":"2015-09-02","dpsUbi":"p\u00e2tisserie rue du rh\u00f4ne","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"csm","dpsCtg":"prs","dpsGns":"nourriture","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"326","dpsQui":"prs","dpsQuoi":"dons","dpsPrx":"1.00","dpsQud":"2015-09-02","dpsUbi":"place bel-air","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"rue","dpsGns":"","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"328","dpsQui":"prs","dpsQuoi":"csm prs boissons","dpsPrx":"3.00","dpsQud":"2015-09-02","dpsUbi":"grand-rue","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"csm","dpsCtg":"prs","dpsGns":"boissons","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"330","dpsQui":"prs","dpsQuoi":"parking","dpsPrx":"1.00","dpsQud":"2015-09-05","dpsUbi":"parking cornavin","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"transports","dpsCtg":"voiture","dpsGns":"parking","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"331","dpsQui":"prs","dpsQuoi":"dons qu\u00eate","dpsPrx":"17.00","dpsQud":"2015-09-06","dpsUbi":"Notre-Dame","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"\u00e9glise","dpsGns":"qu\u00eate","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"332","dpsQui":"prs","dpsQuoi":"vincent","dpsPrx":"400.00","dpsQud":"2015-09-05","dpsUbi":"maison","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"enfants","dpsCtg":"vincent","dpsGns":"crt","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"333","dpsQui":"prs","dpsQuoi":"cadeau no\u00e9mie","dpsPrx":"210.00","dpsQud":"2015-09-09","dpsUbi":"la cadrerie","dpsCrdCrt":"1","dpsPaiement":"0","dpsDmn":"cadeaux","dpsCtg":"enfants","dpsGns":"nom\u00e9ie","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"334","dpsQui":"prs","dpsQuoi":"\u00e9glise qu\u00eate","dpsPrx":"10.00","dpsQud":"2015-09-09","dpsUbi":"Saint-joseph Gabrielle Dufour Kowalska","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"\u00e9glise","dpsGns":"qu\u00eate","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"335","dpsQui":"prs","dpsQuoi":"csm prs","dpsPrx":"4.50","dpsQud":"2015-09-09","dpsUbi":"coop rue du rh\u00f4ne","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"csm","dpsCtg":"prs","dpsGns":"nourriture","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"336","dpsQui":"prs","dpsQuoi":"dons","dpsPrx":"2.00","dpsQud":"2015-09-09","dpsUbi":"rue","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"rue","dpsGns":"","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"337","dpsQui":"prs","dpsQuoi":"csm prs nourriture","dpsPrx":"4.75","dpsQud":"2015-09-16","dpsUbi":"p\u00e2tisserie rue du rh\u00f4ne","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"csm","dpsCtg":"prs","dpsGns":"nourriture","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"338","dpsQui":"prs","dpsQuoi":"dons place bel-air cor","dpsPrx":"1.00","dpsQud":"2015-09-16","dpsUbi":"place bel-air","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"rue","dpsGns":"musique","dpsSpc":"cor des alpes","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"339","dpsQui":"prs","dpsQuoi":"cadeau","dpsPrx":"89.00","dpsQud":"2015-09-22","dpsUbi":"la com\u00e9die","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"cadeaux","dpsGns":"anniversaire","dpsSpc":"UJ","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"340","dpsQui":"prs","dpsQuoi":"dons","dpsPrx":"3.00","dpsQud":"2015-09-22","dpsUbi":"la com\u00e9die","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"dons","dpsCtg":"pourboire","dpsGns":"","dpsSpc":"","dpsDfr":"","dpsTag":"pourboire","dpsVcc":"0"},{"dpsID":"341","dpsQui":"prs","dpsQuoi":"t\u00e9l\u00e9phone portable 160120","dpsPrx":"150.00","dpsQud":"2015-09-20","dpsUbi":"www","dpsCrdCrt":"1","dpsPaiement":"0","dpsDmn":"fml","dpsCtg":"160120","dpsGns":"","dpsSpc":"","dpsDfr":"","dpsTag":"","dpsVcc":"0"},{"dpsID":"342","dpsQui":"prs","dpsQuoi":"don cadeau anniversaire marc","dpsPrx":"100.00","dpsQud":"2015-09-22","dpsUbi":"cure ch\u00eane-bourg","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"don","dpsCtg":"cadeau","dpsGns":"anniversaire","dpsSpc":"marc passera","dpsDfr":"","dpsTag":"don cadeau anniversaire","dpsVcc":"0"},{"dpsID":"343","dpsQui":"prs","dpsQuoi":"don \u00e9cole vente p\u00e2tisseries","dpsPrx":"5.00","dpsQud":"2015-09-23","dpsUbi":"pont-de-la-machine","dpsCrdCrt":"0","dpsPaiement":"0","dpsDmn":"don","dpsCtg":"rue","dpsGns":"\u00e9cole ","dpsSpc":"vente de p\u00e2tisseries","dpsDfr":"","dpsTag":"don rue \u00e9cole","dpsVcc":"0"}]}<table id='grid'></table>

<div class="ui-state-error">'+ xhr.responseText +'</div>

', jQuery.jgrid.edit.bClose,{buttonalign:'right'});} catch(e) { alert(xhr.responseText);} },"pager":"#pager"});jQuery('#grid').jqGrid('navGrid','#pager',{"edit":true,"add":true,"del":true,"search":true,"refresh":true,"view":false,"excel":true,"pdf":false,"csv":false,"columns":false},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":"auto","errorTextFormat":function(r){ return r.responseText;},"height":"auto","width":"auto","reloadAfterSubmit":true},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":"auto","errorTextFormat":function(r){ return r.responseText;},"height":"auto","width":"auto","reloadAfterSubmit":true},{"errorTextFormat":function(r){ return r.responseText;}},{"drag":true,"closeAfterSearch":true,"multipleSearch":true},{"drag":true,"resize":true,"closeOnEscape":true,"dataheight":150});jQuery('#grid').jqGrid('navButtonAdd','#pager',{id:'pager_excel', caption:'',title:'Export To Excel',onClickButton : function(e)

{

try {

jQuery("#grid").jqGrid('excelExport',{tag:'excel', url:'grid.php'});

} catch (e) {

window.location= 'grid.php?oper=excel';

}

},buttonicon:'ui-icon-newwin'});jQuery('#grid').jqGrid('footerData',"set",{"dpsQuoi":"Total:"});

});</script>

</div>

</html>

Where comes the problem from?

Thank you very much for your answer.

Regards.

Jean Lathion

This topic was modified 10 years, 8 months ago by tony.
This topic was modified 10 years, 8 months ago by tony. Reason: formatting code

Creator

Topic

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

Author

Replies
September 24, 2015 at 4:03 pm #124387

tony
Keymaster

Hello,

Please remove any echo and print_r commands.

You have in the code

... echo $tpsDbt; ...

1
2
3

...
echo $tpsDbt;
...

Remove or comment this.

Kind Regards,

September 24, 2015 at 4:14 pm #124388

JL
Participant

Hello,

It works!

Thank you very much for your help.

And… sorry for my stupid mistake.

Kind regards.

Jean Lathion
Author

Replies

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

You must be logged in to reply to this topic.

Stay connected with us in your favorite flavor!

jqgrid passIng two parameters SELECT … FROM … WHERE … = $param1,$param2

Search Forum

Recent Replies

Forum Statistics

UserOnline