How to pass record Id using GET into sql query

[Rangga Stephen]

Hello sir, how to pass record Id using php GET into sql query in Report Viewer, please see picture attachment.
I'am beginner using your report for Php. I'am using JS version. Thank you.

[Rangga Stephen]

Picture attachment

pic2.png (29.9 KiB) Viewed 12179 times

[Lech Kulikowski]

Hello,

You can use the following query:
SELECT * FROM table WHERE Id={papar}

And on the server side in handler.php use:

Code: Select all

$handler->onBeginProcessData = function ($event) {
    $event->parameters["papar"] = $_GET["papar"];
    
    return StiResult::success();
};

In this case, parameters will be filled on the server side before data request.

Thank you.

[Rangga Stephen]

hello sir, thank you for your reply. I try your solution but still not working. I got "Index Not define Error"..please see picture attachment..

err.png (44.68 KiB) Viewed 12135 times

[Rangga Stephen]

Here is my Handler.php...please see picture attactment

anw2.png (104.19 KiB) Viewed 12135 times

Am I missing something.. Btw can you give me a sample small project. Thank You..Sorry for my English. I am from Malaysia.

[Lech Kulikowski]

Hello,

You should correct viewer.php, that send paramters in handler.php:
$options->handler = "handler.php?papar=".$_GET["papar"];

Please check the sample project in the attachment.

Thank you.

[Rangga Stephen]

Thank you sir . You save my day. Now its working as expected.. Thanks for great support..

[Edward]

Hi Rangga Stephen,

No problem, please let us know if you need any help.

Thank you,
Edward