Guriddo » SyberMafia's Replies

SyberMafia

Guriddo

Forum Replies Created

Viewing 1 replies (of 1 total)

Author

Replies

March 8, 2021 at 5:52 pm in reply to: master – detail problem #127579

SyberMafia

Participant

thank you. I hadn’t noticed this. Now there is another problem.

&lt;?php
require_once &#039;jq-config.php&#039;;
require_once &quot;php/PHPSuito/jqGrid.php&quot;;
require_once &quot;php/PHPSuito/DBdrivers/jqGridMysqli.php&quot;;
$conn = new mysqli(&#039;localhost&#039;, &#039;root&#039;, &#039;&#039;, &#039;operasyontakip&#039;);
$conn-&gt;query(&quot;SET NAMES utf8&quot;);
$islem_kodu = jqGridUtils::GetParam(&quot;IS_EMRI_KODUM&quot;);
$islem_ismi = jqGridUtils::GetParam(&quot;IS_EMRI_ISMIM&quot;);
$grid = new jqGridRender($conn);
$grid-&gt;SelectCommand = &quot;SELECT * FROM is_emri_yapilacak_operasyonlar WHERE YOP_IS_EMRI_KODU= ? AND YOP_IS_EMRI_ISMI= ? &quot;;
$grid-&gt;dataType = &#039;json&#039;;
$grid-&gt;setColModel(null,array($islem_kodu,$islem_ismi));
$grid-&gt;queryGrid();
$grid-&gt;setUrl(&#039;sayfa3subgrid.php&#039;);
$grid-&gt;setColProperty(&quot;YOP_ID&quot;, array(&quot;label&quot;=&gt;&quot;NO&quot;, &quot;width&quot;=&gt;70));
$grid-&gt;setColProperty(&quot;YOP_IS_EMRI_KODU&quot;, array(&quot;label&quot;=&gt;&quot;İŞ EMRİ KODU&quot;));
$grid-&gt;setColProperty(&quot;YOP_IS_EMRI_ISMI&quot;, array(&quot;label&quot;=&gt;&quot;İŞ EMRİ İSMİ&quot;));
$grid-&gt;setColProperty(&quot;YOP_OP_NO&quot;, array(&quot;label&quot;=&gt;&quot;OPERASYON ADI&quot;));
$grid-&gt;setColProperty(&quot;YOP_ISLEM_MERKEZ_NO&quot;, array(&quot;label&quot;=&gt;&quot;OPERASYON İŞLEMİ&quot;));
$grid-&gt;setSelect(&#039;YOP_OP_NO&#039;, &quot;SELECT OP_NO, OP_ADI FROM operasyonlar&quot;);
$grid-&gt;setSelect(&#039;YOP_ISLEM_MERKEZ_NO&#039;, &quot;SELECT OP_ISLEM_MERKEZ_NO, OP_ISLEM_MERKEZ_OP_ADI FROM operasyon_islem_merkezi&quot;);
$grid-&gt;setGridOptions(array(&quot;caption&quot;=&gt;&quot;YAPILACAK OPERASYONLAR&quot;,&quot;rowNum&quot;=&gt;20,&quot;hoverrows&quot;=&gt;true,&quot;width&quot;=&gt;600,&quot;height&quot;=&gt;200));
$grid-&gt;renderGrid(&quot;#detail&quot;,null, true, null, array($islem_kodu,$islem_ismi), true,true);
?&gt;

<?php

require_once 'jq-config.php';

require_once "php/PHPSuito/jqGrid.php";

require_once "php/PHPSuito/DBdrivers/jqGridMysqli.php";

$conn = new mysqli('localhost', 'root', '', 'operasyontakip');

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

$islem_kodu = jqGridUtils::GetParam("IS_EMRI_KODUM");

$islem_ismi = jqGridUtils::GetParam("IS_EMRI_ISMIM");

$grid = new jqGridRender($conn);

$grid->SelectCommand = "SELECT * FROM is_emri_yapilacak_operasyonlar WHERE YOP_IS_EMRI_KODU= ? AND YOP_IS_EMRI_ISMI= ? ";

$grid->dataType = 'json';

$grid->setColModel(null,array($islem_kodu,$islem_ismi));

$grid->queryGrid();

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

$grid->setColProperty("YOP_ID", array("label"=>"NO", "width"=>70));

$grid->setColProperty("YOP_IS_EMRI_KODU", array("label"=>"İŞ EMRİ KODU"));

$grid->setColProperty("YOP_IS_EMRI_ISMI", array("label"=>"İŞ EMRİ İSMİ"));

$grid->setColProperty("YOP_OP_NO", array("label"=>"OPERASYON ADI"));

$grid->setColProperty("YOP_ISLEM_MERKEZ_NO", array("label"=>"OPERASYON İŞLEMİ"));

$grid->setSelect('YOP_OP_NO', "SELECT OP_NO, OP_ADI FROM operasyonlar");

$grid->setSelect('YOP_ISLEM_MERKEZ_NO', "SELECT OP_ISLEM_MERKEZ_NO, OP_ISLEM_MERKEZ_OP_ADI FROM operasyon_islem_merkezi");

$grid->setGridOptions(array("caption"=>"YAPILACAK OPERASYONLAR","rowNum"=>20,"hoverrows"=>true,"width"=>600,"height"=>200));

$grid->renderGrid("#detail",null, true, null, array($islem_kodu,$islem_ismi), true,true);

If I use the query with two parameters


$grid-&gt;SelectCommand = &quot;SELECT * FROM is_emri_yapilacak_operasyonlar WHERE YOP_IS_EMRI_KODU= ? AND YOP_IS_EMRI_ISMI= ? &quot;;

1 2	$grid->SelectCommand = "SELECT * FROM is_emri_yapilacak_operasyonlar WHERE YOP_IS_EMRI_KODU= ? AND YOP_IS_EMRI_ISMI= ? ";

alert box, an error message appears, but the results are correct, the detail grid is empty.


Could not execute query!!!{&quot;records&quot;:2,&quot;page&quot;:1,&quot;total&quot;:1,&quot;rows&quot;:[{&quot;YOP_ID&quot;:1,&quot;YOP_IS_EMRI_KODU&quot;:&quot;MO0000549 0001&quot;,&quot;YOP_IS_EMRI_ISMI&quot;:&quot;MO2021-549 evrak nolu üretim talebi ile üretilen 2305030100001585&quot;,&quot;YOP_OP_NO&quot;:&quot;012&quot;,&quot;YOP_ISLEM_MERKEZ_NO&quot;:&quot;02&quot;},{&quot;YOP_ID&quot;:2,&quot;YOP_IS_EMRI_KODU&quot;:&quot;MO0000549 0001&quot;,&quot;YOP_IS_EMRI_ISMI&quot;:&quot;MO2021-549 evrak nolu üretim talebi ile üretilen 2305030100001585&quot;,&quot;YOP_OP_NO&quot;:&quot;012&quot;,&quot;YOP_ISLEM_MERKEZ_NO&quot;:&quot;03&quot;}]}

Could not execute query!!!{"records":2,"page":1,"total":1,"rows":[{"YOP_ID":1,"YOP_IS_EMRI_KODU":"MO0000549 0001","YOP_IS_EMRI_ISMI":"MO2021-549 evrak nolu üretim talebi ile üretilen 2305030100001585","YOP_OP_NO":"012","YOP_ISLEM_MERKEZ_NO":"02"},{"YOP_ID":2,"YOP_IS_EMRI_KODU":"MO0000549 0001","YOP_IS_EMRI_ISMI":"MO2021-549 evrak nolu üretim talebi ile üretilen 2305030100001585","YOP_OP_NO":"012","YOP_ISLEM_MERKEZ_NO":"03"}]}

If I use the query with a single parameter, there is no problem.


$grid-&gt;SelectCommand = &quot;SELECT * FROM is_emri_yapilacak_operasyonlar WHERE YOP_IS_EMRI_KODU= ? &quot;;

1 2	$grid->SelectCommand = "SELECT * FROM is_emri_yapilacak_operasyonlar WHERE YOP_IS_EMRI_KODU= ? ";

my queries and parameters are correct, the result is returned but not written into the grid. writes on the screen in the form of error.
Why can’t I use a two parameter query? Is there a bug?
The Guriddo Suito PHP script on the site has expired. I downloaded it but the writes script expired. Is it possible for you to update?

Author

Replies

Viewing 1 replies (of 1 total)