Fetching Perameter form URL for prepared statment

[kunwars...@gmail.com]

Hi,

How can I get the parameter passed in URL?
example loclhost/fusio/public/index.php/test1?Name=abcd
where Test1 is action rout and Name is a variable (must be treated as one and ABCD s value.

[kunwars...@gmail.com]

This is useful when preparing a fetch prepared statment

[kunwars...@gmail.com]

Please verify if this works?
select rfiduid from rfid_uid where rfiduid = {{ request.uriFragment("Name")|prepare }}

On Thursday, November 10, 2016 at 5:58:05 AM UTC-8, kunwars...@gmail.com wrote:

[Christoph Kappestein]

Hi,

so in order to access GET parameters in the SQL action you have to use the parameters property i.e.:

SELECT rfiduid FROM rfid_uid WHERE rfiduid = {{ request.parameters.get('Name')|prepare }}

best regards

Christoph

 

[kunwars...@gmail.com]

Tried :
http://localhost/api/public/index.php/validate_rfid/?Name=1234fdsa
Getting:

{
    "success": false,
    "title": "Internal Server Error",
    "message": "Entry not available"
}
Query working fine:
SELECT rfiduid FROM rfid_uid WHERE rfiduid = '1234fdsa' 

[Christoph Kappestein]

So it looks like there is no entry in the table with the id

rfiduid = '1234fdsa'

Could you test this with an id of an existing row?

[Er. Surya Partap Singh Pathania]

Actually there is an entry in the table. I am give you access and probably you can see it , ideally it should come with response.

[kunwars...@gmail.com]

Can you please help with issue identification? is there anyway I can send you login details?

[Dejan Gambin]

Hi

I am also trying to use GET parameters in my select statement but it doesn't work with {{request.parameters.get('some_param'}}

Am I doing something wrong?

regards, dejan