Page 1 of 1
How to pass record Id using GET into sql query
Posted: Thu May 24, 2018 8:58 am
by 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.
Re: How to pass record Id using GET into sql query
Posted: Thu May 24, 2018 2:41 pm
by Rangga Stephen
- Picture attachment
- pic2.png (29.9 KiB) Viewed 22708 times
Re: How to pass record Id using GET into sql query
Posted: Fri May 25, 2018 1:30 pm
by 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.
Re: How to pass record Id using GET into sql query
Posted: Mon May 28, 2018 12:38 am
by 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 22664 times
Re: How to pass record Id using GET into sql query
Posted: Mon May 28, 2018 12:41 am
by Rangga Stephen
Here is my Handler.php...please see picture attactment
- anw2.png (104.19 KiB) Viewed 22664 times
Am I missing something.. Btw can you give me a sample small project. Thank You..Sorry for my English. I am from Malaysia.
Re: How to pass record Id using GET into sql query
Posted: Tue May 29, 2018 2:10 pm
by 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.
Re: How to pass record Id using GET into sql query
Posted: Thu May 31, 2018 1:50 am
by Rangga Stephen
Thank you sir . You save my day. Now its working as expected.. Thanks for great support..
Re: How to pass record Id using GET into sql query
Posted: Thu May 31, 2018 6:05 am
by Edward
Hi Rangga Stephen,
No problem, please let us know if you need any help.
Thank you,
Edward